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.
| Author |
Topic |
|
sagitariusmzi
Posting Yak Master
113 Posts |
 Posted - 2009-06-04 : 01:08:11
|
| Hi, How to take the Differential Backup using xp_sqlmaint utilityany help will be appreciated. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-06-04 : 01:33:11
|
why are you using xp_sqlmaint ?Quote from BOL http://msdn.microsoft.com/en-us/library/ms188408.aspxquote:
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Why not just use BACKUP DATABASE instead ?http://msdn.microsoft.com/en-us/library/ms191180(SQL.90).aspx
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
sagitariusmzi
Posting Yak Master
113 Posts |
Posted - 2009-07-10 : 01:57:30
|
| actually our application developer is making backup (to take backup of the backup). This job is created using the application. and developer is using sqlmaint |
|
|
|
|
|
|
Differential Backup using xp_sqlmaint