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 2000 Forums
 SQL Server Administration (2000)
 weird restore behavior

Author  Topic 

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-06-29 : 05:32:30
i was trying out the password option for backup and i've noticed that
if i use restore filelistonly, i get invalid password
but if i use restore headeronly i see the backupsets

what do you make of this?

--------------------
keeping it simple...

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2005-06-29 : 06:19:43
I believe it is the backup set that is password protected, not the backup files, so it sounds normal that you coud see the backup set header info, but not the data inside the backup set.

CODO ERGO SUM
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-06-30 : 05:52:43
thanks MVJ

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -