Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Database Backup up in regular interval

Author  Topic 

imrul
Starting Member

36 Posts

Posted - 2010-03-30 : 23:58:54
I need to schedule a backup job which will take a database backup in every 30 mins, but database should be available to use at the time of backup. Can any one help?

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2010-03-31 : 00:14:18
check out the Books Online HOW-TO topics

Backing Up and Restoring
http://msdn.microsoft.com/en-us/library/ms189621%28v=SQL.100%29.aspx
http://msdn.microsoft.com/en-us/library/aa337534%28v=SQL.100%29.aspx

Automate Administration
http://msdn.microsoft.com/en-us/library/ms189880%28v=SQL.100%29.aspx
http://msdn.microsoft.com/en-us/library/ms187036%28v=SQL.100%29.aspx


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2010-03-31 : 04:00:14
" database should be available to use at the time of backup"

This is not a problem for backups on MS SQL Server databases
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-31 : 12:45:41
I hope you mean transaction log backup every 30 minutes and not a full backup every 30 minutes.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -