maintance plan

Hi,
what commands should i include in maintance plan for big database
Regards
Abhi
Abhi
What is the version of SQL Server?
How big database is? Have you identified most fragmented tables and rebuild
index/s on them?
"Abhi" <bawejaji@.gmail.com> wrote in message
news:1186987119.381288.41610@.q4g2000prc.googlegrou ps.com...
> Hi,
> what commands should i include in maintance plan for big database
> Regards
> Abhi
>

maintance plan

Hi,
what commands should i include in maintance plan for big database
Regards
AbhiAbhi
What is the version of SQL Server?
How big database is? Have you identified most fragmented tables and rebuild
index/s on them?
"Abhi" <bawejaji@.gmail.com> wrote in message
news:1186987119.381288.41610@.q4g2000prc.googlegroups.com...
> Hi,
> what commands should i include in maintance plan for big database
> Regards
> Abhi
>

maintance plan

Hi,
what commands should i include in maintance plan for big database
Regards
AbhiAbhi
What is the version of SQL Server?
How big database is? Have you identified most fragmented tables and rebuild
index/s on them?
"Abhi" <bawejaji@.gmail.com> wrote in message
news:1186987119.381288.41610@.q4g2000prc.googlegroups.com...
> Hi,
> what commands should i include in maintance plan for big database
> Regards
> Abhi
>

maint plans xp_sqlmaint db bkups and using the backup commands

Is there a difference between performing a database back up using the maint
plan(xp_sqlmaint) or using the BACKUP command?
Does the xp_sqlmaint perform a FULL backup including the trans logs? And is
it performing a BACKUP LOG? (I would assume no it's not doing a backup log).
Is correct to say the both ways of db backups methods can be used to restore
a database to the point of that backup?
The only difference I note is that the main plans creates date/stamp and you
can keep several copies that you can see.
It does a backup log if you tell it to backup the log. Otherwise it doesn't
backup the log. It does a full backup when you tell it to backup the db.
In both cases it uses the same BACKUP DATABASE or BACKUP LOG command that
you would use.
Andrew J. Kelly SQL MVP
"Victoria Morrison" <VictoriaMorrison@.discussions.microsoft.com> wrote in
message news:3B2752D3-94DC-4136-8069-E33833DA37C5@.microsoft.com...
> Is there a difference between performing a database back up using the
> maint
> plan(xp_sqlmaint) or using the BACKUP command?
> Does the xp_sqlmaint perform a FULL backup including the trans logs? And
> is
> it performing a BACKUP LOG? (I would assume no it's not doing a backup
> log).
> Is correct to say the both ways of db backups methods can be used to
> restore
> a database to the point of that backup?
> The only difference I note is that the main plans creates date/stamp and
> you
> can keep several copies that you can see.

maint plans xp_sqlmaint db bkups and using the backup commands

Is there a difference between performing a database back up using the maint
plan(xp_sqlmaint) or using the BACKUP command?
Does the xp_sqlmaint perform a FULL backup including the trans logs? And is
it performing a BACKUP LOG? (I would assume no it's not doing a backup log).
Is correct to say the both ways of db backups methods can be used to restore
a database to the point of that backup?
The only difference I note is that the main plans creates date/stamp and you
can keep several copies that you can see.It does a backup log if you tell it to backup the log. Otherwise it doesn't
backup the log. It does a full backup when you tell it to backup the db.
In both cases it uses the same BACKUP DATABASE or BACKUP LOG command that
you would use.
--
Andrew J. Kelly SQL MVP
"Victoria Morrison" <VictoriaMorrison@.discussions.microsoft.com> wrote in
message news:3B2752D3-94DC-4136-8069-E33833DA37C5@.microsoft.com...
> Is there a difference between performing a database back up using the
> maint
> plan(xp_sqlmaint) or using the BACKUP command?
> Does the xp_sqlmaint perform a FULL backup including the trans logs? And
> is
> it performing a BACKUP LOG? (I would assume no it's not doing a backup
> log).
> Is correct to say the both ways of db backups methods can be used to
> restore
> a database to the point of that backup?
> The only difference I note is that the main plans creates date/stamp and
> you
> can keep several copies that you can see.

maint plans xp_sqlmaint db bkups and using the backup commands

Is there a difference between performing a database back up using the maint
plan(xp_sqlmaint) or using the BACKUP command?
Does the xp_sqlmaint perform a FULL backup including the trans logs? And is
it performing a BACKUP LOG? (I would assume no it's not doing a backup log)
.
Is correct to say the both ways of db backups methods can be used to restore
a database to the point of that backup?
The only difference I note is that the main plans creates date/stamp and you
can keep several copies that you can see.It does a backup log if you tell it to backup the log. Otherwise it doesn't
backup the log. It does a full backup when you tell it to backup the db.
In both cases it uses the same BACKUP DATABASE or BACKUP LOG command that
you would use.
Andrew J. Kelly SQL MVP
"Victoria Morrison" <VictoriaMorrison@.discussions.microsoft.com> wrote in
message news:3B2752D3-94DC-4136-8069-E33833DA37C5@.microsoft.com...
> Is there a difference between performing a database back up using the
> maint
> plan(xp_sqlmaint) or using the BACKUP command?
> Does the xp_sqlmaint perform a FULL backup including the trans logs? And
> is
> it performing a BACKUP LOG? (I would assume no it's not doing a backup
> log).
> Is correct to say the both ways of db backups methods can be used to
> restore
> a database to the point of that backup?
> The only difference I note is that the main plans creates date/stamp and
> you
> can keep several copies that you can see.