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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Backup Database question

Author  Topic 

systemDown
Starting Member

11 Posts

Posted - 2008-07-22 : 23:02:02
Does a BACKUP DATABASE command lock the database being backed up in anyway?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-22 : 23:03:36
It doesn't lock in anyway. But restore does. You have to kick users out while you restore in SQL 2000.
Go to Top of Page

systemDown
Starting Member

11 Posts

Posted - 2008-07-23 : 11:44:35
thanks,

sodeep
Go to Top of Page
   

- Advertisement -