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 [...]

Answer Question   |  February 6, 2009  12:57 AM
Database design, SQL Server administration, SQL Server database design and modeling, SQL Server maintenance, SQL Server performance, Very Large Databases

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:backupshipment.bak’ WITH NOFORMAT, NOINIT, NAME = N’shipment’, SKIP, REWIND, NOUNLOAD, STATS = 10 ” failed with the following error: “Write on “D:backupshipment.bak” failed: 112(error not found) BACKUP DATABASE is terminating [...]

Answer Question   |  July 10, 2009  5:38 PM
Backup to Disk, SQL Server 2005, SQL Server 2005 backup, SQL Server 2005 maintenance, SQL Server administration, SQL Server backup, SQL Server maintenance

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

Answer Question   |  October 27, 2008  1:26 PM
SQL Server 2005, SQL Server maintenance, SQL Server Maintenance Plan

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

Answer Question   |  October 16, 2008  2:06 PM
SQL Server 2005, SQL Server backup, SQL Server maintenance, SQL Server performance