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 2008 Forums
 SQL Server Administration (2008)
 Database backup question

Author  Topic 

userSQL
Starting Member

3 Posts

Posted - 2013-12-09 : 22:00:19
Hi,

The SQL Server databases are being backed up using ARCServe.

I have been told that ARCServe puts the database is quiescence mode during the backup.

Does any one know if this affects users form being able to add data to the database through the application during the backup?


Thanks in Advance,

Mike

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2013-12-10 : 12:26:32
Simply NO, Non of backup database process creates locks. Data remains available to users, during backup process.

--------------------------
http://connectsql.blogspot.com/
Go to Top of Page
   

- Advertisement -