Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tsrividya
Starting Member
3 Posts |
 Posted - 2008-11-03 : 00:13:26
|
| when i try to restore the database in the sql server which is in my local host using the path 'F:\ws\sri' where sri is the database backup filename i am using the query 'restore database spidb from disk='F:\ws\sri'i am getting the following errorMsg 3201, Level 16, State 2, Line 1Cannot open backup device 'F:\ws\sri'. Operating system error 2(The system cannot find the file specified.).Msg 3013, Level 16, State 1, Line 1RESTORE DATABASE is terminating abnormally.help me to clear this error |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-03 : 00:39:23
|
| is the path your local machine path itself (i.e path in machine where you've sql server? |
 |
|
|
cvraghu
Posting Yak Master
187 Posts |
Posted - 2008-11-03 : 01:46:32
|
| Why there is no file extension? Sri.? |
|
|
|
tsrividya
Starting Member
3 Posts |
Posted - 2008-11-03 : 05:11:43
|
yes,sql server in my local machine.quote:
Originally posted by visakh16
is the path your local machine path itself (i.e path in machine where you've sql server?
|
|
|
|
|
|
|
restore problem