22 декабря 2011 г. 7:16I m trying to Restore the .Bak(Backup files) in Sqlserver2008, when i'm doing that i mgetting the error like Restore failed due to 'X' server does notexist(Microsoft.sqlserver.smoextended). How can i solve this error..Regards,Rajender
- Перемещено Sethu SrinivasanMicrosoft Employee, Moderator 14 августа 2012 г. 21:28 restore (From:SQL Server Migration)
22 декабря 2011 г. 8:44I m trying to Restore the .Bak(Backup files) in Sqlserver2008, when i'm doing that i mgetting the error like Restore failed due to 'X' server does notexist(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.
26 декабря 2011 г. 2:16Модератор
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:
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
29 декабря 2011 г. 20:43
Could you confirm the exact message and also confirm from what version of SQL Server the backups were taken.
1 мая 2012 г. 10:46
please refer the given link for the reference.