Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Backup   (RSS)

Not able to restore backup from tape for large databases on the SQL Server 2005

We get the below error message when we try to restore from tape for large databases. ERROR MESSAGE: ============== TITLE: Microsoft SQL Server Management Studio ------------------------------ An exception occurred while executing a Transact-SQL statement Read More...
Posted Wednesday, April 15, 2009 4:00 PM by sanjayap | 0 Comments

How to backup SQL Server databases to a mapped drive

While taking backups for SQL Server databases onto a mapped drive you might get the following error: " The system cannot find the path specified." This is because a network share that you map using a local drive letter will not be visible to a SQL Server Read More...
Posted Friday, February 27, 2009 9:00 AM by Pariks | 5 Comments

Maintenance Plans with “Backup Database Task” fails when the “Create a sub-directory for each database” option is checked

Maintenance Plans with “Backup Database Task” fails when the “Create a sub-directory for each database” option is checked, with error similar to the below, “Cannot open backup device 'D... The package execution fa... The step failed.,00:00:01,0,0,,,,0” Read More...
Posted Sunday, July 27, 2008 5:16 AM by sanjayap | 1 Comments

Regeneration of the Master Key fails when we try to take the backup of the Original Database and Restore on other instance of SQL server on other Machine

We have a production database in which the data is encrypted. The encryption follows the following hierarchy 1) The data is encrypted using Symmetric key 2) The symmetric key was encrypted using asymmetric key 3) The asymmetric key was encrypted using Read More...
Posted Wednesday, July 16, 2008 1:32 PM by sanjayap | 3 Comments
 
Page view tracker