Query to Restore a database from backup in MSSQL
Hello friends, I had an issue in restoring a database from backup in MSSQL. Finally after a long struggle i fixed the issue by executing the following query. ———- Use Master Alter Database databasenameSET SINGLE_USER With ROLLBACK IMMEDIATE RESTORE DATABASE databasename FROM DISK = ‘backup location’WITH REPLACE; Alter database databasenameSET… Continue Reading Query to Restore a database from backup in MSSQL