Category Archives: Backup and Restore

Day 17 Backup and Recovery

There are there types of Backup: Full Backup Incremental Backup Bin-Log Backup Full Backup: is a complete backup of the database You can use following some of the options in the MySQLDump command –all-databases             Dump all tables in all … Continue reading

Posted in Backup and Restore, Disaster Recovery, MySQL, Others | Tagged , , , | Leave a comment

Different ways to move Sql Server file location

Different ways to move Sql Server file location For space issue on drive , performance load balancing or some other reasons, we may have to move physical file of the database to another location. Following are the different ways to … Continue reading

Posted in Backup and Restore, Troubleshooting | Tagged , | Leave a comment

Denali – Day 16: Tool: Database Recovery Advisor –SSMS tool

Denali – Day 16: Tool: Database Recovery Advisor –SSMS tool As blogged on “Denali – Day 11: SSMS enhancement” about Features added on SSMS, now you can restore a page using SSMS, to add to it SSMS has another tool … Continue reading

Posted in Backup and Restore, Denali | Tagged , | Leave a comment

Denali — Day 7: Contained Database

  Denali – Day 7 : Contained Database Contained database is another new feature for sql server 2012 – Denali, earlier version has a big issue on logins/users associated with particular database when you want to move the database from … Continue reading

Posted in Backup and Restore, Denali, Whats New | Tagged , | Leave a comment

Restore fails with tail of log error

For sql server 2005 and above, When you take a full backup of the FULL recovered database and try to restore earlier backup it may fail with following error Msg 3159, Level 16, State 1, Line 1 The tail of … Continue reading

Posted in Backup and Restore, Transaction Log, Troubleshooting | Tagged , | Leave a comment

Suspect Database

Suspect database generally caused by internal IO issue, and the best way to resolve it to ask hardware person to check and correct the issue. And sql server dba has to monitor it. Check the database consistence using DBCC CHECKDB … Continue reading

Posted in Backup and Restore, Disaster Recovery, Experts, Troubleshooting | Tagged , , | Leave a comment

Day 22: Restore related Errors

Day 22: Restore related Errors Error Restore backup on same server When we try to restore the backup of the same database on the same server with a different name using query like this RESTORE DATABASE a FROM DISK =’c:\vinayx.bak’ … Continue reading

Posted in Backup and Restore, Troubleshooting | Tagged | Leave a comment

Day 20: Maintenance job failed when index on computed column

Description: When you create a maintenance plan on sql server 2000, it may failed if you have index on computed column. It will failed with either of this following error. [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server … Continue reading

Posted in Backup and Restore, Troubleshooting | Tagged | Leave a comment

Day 12: Job Owner error

This is very simple but so many might get this error very often, especially when you created a maintenance plan and run it we may get below error:   Message The job failed.  Unable to determine if the owner (XXX) … Continue reading

Posted in Backup and Restore, Troubleshooting | Tagged | Leave a comment

Day 6: Backup job failed -File in use Error 32

  I have seen another very common backup job failed error, when we check backup files generates successfully but job fails with following error   Alert description: BackupDiskFile::CreateMedia: Backup device ‘xxx.bak’ failed to create. Operating system error 32(The process cannot … Continue reading

Posted in Backup and Restore, Troubleshooting | Tagged | Leave a comment