Sorry guys, long day... Its SQL 2000, so:
MS SQL 2000
Database Maintenance Plans
1. All Databases (this includes everything I would need in the event of
a catastrophic failure and needed to rebuild the machine?)
2. No Optimizations
3. Check Integrity, include indexes, perform before backup
4. Backup db's as part of the plan with verify
5. Logs as well
I have put everything in one directory, does this sound sane?
Thanks!
jlc
> -----Original Message-----
> From: Phil Brutsche [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, February 26, 2008 4:34 PM
> To: NT System Admin Issues
> Subject: Re: Scripted SQL Backups
>
> While those links will work with MSDE you don't need to - Enterprise
> Manager from the SQL Server 2000 CD will work.
>
> The reason why you need to manually create the T-SQL scripts and the
> scheduled tasks with SQL Express is it doesn't include the SQL Server
> Agent, while MSDE does.
>
> Salvador Manzo wrote:
> > SQLExpress (also applies to MSDE)
> > http://www.sqldbatips.com/showarticle.asp?ID=27
> > http://www.sqldbatips.com/showarticle.asp?ID=29
>
> --
>
> Phil Brutsche
> [EMAIL PROTECTED]
>
> ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~
> ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~
~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~
~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~
