However, it does not restore the Transaction logs, Allocation pages, Page 0 of all data files (the file boot page), Page 1:9 (the database boot page), and Full-text catalog. Here is the T-SQL command ...

I'm having to robocopy SQL 2005 dbs to another server for backup, and the other server is running SQL 2000. What is the T-SQL I need to use in order to delete files older than 'x' days?

For example, the SQL procedure executes without a RUN statement when a procedure statement is submitted. The SQL procedure also displays any output automatically without using the PRINT procedure. By ...

You can save a backup of your MS SQL databases to a single file on your hard drive. These backup files have names ending with the ".bak" file extension, and you use them to restore database ...