Showing posts with label differencial. Show all posts
Showing posts with label differencial. Show all posts

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
>
>