Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

backup to network


I am using sql server 2000 with the default instance (if that matters), and I
would like to save backups to a network drive however I can't see anything
more than the local disks from Enterprise Manager.  How can I get around this?

thanks

Andre

First backup to local disk and then copy resulting files to network drive

HTH
Alex

"Andre Gibson" <AndreGib@discussions.microsoft.com> wrote in message

news:0433B72C-BE8B-4F03-AA35-A8A204730A65@microsoft.com...

HI

On the server machine create a mapped drive pointing to your backup folder

--
Vt
Knowledge is power;Share it
http://oneplace4sql.blogspot.com

"Andre Gibson" <AndreGib@discussions.microsoft.com> wrote in message

news:0433B72C-BE8B-4F03-AA35-A8A204730A65@microsoft.com...

Use UNC Naming  (i.e. \\server\share\...)

NOTE:  You will be unable to do this unless the service logins for sql
server (and the agent if automated jobs) have permissions to the remote
share.

--
TheSQLGuru
President
Indicium Resources, Inc.

"Andre Gibson" <AndreGib@discussions.microsoft.com> wrote in message

news:0433B72C-BE8B-4F03-AA35-A8A204730A65@microsoft.com...

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc