5.8

WITH FILE=1, NOUNLOAD, REPLACE, STATS = 10
GO
7. Click Execute and wait for SQL Server to restart and display the following message.
8. Click New Query to reconnect to SQL Server and use Administrative privileges with the local account
or use Windows Authentication.
9. Rename the SQL Server @@servername definition with the following commands.
USE master
GO
DECLARE@NewServerName varchar(254)
SET @NewServerName = Convert(varchar(254), serverproperty ('ServerName'))
EXEC sp_dropserver @@servername
EXEC sp_addserver @NewServerName,local
GO
10. Click Execute.
11. Restart the SQL Server Service and reconnect to SQL Server using an account with Administrative
privileges.
12. Type the following commands to restore the msdb database.
RESTORE DATABASE [msdb]
FROM DISK = N'E:\Backup\msdb\msdb_backup_201003021337.bak
WITH FILE=1, NOUNLOAD, REPLACE, STATS = 10
GO
13. Click Execute.
Restore the Report Server Database
Restore the SQL Report Server database to recover SQL Reporting Services..
Restoring the Databases
VMware, Inc.
35