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 |
|
rushdib
Yak Posting Veteran
93 Posts |
 Posted - 2004-01-26 : 09:53:54
|
| Hi,We do a SQL Server back up everyday, which we keep for a week.We also back up the folders on a tape everyday. The Friday's back up folder, we keep for 4 weeks.I am doing a test on the tape back up. I copied the .bak file and .trn file from the tapes to the SQL back up folder, but I can't seem to restore?How do I do a restore using .bak files?Thank you,Rushdi |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-26 : 12:18:16
|
| What is the command that you are running?Tara |
 |
|
|
rushdib
Yak Posting Veteran
93 Posts |
Posted - 2004-01-26 : 12:28:19
|
| I tried from the EM using the database - restore option. It shows me only the .bak files which currently backed up. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-26 : 12:31:40
|
| Why not use Query Analyzer for this? Anyway, in EM, when you go to From device, then select devices, does the next screen allow you to select tape option? If not, then the server doesn't have a DLT. Is the DLT on a remote server? If so, then you'll need to copy the files from tape to the local drives, then perform the RESTORE.Tara |
|
|
|
rushdib
Yak Posting Veteran
93 Posts |
Posted - 2004-01-26 : 13:32:29
|
| Tara, I am doing the restore on a test server. I was able to recover the files in a long procedure.I created a blank database using the same name as the original db, and detached the databaseand used the following command:restore database dbname from disk = '//network id/folder/dbback name.bak'The restore completed successfully, but I couldn't attach the db.Then I went to EM and restored the database using the .bak file.I don't think we have DLT. The tape backs up the whole folder. I was able to move the back up folder to a local folder, which contained the .bak file and the .trn file.Rushdi |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-26 : 13:35:18
|
| Why would you attach a database after a restore? If you have the MDF file, then you perform an attach. If you have the BAK file, then you perform a restore. You don't perform both in either situation.Tara |
|
|
|
|
|
|
|
|
Back up on tapes