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 |
|
shahram3000
Starting Member
1 Post |
 Posted - 2008-01-31 : 00:57:22
|
| Hi there,I have sent a mssql backup file in .bak format to my host admin and asked them restore it. but they told me there are 3 files with 3 different dates in that backup what does it mean? should I ask them to restore all of them or just the last one?Thanks very much in addvance(context: MS SQL 2005 express)CheersShahram |
|
|
pravin14u
Posting Yak Master
246 Posts |
Posted - 2008-01-31 : 01:11:26
|
| In SQL 2005, you can backup a database multiple times on the same name and while restoring it gives you an option to choose which version needs to be restored.If you want the last backup of yours to be restored, then YES, you shold ask them to restore the last one. |
 |
|
|
pravin14u
Posting Yak Master
246 Posts |
Posted - 2008-01-31 : 01:15:49
|
| Some one please correct me if I am wrong. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-02 : 00:11:01
|
| You can append multiple backups in single backup file, all version of sql server work that way. To restore specific backup, just use 'with file = ' option in restore statement. |
|
|
|
|
|
|
different files in one backup (MS SQL 2005)