abhishek.c1984 (7/22/2009)
... "some active connections.........."So before going ahead, i need to close the active connections and then proceed further.......So, in such cases is it possible to make forced backup and restore...
Note: forced in the sense, complete the database operations irrespective of active connections
Probably it refers to open connections to the target database of your restore operation.
If you want to restore with interrupting all connections,
just start your restore statement by adding
alter database yourdb set offline with rollback immediate ;
restore database ...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me