Home > IT Answers > Storage > Can you backup a SQL Server 7.0 database while users are using the database?
Bkr0963c
0 pts.
 Can you backup a SQL Server 7.0 database while users are using the database?
Backup & recovery, SQL Server 7, SQL Server backup
I know you can back up SQL Server 2000 databases while users are using the database, and I am certain that you can do the same for SQL Server 7.0, but I want confirmation if someone does not mind.

Software/Hardware used:
ASKED: August 5, 2005  11:59 AM
UPDATED: February 3, 2009  4:05 PM
RELATED QUESTIONS
Answer Wiki:
Yes, you can do an online backup of a database on any version of MS SQL. The SQL data engine is smart enough to deal with any transactions that occur while the backup is happening.
Last Wiki Answer Submitted:  August 5, 2005  1:26 pm  by  Pedwards17   0 pts.
All Answer Wiki Contributors:  Pedwards17   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

All versions of Sybase and MS SQL Server have been able to backup with users connected.

BenjiT
 0 pts.