Re: restoring from network drive
From: Gregory A. Larsen (greg.larsen_at_netzero.com)
Date: 06/16/04
- Next message: Paul Ibison: "Re: sql to xml"
- Previous message: Kevin3NF: "Re: Transaction Log Backup Files aren't removed"
- In reply to: JT: "restoring from network drive"
- Next in thread: Rick: "restoring from network drive"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 16 Jun 2004 08:37:40 -0700
Try entering a UNC name for the name of the backup, something like:
\\backupserver\sharename\backup\database.bak
Also note the MSSQLSERVER service account will need access to the network
share.
-- ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ---- Need SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples "JT" <JT_*n*o*s*p*a*m*Goalie33@cox.net> wrote in message news:WAZzc.4489$cj3.1501@lakeread01... > Ok -I'm drawing a huge blank. > > After a new install of SQL2K and SP3a, I'm unable to restore a backup from a > network drive. > SQL services are logging on with a domain account > The SQL service account has also been granted Local admin access on the PC > > When trying to restore a database from Device, the only drive listed is the > local C: drive - none of the mapped drives are available. > > JT > >
- Next message: Paul Ibison: "Re: sql to xml"
- Previous message: Kevin3NF: "Re: Transaction Log Backup Files aren't removed"
- In reply to: JT: "restoring from network drive"
- Next in thread: Rick: "restoring from network drive"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
