Maint. Plan

8 Aug 2006 6:51 PM

tallen

I need to set up a Maintenance Plan on a 6.5 DB. I know the version is old
but the customer cannot upgrade at this time. When I try and run the wizard
to set it up I get a warning about running a plan on a DB that is larger that
400MB. What the deal? Thanks for the help!!

8 Aug 2006 8:14 PM

Tibor Karaszi

That was just a warning to let you know that if you have "big" databases, then you shouldn't let a
Wizard do the stuff for you, you should write your own customized jobs. It is not a hard limit or
so...

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

Show quote

"tallen" <tal***@discussions.microsoft.com> wrote in message
news:D7547631-4EEC-4FCF-A4F3-8950B6AD2B57@microsoft.com...
>I need to set up a Maintenance Plan on a 6.5 DB. I know the version is old
> but the customer cannot upgrade at this time. When I try and run the wizard
> to set it up I get a warning about running a plan on a DB that is larger that
> 400MB. What the deal? Thanks for the help!!

9 Aug 2006 2:52 AM

Hari Prasad

Hi,

Add on to Tibor; Rather than using the Maintenance plan I suggest you to
write a small batch file perform the backup or Reindex.

Contents inside batch file:- (Backup.bat)

del c:\backup\dbname_old.bak
copy c:\backup\dbname.bak c:\backup\dbname_old.bak
ISQL -Usa -Ppassword -S
Servername -ic:\backup\backup.sql -oc:\backup\backup.log

(Save the file as backup.bat)

Inside the backup.sql

DUMP database dbname to disk='c:\backup\dbname.bak' with init

How to schedule
--------------------

Using SQL Executive schedule the job mentioning the required frequency

Note:

Ensure that SQL Executive service is running

Thanks
Hari
SQL Server MVP

Show quote

"Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in
message news:OcsLGdyuGHA.4888@TK2MSFTNGP05.phx.gbl...
> That was just a warning to let you know that if you have "big" databases,
> then you shouldn't let a Wizard do the stuff for you, you should write
> your own customized jobs. It is not a hard limit or so...
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
>
> "tallen" <tal***@discussions.microsoft.com> wrote in message
> news:D7547631-4EEC-4FCF-A4F3-8950B6AD2B57@microsoft.com...
>>I need to set up a Maintenance Plan on a 6.5 DB. I know the version is old
>> but the customer cannot upgrade at this time. When I try and run the
>> wizard
>> to set it up I get a warning about running a plan on a DB that is larger
>> that
>> 400MB. What the deal? Thanks for the help!!
>