Troubleshoot backup restore issues with trace flag 3004

I faced an issue during restoration of very large db in our development database server. Issue is restoration takes very long time even though we had latest hardware and recent version of SQL Server (it’s SQL 2008 Ent. Ed). So to troubleshoot it I have used the trace flag 3004 which print all internal things… Continue reading Troubleshoot backup restore issues with trace flag 3004

How Much Memory is Needed Taken for My Database Backup

In this article I will try and cover the concepts in understanding the amount of memory or buffers required for completing a database backup. I would be using a couple of trace flags to get that detail and further discuss two of the parameters MAXTRANSFERSIZE and BUFFERCOUNT in the BACKUP DATABASE TSQL syntax which will… Continue reading How Much Memory is Needed Taken for My Database Backup

Suppress Backup information in Errorlog

After a long gap Im writing a article. This article is all about suppressing successful backup information into errorlog. Let me explain my scenario, In my working environment we have a production SQL Server with 60+ databases, all the databases are set to full recovery and data loss is accepted only for 15 min. Yeah… Continue reading Suppress Backup information in Errorlog