Monthly Archives: September 2011

Useful System SPs of SQL Server 2005

sp_add_data_file_recover_suspect_db (Transact-SQL) Adds a data file to a filegroup when recovery cannot complete on a database due to insufficient space on the file group (error 1105). After the file is added, this stored procedure turns off the suspect setting and … Continue reading

Posted in SQL Server 2005 | Leave a comment