How can i Restore Backup files in Sqlserver

Question

I m trying to Restore the .Bak(Backup files) in Sqlserver2008, when i'm doing that i m

 getting the error like Restore failed due to 'X' server does not 

exist(Microsoft.sqlserver.smoextended). How can i solve this error..

Regards, 

Rajender

Answer 1

I m trying to Restore the .Bak(Backup files) in Sqlserver2008, when i'm doing that i m

 getting the error like Restore failed due to 'X' server does not 

exist(Microsoft.sqlserver.smoextended). How can i solve this error..

Regards, 

Rajender

go to database and restore .bak file with overwrite.Try on test database first.

Is that full backup that you want to restore?Do you have transaction backup

Hire is t-sql http://technet.microsoft.com/en-us/library/ms186858.aspx

If you don't like to restore with overwrite, first you need to make tail log backup restore that tail log backup and database need to be in norecovery mode, then you can restore full backup.

Answer 2

Hi Rajender Ponnala,

Could you post additional information about your error message and your script as well?

Regarding to the error message you provided, it might be related to specified backup file cannot be found or SQL Server doesn't have permission to access file.

Please make sure that the file exists and you provide the correct path where performing a restore operation. 
For permission issue, please check the permissions of the account that is assigned to the SQL Server service account. As part of the solution, you may want to save your backup files to somewhere other than the root of the C: drive.

If you are looking for possible causes of this behavior, please see the following:
1. http://msdn.microsoft.com/en-us/library/bb326318(v=SQL.100).aspx
2. http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/dacc12e0-746f-40b6-865a-cb753afac01b/
3. https://connect.microsoft.com/SQLServer/feedback/details/530983/incorrect-file-names-when-restoring-from-sql-server-2005-backup-to-sql-server-2008?wa=wsignin1.0

More information about Step by step backup/restore using T-SQL, please refer to this Blog: http://www.sqlserverblogforum.com/2011/01/step-by-step-backuprestore-using-t-sql/

 

---

Regards, Amber zhang

Answer 3

Could you confirm the exact message and also confirm from what version of SQL Server the backups were taken.

Thank you,

---

Anup | Database Consultant

Blog: https://smartsqlserver.wordpress.com Twitter: Follow me !

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 4

please refer the given link for the reference.

http://www.sqlteam.com/article/backup-and-restore-in-sql-server-full-backups