September 24, 2014 at 5:48 am
Is there a way to backing up SQL DB without having to stop users from connecting to it.
September 24, 2014 at 5:53 am
You can just execute a SQL native (or third party) backup without users noticing anything. Database just stays online and available and users can still perform actions without problem.
September 24, 2014 at 6:02 am
Btw: a file backup of an active database is NOT the advised way to create a database backup!!
When a database is ONLINE the databasefiles will be locked. Some (backup)tools take a kind of snapshot to be able to backup these files, but it's not the recommended way to backup a database and it could lead to a suspect database when restoring these files.
So don't rely on a backup of the databasefiles itself, but create a real database backup.
http://msdn.microsoft.com/en-us/library/ms187048.aspx
www.red-gate.com/products/dba/sql-backup
http://software.dell.com/products/litespeed-for-sql-server/
and find many more (free and charged) if you search the net.
September 24, 2014 at 6:07 am
Thanks for the advice
September 24, 2014 at 6:09 am
no need to stop a SQL server database, they are transactionally consistent even with users connected
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 24, 2014 at 11:53 am
works extremely well, even with users connected.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply