Thursday, March 8, 2012

database maintenance plan question

What type of backup does the SQL maintenance plan wizard use? Complete,
differencial?
Thanks
JohnWhen using a Maintenance Plan to perform a Backup the SQLMAINT utility is
called with the -BkUpDB switch. This switch performs a full database backup,
backing up the entire database.
- Peter Ward
WARDY IT Solutions
"JP Breton" wrote:
> What type of backup does the SQL maintenance plan wizard use? Complete,
> differencial?
> Thanks
> John
>
>
>|||Thanks for the quick reply P
Regards
JP
"P. Ward" <peter@.remove_online.wardyit.com> wrote in message
news:21181E36-3453-4FCB-8F12-D49BC1DBD200@.microsoft.com...
> When using a Maintenance Plan to perform a Backup the SQLMAINT utility is
> called with the -BkUpDB switch. This switch performs a full database
> backup,
> backing up the entire database.
> - Peter Ward
> WARDY IT Solutions
> "JP Breton" wrote:
>> What type of backup does the SQL maintenance plan wizard use? Complete,
>> differencial?
>> Thanks
>> John
>>
>>|||Maint Wiz supports Log and Db backup.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"JP Breton" <jpbreton@.videotron.ca> wrote in message news:uBFiOUkPFHA.2144@.TK2MSFTNGP09.phx.gbl...
> What type of backup does the SQL maintenance plan wizard use? Complete, differencial?
> Thanks
> John
>
>

No comments:

Post a Comment