SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Maintenance Plan with Incremental backup
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jameswithers
Starting Member

4 Posts

Posted - 05/13/2008 :  06:17:44  Show Profile  Reply with Quote
Hi,

Is it possible to use the maintenance plan wizard to create a backup plan that takes a full backup on a Sunday and incremental every other day of the week. I cant see a way to do this but am perhaps missing something obvious. If it cant be done would the best method be just to schedule jobs containing the t-sql commands?

Any advice would be appreciated.

Thanks

James

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 05/13/2008 :  09:36:16  Show Profile  Reply with Quote
yes you can backup database as you said in Maintenance plan. Schedule it and you are good.
Go to Top of Page

jameswithers
Starting Member

4 Posts

Posted - 05/14/2008 :  05:03:41  Show Profile  Reply with Quote
The question I am asking is how do you tell the maintenance plan to do an incremental every day except Sunday when you want a full backup? I cannot see any way of specifying full or incremental when I create the job, it seems to default to full. As I say perhaps I am missing something obvious, it seems strange that it cant be done?
Go to Top of Page

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 05/14/2008 :  09:42:50  Show Profile  Reply with Quote
In SQL 2005, you have that option in maintenance plan. But in 2000, you need to have T-SQL command in job for differential backup.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000