July 30, 2002 at 3:28 am
Hi,
Actually, i have added this restoration as a job to be done everyday. I put it as :-
restore database <database name> from disk= <filename>'.
But a few questions come into my mind, :-
is this a force restoration? What are the things I should add in to make this a force restoration?
If there are still users in the database, how can I automate the killing process?
Usually, how do people have a automate restoration to be done everyday on another server.
Do advise me. Thank you and best regards.
Kelvin
July 30, 2002 at 7:08 am
I have a stored proc that goes out and kills all connections to that database. When I did this I was new to SQL and now I would just set the database to single_user with rollback immediate. Following that you should be able to execute your restore, and once complete set the DB back to multi_user.
I have a couple databases that I do this with nightly and have had no problems.
Hope this helps.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply