May 11, 2008 at 11:13 pm
m able to take backup and restore the database through gui. Backup is comming with backup query, but using restore query m unable to restore database.
It is giving exception is REstore failed for server.
what it means ? what is the solution for this?
May 11, 2008 at 11:33 pm
Hi
Please post the exact error description...
May 12, 2008 at 7:01 am
You can make use of this command to restore the database,
(a) RESTORE FILELISTONLY FROM DISK='D:\YourBackupfilename.bak'
GO
(b) RESTORE DATABASE NewDatabaseName
FROM DISK='D:\YourBackupfilename.bak'
WITH MOVE'LOgiclaName of the SOurceDatafile' TO 'D:\NewDatabase.mdf',
MOVE 'Logicalname of sourcelogfile' TO'D:\NewDatabase_log.ldf'
Note : To get the logical file name run the step (a) and copy past the data and log file name. Change the script accordingly and run
[font="Verdana"]- Deepak[/font]
May 12, 2008 at 9:21 am
Also check for any open connections to the database if you have one close that...
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply