SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

3 Posts

Posted - 01/08/2006 :  04:34:11  Show Profile  Reply with Quote
How can I check whether some backup database was made with mediapassword. If that is so, how can I get this mediapassword?


United Kingdom
12543 Posts

Posted - 01/08/2006 :  09:01:50  Show Profile  Visit nr's Homepage  Reply with Quote
I'm guessing that if you try a restore (header or filelist maybe) then it will tell you that it needs a pasword.
Wouldn't be much of a password if you could retrieve it but maybe someone knows a way.

Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

Posting Yak Master

158 Posts

Posted - 01/09/2006 :  01:34:12  Show Profile  Reply with Quote
As far as I know, the Restore/Backup process will prompt you for the media password

Wouldn't be much of a password if you could retrieve it

Enough Said!

If you want your computer to be faster then throw it out of the window.
Go to Top of Page

Starting Member

3 Posts

Posted - 01/09/2006 :  02:04:32  Show Profile  Reply with Quote
Thanks very much for replay.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000