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 |
|
zeeshan13
Constraint Violating Yak Guru
347 Posts |
 Posted - 2008-04-09 : 10:39:12
|
| Hi All,This is reletaed to SQL Server 2005.I have a backup file that does not have any .bak extension and I am trying to restore it against a already existing DB. Thats the first time I am dealing with a backup that does not have a .bak extension and I dont know how to restore it. The .bak backups are easy to restore and I restore it in SQL 2005 managment studio with the following steps;a) I right clicking on the existing database (where I want it to be restored) and b) then click Tasks , c) click Restore, and d) click Database, and e) then in the restore database window click 'From device', f) then click '...' to browse and g) click add to browse and add the backup file to be restored.I am doing the above steps for the non .bak extension backup file but I am unable tio add the file?In SQL 2005 managment studio how can I restore a backup (that doesn't have .bak extension) against a exsisting database? Please help.Thanks a million.Zee |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 10:52:32
|
| Always put .BAK extension in your backup files.For this scenerio:When you add the file, Choose all file type- you will be able to see all file type and restore. |
 |
|
|
zeeshan13
Constraint Violating Yak Guru
347 Posts |
Posted - 2008-04-09 : 15:32:17
|
| sodeep,Thanks for the help.... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-09 : 17:04:07
|
| It doesn't matter what extension you use for the backup file name. BAK is common, but back in the day we used DAT. Some people use BKP. But it doesn't matter what you pick.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 17:13:14
|
| Agreed. But most of DBAs use .BAK extension and while restoring through GUI ,you won't have to select all file types and choose file.As .BAK extension comes by default.and I think DAT is for SQL 6.5 (but doesn't matter you can keep any name) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-09 : 17:23:20
|
| Most DBAs don't need a GUI. Restore and backup command is about the easiest there is.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 17:46:01
|
| Not really. |
|
|
|
|
|
|
How to restore a backup that doesnt have .bak ext?