default data directory

MS SQL SERVER

    Sponsored Links

    Next

  • 1. SQL 2005 Sept CTP ISO Install Error - Disk 2 required?
    Hi, I downloaded the latest SQL Server CTP ISO and while installing, it asks me to insert Disk-2 . Is that some kind of a joke? Where do you get disk 1 and 2 for an ISO ? Since i dont have a disk, the setup proceeded to rollback and im left with nothing . Does anyone know how to work around that issue? Thanks in advance Benjy
  • 2. Setting up TCP provider (for SQL server 2005) on BIztalk server 20
    I have been trying to configure BTS2K6 to access SQL server 2005 instance on another physical server. If I install SQL server 2005 workstation components on BTS server box, I am getting .NET framework incompatability issues. I got fed up and rebuilt the server to start fresh. I installed only "SQL server 2005 client components" and then installed BTS2005. I started the BTS configuration to connect to the SQL server 2005 instance. It gives error saying that "The database server that you specified can not be reached". However, WSS SP2 is able to see and store information. Does anyone know what the problem is? This is the first time I am seeing such incompatability issues for Microsoft products! Any idea??
  • 3. sql server restore running extremely slow on microsoft virtual ser
    Hi, I have SQL 2000 SP3a installed on MS Virtual Server on a machine with 3GHz Xeon, 2GB RAM. I am trying to perform a test restore of a 60GB DB which has been going on for the past 16 hours now. I can see the physical MDF file of 60GB size already created. I cannot see the DB itself with a "loading" status yet. Currently the waittype is showing "ASYNC_IO_COMPLETION". Additional info: - the .BAK file and the .MDF files are on the same drive. - the original DB is split across multiple data files (5) - Earlier restores for a DB of size 1 GB took around 3 hours Is this normal ? What am I missing ? Please reply as soon as possible. I have a deadline looming over my head :( Thank you. Regards, Salil.
  • 4. Full-text Search not installed....
    I'm installing SQL2K on windows2k server. I'm not too sure why Full-text search is not installed even I have it checked for some reasons. Does anybody know why what're missing? I also get an error: snap-in failed to initialize. what's missing???? Thanks, Tomd

default data directory

Postby Peter Burger » Wed, 07 Jan 2004 00:34:01 GMT

Hello All,

    does anybody know how can I modify the default data directory for
MSDE/MSSQL Server, after installation?

I tried to do it before installtion in command line of setup program for
MSDE, but it appended "MSDE$MSDE" to my path and I do not like it.

Any idea?


Peter



Re: default data directory

Postby Dejan Sarka » Wed, 07 Jan 2004 17:02:32 GMT

The default data directory is in registry. These keys are not present during
setup. You can create them with Enterprise Manager, or manually (I guess you
don't have EM if you are using MSDE), or with ome other tool.

Default Instance
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\DefaultData
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\DefaultLog

Named Instance
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\Instancename\DefaultData
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\Instancename\DefaultLog

Note that you can always create database files on a specific location, which
is preferred method comparing to manually changing the registry.

-- 
Dejan Sarka, SQL Server MVP
Please reply only to the newsgroups.









Re: default data directory

Postby Peter Burger » Thu, 08 Jan 2004 16:09:40 GMT

Thank you,

    but question is how to do it on remote machine... :-)... in general, how
can I specify path relatively to the remote machine?

In case of MSDE it is clear, because MSDE runs localy (in my application),
but how can I let user browse for directory which is on remote machine and
obtain its local (local in sense of remote SQL Server) path... as
Entereprise manage does?


Peter


"Dejan Sarka" < XXXX@XXXXX.COM > wrote in


during
you
which






Re: default data directory

Postby Dejan Sarka » Thu, 08 Jan 2004 19:55:17 GMT

Peter,

There are many free MSDE tools on the Web. I don't know from my head whether
there is some that would allow you to do what you want, but you can check
some of them. Otherwise, you could use VPN.

-- 
Dejan Sarka, SQL Server MVP
Please reply only to the newsgroups.





how

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\DefaultData



for



Similar Threads:

1.how to change default data directory for SQL 2005

Hi,  I've installed SQL 2005 and failed to change the default data
location during installation.  Now I want to change it.  Can I do this
without having to uninstall and reinstall?  And furthermore, is there a
system stored procedure I can use to move existing data and log files
(master, msdb, AdventureWorks, etc.)?  I seem to remember doing just
this with SQL 2000 some time back.

Thanks,
Eric

2.set default data directory??

I know SQL 2005 will put its program files in C:\Program Files etc.

How do I make SQL 2005 always put databases and related files (logs
etc.) on the D:\ drive, which will be much bigger than C:\, with room
to grow, etc.??

This is the SQL backend for a Windows SharePoint Services 3.x intranet
setup.

Thank you, Tom

3.Finding Default Data Directory Programmatically

I've seen this topic kicked about a bit in my Google searches, but it was
either answered incorrectly or not quite what I need.

THE PROBLEM:  I need to be able to create a database programmatically (via
OSQL) in SQL 2000 from a remote system.  In the CREATE DATABASE statement, I
need to specify paths for the .mdf and .ldf files.  I want them to be put in
the default data directory.

NON-SOLUTION #1:  Omit any path information in CREATE DATABASE, e.g.:
---------------------
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'GF1')
DROP DATABASE [GF1]
GO
CREATE DATABASE [GF1] ON (NAME = N'GF1_dat', FILENAME = N'GF1.mdf' ,
    SIZE = 5, FILEGROWTH = 10%) LOG ON (NAME = N'GF1_log',
    FILENAME = N'GF1.ldf' , SIZE = 1, FILEGROWTH = 10%)
COLLATE SQL_Latin1_General_CP1_CI_AS
GO
---------------------
IMO, this should do exactly what I want--I don't specify a path so, It goes
into the default path!  Unfortunately, this returns an error:
---------------------
Device activation error. The physical file name 'GF1.mdf' may be
incorrect.
Msg 1802, Level 16, State 1, Server C3P0, Line 2
CREATE DATABASE failed. Some file names listed could not be created.
Check previous errors.
-------------------------
NON-SOLUTION #2:  Read the path from the registry, e.g.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup\SQLDataRoot, e.g.
via xp_regread or some such.  Unfortunately this does not work if the
server's default data path has been changed post-install.
-------------------------
NON-SOLUTION #3:  Find the pathname for the 'master' DB and use that--but
that suffers from the same limit as #2.
-------------------------
It's hard to comprehend why this is so tough to do--either I'm missing
something or SQL2K is!  Thanks for any ideas.

Paul J. Neary
G&Z Systems, Inc
Hawthorne, NY
paul AT g-and-z DOT com
(please reply to NG)


4.Get the Default data directory path

Hi

I need to get the "Default Data Directory" option that is set at the
Database Global settings. Is there any built-in procedure for this that may
work both for SQL server and MSDE. Please suggest.

Regards

Usman


5.SQL Instance default data directory.

Hi,

Does somebody knows how I can, by means, of T-SQL/SP 
command other than sp_helpdb, request what the default 
data directory of a SQL Instance is? 

Or if you can tell me how to catch the column filename of 
the second result set of (exec sp_helpdb 'master') in a 
variable, would also be help full.

Cheers,

Jacques Bonapart
 XXXX@XXXXX.COM 







6. [SQL SERVER 2000] change default data directory path

7. Default data directory SQL2005 install

8. Change default data directory and copy db to it



Return to MS SQL SERVER

 

Who is online

Users browsing this forum: No registered users and 96 guest