Re: SQL Server question

You cannot use a network-shared folder to store the database files. The KB article you mentioned the phrase below

"If access to a disk resource requires that a share be mapped, or if the disk resource appears as a remote server through a UNC path, (for example, \\Servername\Sharename), on the network, then by default, the disk storage system is not supported as a location for SQL Server databases. "

If I were you, I'd invest in a hard drive for this purpose. Plus, this would cause additional bottleneck in the database transactions since it would need to go out of the network to execute the commands

"Mike Webb" <mikewebb@xxxxxxxxxxx> wrote in message news:Oaaf1qV5IHA.3784@xxxxxxxxxxxxxxxxxxxxxxx
Setup: Two servers - DC is SBS 2003 Premium SP1, the other server is an
Application Server running Windows Server 2003 R2 SP2.

Question: How do I use a Trace Flag, together with a Stored Procedure, to
place the database files for a named instance from teh SBS server to the
Aplication Server?

Justification: The Application Server is running Office Sharepoint Server
2007 (MOSS 2007). It has 3 partitions, with the 3rd partition set aside for
the SQL database files. The SBS server doesn't have adequate HD space for
the expected growth in one year of the database. I want to leverage SQL
Server on SBS for MOSS, while using the Application server's HD space for
the database. I found MS Article ID 224071 dated 2 October 2007
(http://support.microsoft.com/kb/224071) to help me move the files. But I
was unsuccessful. Further research found I need to set a Trace Flag, per KB
http://support.microsoft.com/kb/304261. I next looked at SQL Server Books
Online to find out what a Trace Falg was and found this:
http://msdn.microsoft.com/en-us/library/ms188396.aspx .

I'm very much a newbie with SQL commands and such - if it's not in a SBS
Admin - type book (such as Harry Brelsford's 2 books), I don't know it,nor
can reference it frm one of the books.

Can someone tell me what to do, or point me to a resource?

--
MikeWebb
Platte River Whooping Crane Maintenance Trust, Inc.
a conservation non-profit (501(c)(3)) organization





.

Relevant Pages

  • Re: SQL Desktop Edition
    ... You need to make the database files available in SLQ server. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: How do I install AdventureWorks on SqlServer 2005?
    ... The .msi just copies the database files to your local machine. ... Server Management Studio, you need to attach the database to your instance ... of SQL Server. ...
    (microsoft.public.sqlserver.setup)
  • RE: MSSQL Server Recovery
    ... Assuming you have all database files (including system databases - master, ... Install SQL Server to the same location on the second server (as your ...
    (microsoft.public.sqlserver.server)
  • Re: How do I fix this cluster???
    ... so a 2 node cluster. ... I also have separate instances of SQL ... Server on the separate physical servers. ... either not on a cluster disk resource, or if it is, the resource may be ...
    (microsoft.public.sqlserver.clustering)
  • Re: Deploying a SQL Server App
    ... Generally you don't want to deploy the database files per se (although SQL ... the database to the server. ... >> Instread of using connection strings that are hard coded into your ...
    (microsoft.public.dotnet.framework.aspnet)
Loading