I am wondering how to setup the backup process, so that
when anyone is trying to restore the database will be
prompted for a password.
This can be done through T-SQL, but I am wondering how it
can be done through enterprise manager.
I don't think this is possible in SQL Server 2000. (Using Enterprise
Manager that is)
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
One of our production databases is hanging while using EM to get a list of
the available backups on its database. I traced the problem to the number of
entries in our msdb database. I have written and tested a script to elimate
older records in the backup list through 7 different table and it alleviates
Is there any supported utility that does a similar cleanup of msdb backup
records. I would rather use a tried and tested solution.
SQL Server 7.0 SP2
Thanks in advance,