December 10, 2008 at 7:07 am
We have a Active/pasive cluster on windows 2k3 running SQL 2000. We need to disable user access to the user databases so that we can do a full backup of the database. Then we are restoring these databases to a new set of hardware that we previously restore an older back of the user databases to for testing the setup.
Any suggestions as to the best way to do this is greatly appreciated.
December 10, 2008 at 7:26 am
Why do you need to prevent users accessing the DB to do a backup?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 10, 2008 at 7:29 am
Good question Gail. I'd guess they don't want any changes made before the cutover to the new hardware?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 10, 2008 at 7:46 am
In that case, set the database to restricted users before starting the backup. That means that only members of db_owner, db_creator and sysadmin may access the DB.
If that's not enough, make the DB single user. Just be sure that you get the sole connection for the backup.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 10, 2008 at 8:29 am
Thank you for your help and the quick replies.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply