Re: Changing Data Storage Location to Network Drive

What do you really want to do? Keep a copy of your database files on a remote machine in your network?

Or keep the client tools on the current server and move your database engine and files to another server?

Or are you looking for a NAS \ SAN solution?

--
Ekrem Önsoy



"rmcompute" <rmcompute@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:383C35FA-97D4-41DF-98E2-E1C1A001901F@xxxxxxxxxxxxxxxx
Not the answer I wanted to hear, but thanks for the information.

"Andrew J. Kelly" wrote:

SQL Server does not support databases hosted on a network drive.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"rmcompute" <rmcompute@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0AEC1BEF-DAF7-4DCC-AAA1-8E253679A653@xxxxxxxxxxxxxxxx
>I installed SQL Server on my PC and have created a few databases which >have
> been saved there. I would like to leave SQL Server installed on my PC,
> but
> have all of the databases moved to the network drive. Where would I > make
> this change and are there any precautions I need to take since the
> database
> is already created. Also, once I locate the file holding the data, > can
> it
> simply be copied to the network drive?



.

Relevant Pages

  • Re: Other Users dont see table updates
    ... Database systems are not real time network communication ... Where people really want real-time network ... people used sql server to send mail messages - ...
    (comp.databases.ms-access)
  • Re: changing db location on sql2000
    ... Can you not back this database up? ... backups do support UNC paths...and ... manipulated some and put into a new sql server system. ... Therefore I wish MS had let us decide if it was ok to use a usb or network ...
    (microsoft.public.sqlserver.setup)
  • Re: changing db location on sql2000
    ... Tibor Karaszi, SQL Server MVP ... Therefore I wish MS had let us decide if it was ok to use a usb or network share or whatever to store the data. ... Since your USB drive was showed as a network share, SQL Server could not use it for storing database files. ... If your database is very large, you may consider using SAN, NAS etc which are fast and scalable network storage solutions. ...
    (microsoft.public.sqlserver.setup)
  • ODBC Connection with SQL Managed Provider
    ... on a "network drive". ... database using the Microsoft .NET Framework 1.1 Data Provider for SQL ... authorizing the user against a table in the SQL server database. ... for the app to display the "splash" screen (which is the first thing it does ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Linked Tables Losing Data
    ... Jerry Whittle wrote: ... network is losing records. ... industrial strength database like SQL Server or Oracle. ... In all cases, even with SQL Server and Oracle, nothing beats a recent, ...
    (microsoft.public.access.tablesdbdesign)