Tag Info

New answers tagged


Ideas to get you started: This is an excellent idea, and the one I'd go for first. Except, SQL Server 2000 does not support INCLUDEd columns in indexes. Clustered/non-clustered indexes is a different discussion entirely - to put it simply, a clustered index is actually the physical storage "order" of the data (the index is the data), while a non-clustered ...


Please read Calculating Counter Values to understand what performance counter values are and how you use them. Per second values are computed from two samples delta divided by time. Jason Strate has a SQL Server specific discussion here.


Further investigation and "Googling" solved the issue, The issue was with drive, It was compressed and SQL Server did not like that. Solution Removed the compression from Drive and this time backup completed without any errors and much faster.

Top 50 recent answers are included