Database Restore && Attach Error
Apr 13, 2003
Database Restore & Attach Error
I have a problem with restoring or attaching DB files from different version of the engine. I Have a existing SQL server 7.x and another one is SQL 2000 but I try to backup my database and restore it into the 2000 engine This is the following Problem which occurs :-
1st Problem : During Restoration, The restoration process was runing fine until it reach the last inficatior tab and it fail and say Database terminated abnormal. I been try to restore into other machine also but it give me the same problem.
2nd Problem : Say I can't restore but I stop the engine and manual copy the *.mdf and *.ldf to another machine. I try to restore it but it "is on a network device not supported for database files." So what shall I Do with it.
Pls Advise If anything need to be done before I do the restoring and anything need to be done in both 7.x and 2000 Engine.
:confused:
View 1 Replies
ADVERTISEMENT
Jul 15, 2006
I'm trying to see the differences between Backup/Restore and Attach/Detach. I backup and detach a database from SQL Server 2000 SP3 and then attach and restore it to SQL Server 2005 SP1.
The differences I noticed are:
1. The restored database has a much larger initial size (database size is same) for data and log.
2. The attached database has a last backup date
3. If the backup is restored over a database, the restored database is showing owned by the database owner of the database restored over but syslogins and sysusers do not match.
I don't understand why #1 happens.
Are there any other differences between Backup/Restore and Attach/Detach?
Thanks,
Peter
View 2 Replies
View Related
May 7, 2008
Hello there,
I've some really big problems with SQL Server 2005 Express. I Recently, I had 2 instances on my machine, one was a SQL Server 2000 Developer and the other a 2005 Express Version. The 2000 version was not necessary anymore, so I unstalled it, since then, the Express version keeps having probems.
Under the Server Properties -> Database settings -> Database Locations I've changed the path to D:sqldatamssql, but now, the programm always takes the "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData" to store and load the databases, no matter what I do.
And there are more problems see here:
Restoring does not work=======================
I wanted to restore a database called "fw40_admin" from a backup file (.bak), but that didn't work at all, it always says this as an error:
"System.Data.SqlClient.SqlError: The operating system returned the error '5(error not found)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'D:sqldatamssqlfw40_admin.mdf'. (Microsoft.SqlServer.Express.Smo)"
But as soon as I type in the installation path "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData" inside the "Restore As" under "Options", it works.
Why does the backup only work in "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData", BUT the database locations under the server properties is indicated with "D:sqldatamssql"????
Attaching does not work=======================
Attaching an existing database does not work either. Most databases (mdf) are located on the path D:sqldatamssql, but as soon as I press
Attach Databases -> Add
The dialog window appears with the "D:sqldatamssql" path, but it is unable to find any *.mdfs altough THERE ARE .mdfs in this directory. But Express can find databases in the selected installation: "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData".
Why can't Express see the directory on the D: partition???
What is wrong? Here? Can anybody help me?
View 5 Replies
View Related
Jun 16, 2005
I am trying to attach a database to SQLEXPRESS. I get an error, [Directory Lookup for the file C: . . . DataORION.mdf" failed with the operating system error 5(Access is denied.)]
I tried to attach another database and got the same error. I have attached databases to SQLEXPRESS before successfully. I tried to attach using single file to no avail.
I am using the query, "sp_attach_db @dbname=N'ORION', @filename1=N'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataORION.MDF'
go"
ORION.mdf is in the Data folder for SQLEXPRESS
What am I doing wrong or what did I change inadvertently to restrict my access to the file?
Randy Fair
View 6 Replies
View Related
Oct 27, 2007
Hi!
I created one database on one server which system working with Win2003server. Now I tried to attach the database to another server which is working with WinXP SP2, I got this error
'Msg 5120, Level 16, State 101, Line 1
Unable to open the physical file "E:ASPNETDB.MDF". Operating system error 5: "5(Access is denied.)".
Msg 911, Level 16, State 1, Line 1
Could not locate entry in sysdatabases for database 'Everydayonline'. No entry found with that name. Make sure that the name is entered correctly.'
is anything i am missing while attaching? i just copied the .mdf and .log file from first system to second system. I was tried to make backup of the database and restore, but it was also not workedout. When I tried to restore the database I got this error
'Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "F:ASPNETDB.MDF" failed with the operating system error 3(The system cannot find the path specified.).
Msg 3156, Level 16, State 3, Line 1
File 'ASPNETDB_983ed943e1fe49e3ae7fa189b823b238_DAT' cannot be restored to 'F:ASPNETDB.MDF'. Use WITH MOVE to identify a valid location for the file.
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "F:ASPNETDB_log.ldf" failed with the operating system error 3(The system cannot find the path specified.).
Msg 3156, Level 16, State 3, Line 1
File 'ASPNETDB_TMP_log' cannot be restored to 'F:ASPNETDB_log.ldf'. Use WITH MOVE to identify a valid location for the file.
Msg 3119, Level 16, State 1, Line 1
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.'
Please help me to do this.
View 5 Replies
View Related
Dec 18, 2007
Hi
I Have just detached my SQL Server database, I am currently running SQL Server 2005, when I try to reattach it I get the error Cannnot open user default database - Login Failed
Any ideas.
View 4 Replies
View Related
Feb 25, 2008
need some help with some errors.
Today I recieved this alert from the SQL Server, when I want to attach database:
Server: Msg 823, Level 24, State 6, Line 1
I/O error (torn page) detected during read at offset 0000000000000000 in file 'D:Program FilesMicrosoft SQL ServerMSSQLdataDB Askes Apotik_Data.MDF'.
Connection Broken
I was Running dbcc checkdb repair_allow_data_loss with ALL_ERRORMSGS, NO_INFOMSGS yield the following:
Server: Msg 945, Level 14, State 2, Line 1
Database 'DB Askes Apotik' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Any ideas on how to resolve these errors?
thx
View 15 Replies
View Related
Mar 18, 2004
hi to all
I got a probelm with attaching the database. I hv Database Name called "ABC". it is working fine. (contain MDF,LDF files)
I got new BackFiles from CLient. They sent MDF and LDF Files. But i could't able to attach the database i got the following error while attaching the databse.
Server: Msg 5173, Level 16, State 2, Line 1
Cannot associate files with different databases.
I tried with the following query
EXEC sp_attach_db @dbname = N'ABC',
@filename1 = N'C:DataBaseABC.mdf',
@filename2 = N'C:DataBaseABC_log.ldf'
i Tried with EnterPrise Manager also i got the same error. you can see the attachment file to view the ERROR.
Please Help me .Urgently...
View 1 Replies
View Related
Oct 13, 2015
I copied database .mdf and trying to attached to sql 2012 server but it gives error as attached
tried following
1. added user everyone with full control
2. coping .mdf in sql server default data folder
running sql studio manager in adminstrator
View 1 Replies
View Related
Aug 1, 2006
Hi,
i need to attach my db, but i receive this error:
an error occurred while processing the log for database 'xyj'.
Could not open database 'xyj' . Create database is aborted. (Microsoft Sql Server,
error 9004).
Can you help me?
View 14 Replies
View Related
Aug 23, 2007
We have a log shipping database running on SQL 2000 ENT SP4, the secondary DB is in standby/read only mode . we have a job that runs every day to take it offline, make a copy of the files and attach them as a new database for reporting purposes.
We're planning to upgrade to SQL 2005 however, when we copy the Standby/read only database files and attach using "CREATE DAABASE FOR ATTACH" we get :
msg 1284
Cannot attach a database that was being restored.
this works in SQL 2000 but not SQL 2005, is there a way to force attach the DB ?
Thanks.
View 4 Replies
View Related
Apr 3, 2007
Hi Guys,This is my first post and I hope I'm not going to embarrass myself to much.I am currently writing a pseudo install package for SQL Server Express, it is written in VB.Net 2.0.
I have created an *.exe that fires the SQL Server Express install package silently with command line options, once complete the *.exe copies an *.MDF and an *.LDF to the newly created data directory. Once the data has been copied I fire a "CREATE DATABASE FOR ATTACH" using a SQLClient.SQLCommand to attach my DB. I am using Windows Authentication for SQL Server Express.This all works beautifully when the *.exe is being run from a local hard disk - complete success.When I move the *.exe to a CD it fails . SQL Server is installed correctly, the files are copied to the local hard disk in the correct location. I then fire the "CREATE DATABASE" command - its here I get the error.The error details are:Unable to open the physical file "c:....Exchange.LDF". Operating System error 5:"5(error not found)". Cannot create file "c:....Exchnage.ldf" because it already exists. Change the file path or file name, and retry the operation. Could not open new database 'Exchange'. CREATE DATABASE is aborted. File activation failure. The physical file name "c:....Exchange.LDF" may be incorrect.Remember this works perfectly when run from the local hard disk, this only occurs when running from a CD-ROM.Now from the research I have done I believe it may be a permissions error. The setup *.exe is being run from a Administrator account and the SQL Server DB Engine Service Account is System. I'm under the impression that this should provide more than enough permissions.
Thanks for any help you guys may be able to provide...
Matt.
View 11 Replies
View Related
Jan 29, 2008
Hello.
Our GIS group is working with SQL Server 2005 in conjunction with ESRI's ArcGIS software. SQL Server is being used as a test bed until we formally migrate our existing Microsoft Access mdb's over. So, at this time we are conducting various tests and have the freedom to "blow up" our databases.
We are currently testing ArcSDE Workgroup edition, which will only work with SQL Server Express (SSE). SSE will let us create spatial joins and relationships, while maintaining data integrity. So one possible workaround was to detach the database from SQL Server 2005 and then attach it to SSE. Unfortunately, we ran into a problem in re-attaching the database back to SQL Server 2005.
The exact steps are as follows:
Back up database using back up tool in SQL Server 2005.
Detached database from SQL Server 2005.
Attached database to SQL Server Express (hereafter SSE).
Created a table in database while it was attached to SSE.
Detached database from SSE.
Attempt to attach database to SQL Server 2005 failed
Successfully restored database in SQL Server 2005 using Restore tool.
Step number 6 above failed and generated the following error:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataLNRIS_SQL_Test.mdf'. (Microsoft SQL Server, Error: 5123)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=5123&LinkId=20476
Questions:
Why did I get this error?
Can incorrect or missing permission or ownership settings generate this kind of error?
When should one detach/attach a database?
I welcome your assistance and suggestions.
View 12 Replies
View Related
Aug 1, 2006
Hi,
I've just created my first projects using Visual Studio 2005 and SQL 2005 Express. This is the basic;
One windows service is created that updates a database. The windows service running under "Local system" account
One windows application where a user can see data (and change) from the database
A common business and dataaccess layer/project is used by both applications
Connection string to the database: "Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|DataDatabase.mdf;Integrated Security=True;Connect Timeout=60;User Instance=True"
Both application is located in the same directory. When the computer starts the windows service starts and works perfectly. But when a user starts the windows applications the following error is reported "An attempt to attach an auto-named database for file..A database with the same name exists, or specified file cannot be opened, or it is located on UNC share".
It look likes that only one of my application can connect to the database at a time!
Is it possible to use separate applications to connect to the same database file?
/Robert
View 7 Replies
View Related
Jan 17, 2007
Hello,
I have seen some solutions of which I tried on this form for the error I am receiving, but I still cannot get the issue resolved.
Here is my case:
I developed an app using SQL Express as the local data source. I published it to my server using the Once Click install feature. When I look in my project viewer, under settings, My db connection strings are listed as follows: Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|TAP_Master.mdf;Integrated Security=True;User Instance=True
From another computer, I navigate to the publish site, install and run the application with no problems. I have on another computer, the same app with an updated version number that I wish to publish, however the difference is is that this published version does not include the database as I do not want the end user to overwrite any existing data that they may have from the previous version.
I publish the updated version, install it but when the app runs, I receive the message, "An attempt to attach an auto-named database for file".
Any suggestions?
Thanks in advance.
View 6 Replies
View Related
Nov 5, 2007
Hello, everyone:
I want to move a database instance (about 50 user databases) to another server, both are running SQL Server 2000. Which method is better, retore from backup files or detach/attach? Some papers said restore amybe cause incorrect login and password transfer. Is it true?
Thanks
ZYT
View 5 Replies
View Related
Aug 19, 2002
First, let me say that I have already reviewed information posted by experts within the chat area.
Someone completely deleted my SQL Server 7 database. I retrieved the .LDF and .MDF files from a network backup. Now I am trying to attach the database. I have tried this without creating an instance of the database by using the attach stored procedure to attache the .LDF and .MDF files I retrieved from the network backup. Also, I have tried it by creating an instance of the database and doing a detach of the newly created db .LDF and .MDF files and an attach of the .LDF and .MDF files I retrieved from the network backup. Neither of these approaches have worked.
Here is what I have tried in the Query Analyzer, but to no avail:
For the following example, I created a database instance called 'qarun_diamond_48_brett' with brand new .ldf and .mdf files and then tried to detach and then attach the .ldf and .mdf files from the network backup:
use master
go
sp_detach_db
'qarun_diamond_48_brett', 'F:APPSSQL 7.0DatabaseDataqarun_diamond_48_brett_log.ldf'
Message: Usage: sp_detachdb <dbname>, [TRUE|FALSE]
use master
go
sp_detach_db
'qarun_diamond_48_brett', 'F:APPSSQL 7.0DatabaseDataqarun_diamond_48_brett.mdf'
Message: Usage: sp_detachdb <dbname>, [TRUE|FALSE]
I tried the following attaches of the retrieved/recoverd .ldf and .mdf from the network to the newly created db instance. That didn't work, so I tried attaching to a db that had not yet been created.
use master
go
sp_attach_db
'qarun_diamond_48_brett2', 'F:APPSSQL 7.0DatabaseDataqarun_diamond_48_brett2_log.ldf'
Message: Server: Msg 1801, Level 16, State 3, Line 1
Database 'qarun_diamond_48_brett' already exists.
If I use a different db name I get the following error:
Server: Msg 5105, Level 16, State 13, Line 1
Device activation error. The physical file name 'qarun_diamond_48_brett' may be incorrect.
use master
go
sp_attach_db
'qarun_diamond_48_brett2', 'F:APPSSQL 7.0DatabaseDataqarun_diamond_48_brett2.mdf'
Message: Server: Msg 1801, Level 16, State 3, Line 1
Database 'qarun_diamond_48_brett' already exists.
I have also tried these statements wtih the EXEC sp_attach_db and EXEC sp_detach_db commands from within the Master db in Query Analyzer.
Any help would greatly be appreciated.
Thanks,
-Brett
View 2 Replies
View Related
Jul 7, 2004
Hi,
I was having problems on myt PC so i did a fresh installation. However I had backed up my SQL database (I only have the MDF file and not the log file).
I have tried restoring and attaching options but nothing works :(
I also get the error saying
"Can not open backup device.... Device error or device off-line. See the SQL server error log for more details. RESTORE database is terminating abnormally".
Please this is urgent. WIll be VERY grateful for your urgent reply.
View 7 Replies
View Related
Jul 7, 2004
Hi,
I was having problems on myt PC so i did a fresh installation. However I had backed up my SQL database (I only have the MDF file and not the log file).
I have tried restoring and attaching options but nothing works :(
I also get the error saying
"Can not open backup device.... Device error or device off-line. See the SQL server error log for more details. RESTORE database is terminating abnormally".
Please this is really urgent. Will be VERY grateful for your urgent reply.
View 13 Replies
View Related
Jun 19, 2007
Hi,
I've got a question regarding attaching/restoring of DBs and wonder if anyone could help me out.
Does SQL Server 2000 provide a functionality to attach/restore DB automatically? ie, some kind of polling service to attach/restore DB that were detached previously?
Thanks
Danny.
View 6 Replies
View Related
Aug 22, 2007
Is there a way to automatically enable Service Broker on SQL Server 2005 Express Edition after a database has been attached or restored?
My initial idea was to check if broker is disabled whenever the client application starts and enable it from there but the problem with this is that the current user might not have the required permissions. So now I'm looking for another way to enable it right after restore/attach if at all possible. Any ideas would be appreciated.
View 3 Replies
View Related
Mar 20, 2014
We have 5 databases which will sum up to 8+TB, housed in our EDW server. We are planning to migrate to another storage system for better performance.
I am planning Full backup and Differential backup and detach the DB and restore the DB in the new storage system.
Or should I detach,copy the data and log file and attach the files, will this approach have any advantages ?
View 5 Replies
View Related
Jun 13, 2001
We are taking database backup using SQL backup option and trying to restore the database on another server giving the following error
Microsoft SQL-DMO (ODBC SQL state 42000)
The header for file d:power.mdf is not a valid database file header.The page audit property is incorrect.Restore could not start database "power".Backup or restore operation terminated obnormally
The partition on both servers are same and directory structure also same
Please help
View 1 Replies
View Related
Sep 20, 1999
Hi,
When I restore my database on other sqlserver,the system prompted "The database you are attempting to load was dumped under a different sort order ID(42) than the one current running on this server(52),and at least one of them is a non-binary sort order".
How can I do?
Any help will be appreciated!
View 1 Replies
View Related
Aug 15, 2002
I' have several database to restore. I created scripts.
Here is an example:
RESTORE DATABASE DatabaseName FROM DISK = 'C:DatabaseName.bak'
This is the error message:
Server: Msg 3154, Level 16, State 2, Line 2
The backup set holds a backup of a database other than the existing 'CAMS' database.
Any ideas???
Thanks in advance - Vic
View 2 Replies
View Related
Jan 27, 2007
HI,
While restoring a database from a backup file having extension .back we are getting the following error
"back is not part of the multiple family media set backup with format can be used to form a new media set"
Please guide me how to handle this error.
Thanks,
Karthik
View 1 Replies
View Related
Jan 18, 2006
Hello !
I am just few months started to learn SQL server.
I just attempt to restore a database which I have backuped last week.
The following error appears each time when I was trying Restore it from Hard Disk.
Error :
RESTORE DATABASE must be used in single user mode. when trying restore the master database. RESTORE DATABASE is terminating abnormally.
Please help me to restore my database.
View 8 Replies
View Related
Dec 3, 1999
I'm trying to use schedulled task to automate restore and i keep getting the error database in use, it is set to dbo only and single user, and it has me as the user that has the lock, i have tried to kill it but it won't go, i have even started and stopped the server. any ideas?
View 2 Replies
View Related
Feb 11, 2008
hi.. im having a hard time restoring my .bak file.... i have a stored procedure like this.. and every time i call this in my program an error displays... (database in use. the system administrator must have exclusive use ot the database to run the restore procedure)
CREATE PROCEDURE sp_db_restore
AS
RESTORE DATABASE Inventory
FROM DISK = 'C:MSSQL7BACKUPInventory.bak'
WITH MOVE 'Inventory_data' TO 'C:Inventory_data.mdf',
MOVE 'Inventory_log' TO 'C:Inventory_log.ldf',
REPLACE
'can u pls help me wd this.. tnx
View 4 Replies
View Related
Jul 31, 2006
Hi all,
I am trying to restore and SQL 2000 database into a new SQL 2005 database. I performed by SQL 2000 backup and created a blank database FERS_Production in SQL 2005. FERS_Production was the original name of the database in the SQL 2000 instance.
I have tried giving the new database the same name as the original and a different name to the original database
(Below is the scripted T-SQL that I get from the DB Admin tool
RESTORE DATABASE [Fers_Production]
FILE = N'FERS_Production_dat',
FILE = N'FERS_Production_log'
FROM DISK = N'D:Microsoft SQL Server (2000)MSSQLBackupFers_ProductionFers_Production_db_200607270206.BAK'
WITH FILE = 1,
NOUNLOAD,
REPLACE,
STATS = 10
GO
When I run this I get the following error.
Msg 3154, Level 16, State 4, Line 1
The backup set holds a backup of a database other than the existing 'Fers_Production' database.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Other searches I have performed trying to fix this problem have said to use the REPLACE clause with the RESTORE DATABASE command, but as you can see I am doing that.
Also I no longer have SQL 2000 installed so I cannot try to do a DTS copy which was another suggestion I came across.
Any help is much appriciated, many thanks
Derek
View 17 Replies
View Related
Jun 4, 2008
hi
i have restore database use backup file in another machine of same name of database there following error
TITLE: Microsoft SQL Server Management Studio
------------------------------
Restore failed for Server 'database name'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The backup set holds a backup of a database other than the existing 'dbname' database.
RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3154)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=3154&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
View 1 Replies
View Related
Nov 18, 2007
Hi experts,
I had a database in sql server 2005 under instance name 'rohitcvman'. I took its backup. The computer is formatted and sql server 2005 is installed again with instance name 'rtamrakarcvmanager'. When I try to restore it, it ends up with the following message (copied from message box).
TITLE: Microsoft SQL Server Management Studio
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
Too many backup devices specified for backup or restore; only 64 are allowed.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3205)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0194&EvtSrc=MSSQLServer&EvtID=3205&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
I also have its 'MDF' and 'LDF' file. When I try to attach it, I get the following message:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Attach database failed for Server 'rtamrakar'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Could not find row in sysindexes for database ID 15, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Could not open new database 'CVManager'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
I have not tried to restore/attach in the same instance name from which it was backed up. Is it compulsory to have same instance name to attach/restore?
Can any one help me?
Thank you.
View 13 Replies
View Related
