0

How can we know if you database is available while the backup jobs are running ? Do backups affect the availability of the databases ?

Please let me know

Thanks

user3063530
  • 79
  • 1
  • 2
  • 11

1 Answers1

0

Database backup does not obtain any locks or block anything while running.

Things that can cause some performance issue, If your are writing backups to the same drive where you data/data files are residing, if your system has to read and write at the same time on same drives than can slow the queries that are reading from database.

But I dont think anyone does backups to the same drives where data files are , kind of pointless. Other then that it shouldn't affect the performance.

M.Ali
  • 67,945
  • 13
  • 101
  • 127
  • What you are telling makes sense, our backups are not stored in same drive where data files are. But, how can we know if a database is available while the backup job for that database is running – user3063530 Apr 02 '14 at 23:15
  • It will be available to make sure you can run the backup job and at the same time execute USE database_name GO in SSMS, if it doesn't throw an error and changes the database, which it will it means your database is available to query. – M.Ali Apr 02 '14 at 23:40
  • I understand, but if suppose the backup job is running in the mid night. How can I know if my databases are available ? – user3063530 Apr 02 '14 at 23:54
  • Create another job that runs exactly the same time and you will see both jobs will be executed successfully. – M.Ali Apr 03 '14 at 07:51