Verifies that a database is configured properly for distribution on removable media and writes returned information to a file.
For additional syntax information for sp_certify_removable, see the Microsoft SQL Server Transact-SQL Reference.
This procedure writes verification information to a text file that has the following filename format:
CertifyR_[dbname].txt
Note The permissions on xp_cmdshell must permit this file write.
The verification log file is written to the C:MSSQL\LOG directory under the SQL Server installation directory. The information is delimited by commas. Records preceded by two hyphens (--) are considered comments.
This example certifies that the inventory database is ready to be removed.
sp_certify_removable inventory, AUTO
Only the system administrator can use this stored procedure.