Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
 Posted - 2008-07-04 : 00:11:12
|
| HI to all.I have a small doubtIn 2000 can users be able to access the database during backups.how about in 2005.But i read that in 2005 backups are online.I dont know abt 2000.Could any one tell me abt this. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-04 : 00:31:51
|
| They can access the database in both 2000 and 2005 while backup. I think you are talking about Restore. |
 |
|
|
maninder
Posting Yak Master
100 Posts |
Posted - 2008-07-04 : 17:19:23
|
| sodeep is right... again if it is RESTORE.. then NO. the Database will be in restoring MODE.. and Locked.. so no access...ManinderDatabase Painter.. Leaving strokes, that amaze! and inreturn, put value to your Work. I am a Database [Architect / Administrator] |
|
|
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
Posted - 2008-07-07 : 13:41:59
|
| Thanks for the posts.What i could understand is in 2000/20005 during backups we are able to access the database.Coming to recovery in 2000 and 2005 we are not able to access the databases.Please correct me if iam wrong. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-07 : 13:58:43
|
| In 2005, you can with Online restore. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-07 : 23:09:13
|
| With lot of restrictions and not for full restore. |
|
|
|
|
|
|
backups