ProblemI have SQL Server Central Management Servers setup in my environment. How can I get a list of the registered servers and their associated properties? Are there any queries I can issue? Check out this tip to learn more.
Error
Read on “VDI_FCA0B3E9” failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.)
The media family on device LiteSpeed for SQL Server backup file is incorrectly formed. SQL Server cannot process this media family.
Solution
In recent times I came across the above error, while restoring the database. We are using the Quest LiteSpeed for the backup/restore. As per the request from the user we have started the restore of the database from the production box to development box.
Restore Query is failing with the above error. I have follow the below checklist to fix the error.
I got the positive result on all the above tests but still the restore is failing. At last I checked the one day old emails and found that, production box was migrated from SQL Server 2005 to SQL Server 2008. As you may know that we can’t restore the database from higher version to lower version because of that restore was failed.
Finally I have restore the database on the different SQL Server 2008 development box and up-grade the SQL Server 2005 box with SQL Server 2008
If you come across such kind of error, make sure you are checking the SQL Server version and LiteSpeed version on both source and destination machine.
As a best practice, most companies follow a standard comment format at the beginning of stored procedures and functions. In addition, it is also a good idea to include comments in all scripts you write even if they are just save as .sql or .txt files. Manually we often add a standard comment block to the header of our scripts using copy and paste, but in this tip we look at how to automate adding a standard comment block for every set of code we write using SSMS.
Error
Cannot find template file for the new query (‘C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\SQL\SQLFile.sql’)
Solution:
Step 1: Go to C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\SQL\
Step 2: Create .SQL File named SQLFile.SQL
If you have configured the user database any of below feature of SQL Server 2008 Enterprise Edition
— Data Compression
— Partitioning
— Transparent Data Encryption
— Change Data Capture
Above list of features will internally change the way the database engine stores information within the database files. If a database configured to use any of the above features which are specifically designed to be used in Enterprise Edition of SQL Server 2008, it cannot be moved to other editions of SQL Server 2008.
You can check the above feature by querying the sys.dm_db_persisted_sku_features DMV against database.
SELECT feature_name FROM sys.dm_db_persisted_sku_features ; GO
aiDeeva.com 