backup

Question

backup sql database from win forms iam getting an error' The backup set holds a backup of a database other than the existing database. '

Minnu Merin Alex · Answer

even though Iam getting the same error..plz help here is my code for backup public static void backups() { string str = "use point_of_sale"; string str1 = "Backup database point_of_sale to disk='E:\backupfile.bak'WITH FORMAT, MEDIANAME = 'SQLServerBackups', NAME = 'Full Backup of pos'"; SqlCommand cmd1 = new SqlCommand(str, Connection.Getconnection()); SqlCommand cmd2 = new SqlCommand(str1, Connection.Getconnection()); cmd1.ExecuteNonQuery(); cmd2.ExecuteNonQuery(); } how to restore?and how will i view the restored one

Minnu Merin Alex · Answer

i saw this link but its not working. can you explain me in steps

Manas Mohapatra · Answer

Use below steps to resolve: 1. Use WITH REPLACE while using the RESTORE command RESTORE DATABASE AdventureWorks FROM DISK = 'C:\BackupAdventureworks.bak' WITH REPLACE or 2. Delete the older database which is conflicting and restore again using RESTORE command.

Nishant Mittal · Answer

Don't create an empty database and restore the .bak file on to it. Use 'Restore Database' option accessible by right clicking the "Databases" branch of the SQL Server Management Studio and provide the database name while providing the source to restore.

Nishant Mittal · Answer

Hi Similar issues : http://stackoverflow.com/questions/10204480/the-backup-set-holds-a-backup-of-a-database-other-than-the-existing

backup

Answers (5)