Maintenace Plan Best Practice

My question is recommendation for setting up maintenace plans that are safe and complete. What do you recommned I do for setting up a plan that backs up, and deletes old files older than 5 days. Should I do anything else and why?

thank you!

If you want to backup the database and delete the old backup files you can create a maintenance plan to backup dbs and another task to "Cleanup task" to remove old .bak files.........refer this link,

http://www.sql-server-performance.com/articles/dba/creating_backup_jobs_p1.aspx

Thanxx

Deepak

|||

Thanks for the responce. I am pretty proficient at setting them up, however, I just am unsure about what is the best practice maintenace plan for my sql 2005 server as far as indexing and other cleanup type maintenance. Should I index and at what intervals, should I shrink the logs and databases and when and why?

Thanks!

Maintenace Plan Best Practice

My question is recommendation for setting up maintenace plans that are safe and complete. What do you recommned I do for setting up a plan that backs up, and deletes old files older than 5 days. Should I do anything else and why?

thank you!

If you want to backup the database and delete the old backup files you can create a maintenance plan to backup dbs and another task to "Cleanup task" to remove old .bak files.........refer this link,

http://www.sql-server-performance.com/articles/dba/creating_backup_jobs_p1.aspx

Thanxx

Deepak

|||

Thanks for the responce. I am pretty proficient at setting them up, however, I just am unsure about what is the best practice maintenace plan for my sql 2005 server as far as indexing and other cleanup type maintenance. Should I index and at what intervals, should I shrink the logs and databases and when and why?

Thanks!

sql

Machine Recommendation

Hello all,
Can anyone recommend some dependable machines for running Microsoft
SQL Server 2000? This machine may be hit with as many as 75000 to
100000 simultaneous database requests (stored procedures, trigger
functions) at a time so I'm looking to put this database on a good,
solid machine. Thanks in advance.
AlanRefer to this url
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechn
ol/sql/maintain/operate/opsguide/sqlops6.asp
- Vishal
"aminnis" <alanminnis@.yahoo.com> wrote in message
news:eaef7f31.0309151608.36284af4@.posting.google.com...
> Hello all,
> Can anyone recommend some dependable machines for running Microsoft
> SQL Server 2000? This machine may be hit with as many as 75000 to
> 100000 simultaneous database requests (stored procedures, trigger
> functions) at a time so I'm looking to put this database on a good,
> solid machine. Thanks in advance.
> Alan