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 |
|
alex_nfs_fan
Starting Member
2 Posts |
 Posted - 2004-10-29 : 15:26:24
|
| My problem si so simple but i´m an SQL newbie...I´m trying to restore a database from a network drive with this sentence:RESTORE DATABASE XSSSX FROM disk = 'S:\Something.bkp'where S is the network drive but I obtain this error:Server: Msg 3201, Level 16, State 2, Line 1Cannot open backup device 'S:\Something.bkp'. Device error or device off-line. See the SQL Server error log for more details.Server: Msg 3013, Level 16, State 1, Line 1RESTORE DATABASE is terminating abnormally.Can anoyone help me?Thx! |
|
|
surefooted
Posting Yak Master
188 Posts |
Posted - 2004-10-29 : 15:59:25
|
SQL Server's rights are what ever service account's rights that it's running under. If it's running as Localsystem, it has no access to a networked drive since it isn't a network authenticated account. Make sure SQL Server has the appopriate permissions to that networked drive.-JonShould still be a "Starting Member"  . |
 |
|
|
surefooted
Posting Yak Master
188 Posts |
Posted - 2004-10-29 : 16:01:31
|
| BTW, you need to use a UNC naming standard name \\servername\share\blah.bak-JonShould still be a "Starting Member" . |
|
|
|
alex_nfs_fan
Starting Member
2 Posts |
Posted - 2004-10-29 : 17:08:13
|
| Thanks a lot!!!That solved my problem! |
|
|
|
|
|
|
Help with restore