backup

Minnu Merin Alex

backup sql database from win forms

iam getting an error"The backup set holds a backup of a database other than the existing database."

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Minnu Merin Alex10y ago
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
0
Manas Mohapatra10y ago
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.
0
Nishant Mittal10y ago
- 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.
0
Minnu Merin Alex10y ago
i saw this link but its not working.
can you explain me in steps
0
Nishant Mittal10y ago
Hi

Similar issues :

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