Pls tell me, can we restore database when database in use,if so how?no.
ALTER DATABASE <BDNAME> SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE|||Can you change a trie on a car when it's moving?|||Um, doesn't 2005 has some ability to restore while in use? I don't have the documentation in front of me...|||Online restores are available in SQL 2005, but,,,,,
1) Only when you are running Enterprise Edition.
2) Only in the case that you are restoring a single page, or a non-primary filegroup.
3) You have all transaction logs up to and including the present online transaction log.
4) You set the database to read-only for the duration of the restore.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment