Uraken Posted March 2, 2007 Posted March 2, 2007 I have recently for my own piece of mind been revisiting my disaster recovery strategy and so attempted to restore my sims database from a recent back up i use arcserve to backup and it seems to work without fault however in order to recover i need exclusive access to the sims database when i use sql manager to attempt this it tells me that it can't be in single use mode while others are logged on, its quite late and no-one is logged on how can i force it to kill any sessions it thinks it has? thanks in advance.
NetworkGeezer Posted March 2, 2007 Posted March 2, 2007 Others will correct me if I'm wrong but I don't think it matters. Whe you recover you will be overwritting the live database anyway. Proabably just restarting the SQL Server service should be ebough. Also temporarily change the permissions for the S: drive.
Mcshammer_dj Posted March 6, 2007 Posted March 6, 2007 It is also possible to run a scheduled DB attach backup to create a backup of the SIMS database that can be copied to the tape. Our schools use this system to ensure that the database is live at all times and data can be backed up.
Mcshammer_dj Posted March 6, 2007 Posted March 6, 2007 It is also possible to run a scheduled DB attach backup to create a backup of the SIMS database that can be copied to the tape. Our schools use this system to ensure that the database is live at all times and data can be backed up.
Uraken Posted March 6, 2007 Author Posted March 6, 2007 ah ok does this get around the database being locked all the time?
Mcshammer_dj Posted March 6, 2007 Posted March 6, 2007 yeah cause you are working within the database. This routine uses the SIMS built in sql users. It is also worth considering any other product you have attached to the database. We have schools that use PARS for registration and this can stop any SIMS database being able to go into single user mode.
Mcshammer_dj Posted March 6, 2007 Posted March 6, 2007 yeah cause you are working within the database. This routine uses the SIMS built in sql users. It is also worth considering any other product you have attached to the database. We have schools that use PARS for registration and this can stop any SIMS database being able to go into single user mode.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now