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 happen during backup and restoration operation.
Tag Archives: trace flag
Troubleshoot backup \ restore issues with trace flag 3004
Posted by Vidhya Sagar
on April 19, 2011
No comments
Suppress Backup information in Errorlog
Posted by Vidhya Sagar
on April 4, 2010
3 comments
After a long gap I’m 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 you got me, we are taking Full backup daily, differential every 4 hours and transaction log backup every 15 min, there is no problem with the backup. We have one thing that is messing our error log, whenever a backup is taken by default SQL Server will write the detail to the errorlog as shown below.