October 3, 2009 at 9:41 pm
When Backup is performed, is the database available for the application and for users to connect?
October 4, 2009 at 5:32 am
Yes
You know, you could probably have tested it out and had an answer far faster than waiting for someone to notice your question.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 4, 2009 at 5:43 am
Generally, yes, your databases will be available during a backup.
I say generally as a 2000 system I use to administer use to have problems with logshipping when the backup was running; but only on Saturday mornings ... Strange but true.
Apparently, 2000 had a locking problem when running a database backup which did not affect a fillegroup backup. A change to filegroup backups resolved the issue.
I do not know if this is still the case for 2005 or 2008.
Hope this helps.
October 4, 2009 at 5:48 am
Mark_Pratt (10/4/2009)
I say generally as a 2000 system I use to administer use to have problems with logshipping when the backup was running; but only on Saturday mornings ... Strange but true.
That's because in SQL 2000 log backups could not run simultaneously with a full database backup. The log backups would have to wait until the full was complete. It was specific to log backups, just about everything else can run during a backup, and a change in design means it's not the case in SQL 2005 and above.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 4, 2009 at 5:54 am
good to know the specifics on the SQL 2000 log backups; we still use them.
Thanks for your input.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply