SQL Server Maintenance

Performance of very large SQL Server table with millions of rows

Performance of very large sql server table with millions of rows: - I have a SQL server database - I have more than 200 tables in the database - I have one table that contains information on every row in all the tables. So this table will have millions of rows (Let us name it Bigtable) - Any data...

Database maintenance task (full back up) fails on SQL Server

Hi My daily maintenance job fails due to the below error from last 20 days regularly Executing the query "BACKUP DATABASE [shipment] TO DISK = N'D:\backup\shipment.bak' WITH NOFORMAT, NOINIT, NAME = N'shipment', SKIP, REWIND, NOUNLOAD, STATS = 10 " failed with the following error: "Write on...

Maintenance Plans SQL Server 2005

I upgraded to SQL2005, and cannot get any Maintenance Plan to save, via Wizard, or regular creation.

SQL SERVER 2005 MAINTENANCE PLAN PROBLEM

HI, SQL2K5 Maintenance plan does not delete old backups even when 'backups older than 1 days' is selected.so my backups are piling up and have to remove them manulally everyday. any solution? Marshall