Backup/Restore Optimization Tips:
Try to perform backup to the local hard disk first, and copy backup file(s) to the tape later.
When you perform backup, some SQL Server commands cannot be made, for example: during backup you cannot run ALTER DATABASE statement with either the ADD FILE or REMOVE FILE options, you cannot shrink database, you cannot [...]
Filed under: Backup/Restore Tips | Tagged: Advance SQL tips and tricks, Author Raghunath Bhandari, Database, Database Optimization Tips, dba, MCP, Microsoft Certified Professional, Microsoft SQL server, MSDN Help, MSDN SQL News, MSSQL, MSSQL Resources, MSSQL server, MSSQL Server help, SQL, SQL Backup/Restore, SQL Best practices and tips, SQL Coding Standards, SQL Database Optimization Tricks, SQL Database Settings Optimization Tips, SQL Documentation, SQL help, SQL Optimization, SQL Optimization Tips, SQL Query, SQL Server, SQL server tips, SQL technology, SQL Tips, SQL Tips and Tricks, SQL tips for programmer, sqlhelp, sqlhelp news, sqlhelp WebSite Review, T-SQL, Technology News | Leave a Comment »
