March 10, 2009 at 12:46 am
hi friends
Recently i install win 2003 Enterprise edition with SP2 and sql server 2000 sp4
i created some databases
and i mapped network drive where all backup is stored
now through query analyser i try to restore the database ..its showing error ..device off line..
i checked all permission..every think ok..please help me
error is
"Device error or device off-line. See the SQL Server error log for more details."
please help
March 10, 2009 at 3:44 am
Are you trying to restore from a mapped network drive or from a UNC path? Remember that the mapped network drive is visible only to the user who did the mapping and not to all users.
I've been working in the past with UNC paths in SQLServer 2000 and I had to activate a particular trace to make it all work, but now I don't remember the exact trace number. I can do some search if you wish.
Gianluca
-- Gianluca Sartori
March 10, 2009 at 5:09 am
thank a lot
i am using mapping drive only
please give the full details of UNC Method
March 10, 2009 at 7:10 am
I'm sorry, I was wrong about the trace flag, beacuse it only applies to databases on UNC path. You can read this if you want some more information: http://www.sqldba.org/articles/43-sql-server-database-on-UNC-network-drive-trace-flag-1807.aspx.
For your restore problem, try using the UNC path instead of the mapped drive. Remember that the permissions must be applied to the SQL server service user and not to your interactive user. This means that if SQL server is running with local system account, it has no network access.
Hope this help
Gianluca
-- Gianluca Sartori
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply