April 2, 2014 at 5:41 pm
Hey,
I have a question on db backups
How can we know if a database is available when the backups are running ? Do backups affect the availability of the database ?
Please let me know
April 2, 2014 at 6:00 pm
Backups do not affect the availability of the database. You can still connect to the database and run transactions.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 2, 2014 at 6:16 pm
Hey thanks for your response, how can we know that backups doesn't affect the availability of databases ?
April 2, 2014 at 6:47 pm
Login to the database and run a query. That is the easiest way to show the backup does not take your database down while it is running.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply