Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Aigini
Starting Member
2 Posts |
 Posted - 2008-06-05 : 05:15:28
|
| I had been trying to restore a SQL Server 2000 database with the name LLB, which is not listed in the drop down list (Restore As Database). This, of course I tried using SQL Server Enterprise Manager. I created the new database using Database - New Database under local (SQL Server Group). Then I go to Database - Restore Database. The new name is already in the drop down list, but when I click Ok to complete the Restore Database, an error message pops up saying 'You must select a backup set to restore'. I do not know how to correct this error or how to successfully restore the database with the name LLB. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-05 : 10:19:09
|
| Where is your backup set? You have to specify while restoring?It's not necessary to create database. |
 |
|
|
kick7502001
Starting Member
3 Posts |
Posted - 2008-06-05 : 15:48:57
|
| You might need to select "from device", then "disk", and restore that way. |
|
|
|
monty
Posting Yak Master
130 Posts |
Posted - 2008-06-06 : 02:17:03
|
| my suggestion would be to use TSQL to restore as even if it fails restoring you vil have a detailed error message to troubleshoot on urself or through some one.. dont go for GUI'sits me monty |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-06 : 09:02:04
|
quote:
Originally posted by monty
my suggestion would be to use TSQL to restore as even if it fails restoring you vil have a detailed error message to troubleshoot on urself or through some one.. dont go for GUI'sits me monty
Why?? Guess it should be easier. |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2008-06-06 : 16:59:40
|
| This is a step by step walk through,Manually type your DB name in "Restore As Database" , If this is a database from a different server you have to go through the process of selecting the backup device. From the Restore Database window. Select "From Device" -> Click "Select Devices" -> Click "Add" -> The "File Name" Radio button should be checked. -> Click the "..." -> Browse to the location of the file name Double Click on the correct .bak file. -> Click "ok" twice (back to the restore database initial window -> You will have to choose the name of your database, existing or new.Clicking Ok then should create/ restore your data. |
|
|
|
|
|
|
Restoring SQL Server 2000 with a new name