May 31, 2005 at 1:45 pm
I have to SQL servers(lets call them SQL1 and SQL2). I backed up on SQL one, moved the file to SQL2. SQL1 was old and have no space. When I went to SQL2 and tried to use SQL's restore utility, it keep giving me errors, saying the file I specified is not correct. I tried the "Attach DB" method but I am getting error as well. Would appreciate it if someone could point me to a place where there step by step instructions for me to follow and get this done.
I am using SQL2000 on Win2003. Thanx.
- Res
May 31, 2005 at 1:59 pm
Did you do a full backup of the database, or a detach? If you did a full backup, did you give it a unique name, or did you use an existing backup?
May 31, 2005 at 2:02 pm
I used a full backup and gave it a unique name
May 31, 2005 at 2:14 pm
During the restore, after you have chosen the backup file and you're back to the main "Restore database" window, how many items are listed when you click on the "View Contents..." button on the "General" tab?
As a test, you may also want to backup a database on that machine and try to restore it (with a different name of course).
May 31, 2005 at 2:21 pm
Also, when you are restoring on server SQL2, make sure that you check the paths listed in the Restore As area on the Options tab. If these drives and aths do not match up exactly, you have to correct them in the Options tab before restoring (this is the equivalent of the 'with move' option on a t-sql restore).
It retains these paths in the backup file from the original server (SQL1), so you have to tell it that they've changed (on SQL2), if that is the case.
May 31, 2005 at 2:25 pm
For more of a step by step guide, check out 'copying databases, overview' (search) in Books Online. It gives a good overview, with examples in T-SQL and Enterprise Manager.
May 31, 2005 at 2:27 pm
i think I must create a new database first on SQL2 and then restore the backup Db into this new DB? That is what I did, because the restore DB dialogue box as a field that says "Restore as database", which must be filled.
Then I choose "Database - complete" under Restore backup set,
I am still workingon the restore now but wanted to make sure I am on the right track regarding having to create a new db
May 31, 2005 at 2:28 pm
Thanks, will check out step-by-step instructions on Book online.
May 31, 2005 at 2:30 pm
You shouldn't have to create a new database. You can Right Click on Databases, then choose All Tasks => Restore Database. You can enter whatever name you want to in the Restore As Database section on the General tab.
May 31, 2005 at 2:42 pm
it worked! Thanks so much. The Restore as paths were the problem. I changed to reflect new server SQL installation path and that resolved the problem. Again, many thanks.
- Res
June 1, 2005 at 2:47 am
h!!,
When you try to restore SQL1 backup in SQL2 server by default the mdf and ldf file locations 'll point towards SQL1 server's data file and log file location. In this senario you have to do the following steps..
1) while restoring database click options, in move to physical file location give the path were the data file and log file are located in SQL2 server ..
regards,
Vinod S.R (DBA)
HTC Global Services Chennai
Ph:09840856202
June 1, 2005 at 2:48 am
h!!,
When you try to restore SQL1 backup in SQL2 server by default the mdf and ldf file locations 'll point towards SQL1 server's data file and log file location. In this senario you have to do the following steps..
1) while restoring database click options, in move to physical file location give the path were the data file and log file are located in SQL2 server ..
regards,
Vinod S.R (DBA)
HTC Global Services Chennai
Ph:09840856202
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply