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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Unable to see the backup versions? Need Help

Author  Topic 

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2007-05-31 : 08:50:09

Frns

Currently i am working with Sql Server 2005 and i am taking daily backups which is going
append same backup file <DB_NAME>.BAK.

Now i am trying to restore this bkp with a new database name and with 2 days before date
image.When i am trying to do that, sql server is not showing the versions of the backups.

Why? is there any reason for that?

Regards,
franky

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-31 : 09:59:52
Ues 'restore headeronly' to get file number to restore.
Go to Top of Page
   

- Advertisement -