|
-
Jun 1st, 2012, 08:27 AM
#1
Thread Starter
Member
[RESOLVED] Database Restore Fails
Hi Everyone,
Good day, I am trying to do a restore of my database and I am using this command :
RESTORE DATABASE TicketingRestored
FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Backup\ESSTicketingDEC022012.bak'
However, I am receiving the following errors :
Msg 3201, Level 16, State 2, Line 4
Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Backup\ESSTicketingDEC022012.bak'. Operating system error 2(The system cannot find the file specified.).
Msg 3013, Level 16, State 1, Line 4
RESTORE DATABASE is terminating abnormally.
I tried to research for some answers but it is still giving me the above error.
The reason why I want to restore this database to "another newly created blank database" is because I want to view one table inside it that contains December data.
Thank you very much in advance for your help.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|