Default location of Data bases

Hi All,
I moved my main database from the C drive to the D drive
of my server. I left the rest of them on the C drive.
(master, msdb...) When I try to create a new DB it
defaults to the C drive since that is the way I installed
it. Is there a way to change that to the D drive with out
uninstalling and reinstalling?
Thanks,
JoeIn EM, right click on Server, then Properties. On Database Settings tab
choose Default data directory and Default log directory.
Ana
"JOE" <anonymous@.discussions.microsoft.com> wrote in message
news:25c801c3fc6f$3a86d470$a101280a@.phx.gbl...
> Hi All,
> I moved my main database from the C drive to the D drive
> of my server. I left the rest of them on the C drive.
> (master, msdb...) When I try to create a new DB it
> defaults to the C drive since that is the way I installed
> it. Is there a way to change that to the D drive with out
> uninstalling and reinstalling?
> Thanks,
> Joe|||Thankssql

Default location of Data bases

Hi All,
I moved my main database from the C drive to the D drive
of my server. I left the rest of them on the C drive.
(master, msdb...) When I try to create a new DB it
defaults to the C drive since that is the way I installed
it. Is there a way to change that to the D drive with out
uninstalling and reinstalling?
Thanks,
JoeIn EM, right click on Server, then Properties. On Database Settings tab
choose Default data directory and Default log directory.
Ana
"JOE" <anonymous@.discussions.microsoft.com> wrote in message
news:25c801c3fc6f$3a86d470$a101280a@.phx.gbl...
> Hi All,
> I moved my main database from the C drive to the D drive
> of my server. I left the rest of them on the C drive.
> (master, msdb...) When I try to create a new DB it
> defaults to the C drive since that is the way I installed
> it. Is there a way to change that to the D drive with out
> uninstalling and reinstalling?
> Thanks,
> Joe|||Thanks

Default Drive for new DBs

Is there a way to change the default location, including drive, of a SQL
isntall that was initially installed to the C drive?Space Junk wrote:
> Is there a way to change the default location, including drive, of a
> SQL isntall that was initially installed to the C drive?
By "default location", do you mean where the executables are installed?
Or do you mean where the data and log files are installed?
--
David Gugick
Imceda Software
www.imceda.com|||I mean where data and logs are installed by default. Sorry I thought I said
that.
Example, adding a bigger HDD to a system and needing new data bases to
default to the new drive.
"David Gugick" wrote:
> Space Junk wrote:
> > Is there a way to change the default location, including drive, of a
> > SQL isntall that was initially installed to the C drive?
> By "default location", do you mean where the executables are installed?
> Or do you mean where the data and log files are installed?
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||Space Junk wrote:
> I mean where data and logs are installed by default. Sorry I thought
> I said that.
> Example, adding a bigger HDD to a system and needing new data bases to
> default to the new drive.
Just add a new data file on the database to the new drive. SQL Server
will fill the data files (or log files) proportionally. If you want to
actually move the data and log files, you can use sp_detachdb and
sp_attach_db / sp_attach_single_file_db to disconnect them and reconnect
once they are on the new drive.
--
David Gugick
Imceda Software
www.imceda.com|||You can specify the database default folders for data and log files from
Enterprise Manager under server properties --> database settings.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Space Junk" <SpaceJunk@.discussions.microsoft.com> wrote in message
news:A66E48D4-8B2B-4948-B349-F2BDA2EFA09A@.microsoft.com...
> Is there a way to change the default location, including drive, of a SQL
> isntall that was initially installed to the C drive?|||I know how to move a data base, and data base settings only shows the C
drive. I do not need to change the folder data bases are being stored in. I
need to change the DEFAULT drive.
It is looking like a re-installation.
"Dan Guzman" wrote:
> You can specify the database default folders for data and log files from
> Enterprise Manager under server properties --> database settings.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Space Junk" <SpaceJunk@.discussions.microsoft.com> wrote in message
> news:A66E48D4-8B2B-4948-B349-F2BDA2EFA09A@.microsoft.com...
> > Is there a way to change the default location, including drive, of a SQL
> > isntall that was initially installed to the C drive?
>
>|||I tried a different physical HDD and then that new drive showed up under DB
Settings under DB properties. I am not sure why the other functioning drive
did not show up.
"Space Junk" wrote:
> I know how to move a data base, and data base settings only shows the C
> drive. I do not need to change the folder data bases are being stored in. I
> need to change the DEFAULT drive.
> It is looking like a re-installation.
> "Dan Guzman" wrote:
> > You can specify the database default folders for data and log files from
> > Enterprise Manager under server properties --> database settings.
> >
> > --
> > Hope this helps.
> >
> > Dan Guzman
> > SQL Server MVP
> >
> > "Space Junk" <SpaceJunk@.discussions.microsoft.com> wrote in message
> > news:A66E48D4-8B2B-4948-B349-F2BDA2EFA09A@.microsoft.com...
> > > Is there a way to change the default location, including drive, of a SQL
> > > isntall that was initially installed to the C drive?
> >
> >
> >|||Space Junk wrote:
You can easily default new database data and log files under the
database settings tab in SQL EM. Just change the Default Data and
Default Log locations.
David Gugick
Imceda Software
www.imceda.com|||I was trying that, however me previous second HDD was not showing up in
there, only drive C. Not sure why, the drive was functioning normally. I
put a new drive in, and check again, then I had the option to choose other
than the C drive.
"David Gugick" wrote:
> Space Junk wrote:
> You can easily default new database data and log files under the
> database settings tab in SQL EM. Just change the Default Data and
> Default Log locations.
>
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>sql

Default Drive for new DBs

Is there a way to change the default location, including drive, of a SQL
isntall that was initially installed to the C drive?
Space Junk wrote:
> Is there a way to change the default location, including drive, of a
> SQL isntall that was initially installed to the C drive?
By "default location", do you mean where the executables are installed?
Or do you mean where the data and log files are installed?
David Gugick
Imceda Software
www.imceda.com
|||I mean where data and logs are installed by default. Sorry I thought I said
that.
Example, adding a bigger HDD to a system and needing new data bases to
default to the new drive.
"David Gugick" wrote:

> Space Junk wrote:
> By "default location", do you mean where the executables are installed?
> Or do you mean where the data and log files are installed?
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
|||Space Junk wrote:
> I mean where data and logs are installed by default. Sorry I thought
> I said that.
> Example, adding a bigger HDD to a system and needing new data bases to
> default to the new drive.
Just add a new data file on the database to the new drive. SQL Server
will fill the data files (or log files) proportionally. If you want to
actually move the data and log files, you can use sp_detachdb and
sp_attach_db / sp_attach_single_file_db to disconnect them and reconnect
once they are on the new drive.
David Gugick
Imceda Software
www.imceda.com
|||You can specify the database default folders for data and log files from
Enterprise Manager under server properties --> database settings.
Hope this helps.
Dan Guzman
SQL Server MVP
"Space Junk" <SpaceJunk@.discussions.microsoft.com> wrote in message
news:A66E48D4-8B2B-4948-B349-F2BDA2EFA09A@.microsoft.com...
> Is there a way to change the default location, including drive, of a SQL
> isntall that was initially installed to the C drive?
|||I know how to move a data base, and data base settings only shows the C
drive. I do not need to change the folder data bases are being stored in. I
need to change the DEFAULT drive.
It is looking like a re-installation.
"Dan Guzman" wrote:

> You can specify the database default folders for data and log files from
> Enterprise Manager under server properties --> database settings.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Space Junk" <SpaceJunk@.discussions.microsoft.com> wrote in message
> news:A66E48D4-8B2B-4948-B349-F2BDA2EFA09A@.microsoft.com...
>
>
|||I tried a different physical HDD and then that new drive showed up under DB
Settings under DB properties. I am not sure why the other functioning drive
did not show up.
"Space Junk" wrote:
[vbcol=seagreen]
> I know how to move a data base, and data base settings only shows the C
> drive. I do not need to change the folder data bases are being stored in. I
> need to change the DEFAULT drive.
> It is looking like a re-installation.
> "Dan Guzman" wrote:
|||Space Junk wrote:
You can easily default new database data and log files under the
database settings tab in SQL EM. Just change the Default Data and
Default Log locations.
David Gugick
Imceda Software
www.imceda.com
|||I was trying that, however me previous second HDD was not showing up in
there, only drive C. Not sure why, the drive was functioning normally. I
put a new drive in, and check again, then I had the option to choose other
than the C drive.
"David Gugick" wrote:

> Space Junk wrote:
> You can easily default new database data and log files under the
> database settings tab in SQL EM. Just change the Default Data and
> Default Log locations.
>
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>

Default Drive for new DBs

Is there a way to change the default location, including drive, of a SQL
isntall that was initially installed to the C drive?Space Junk wrote:
> Is there a way to change the default location, including drive, of a
> SQL isntall that was initially installed to the C drive?
By "default location", do you mean where the executables are installed?
Or do you mean where the data and log files are installed?
David Gugick
Imceda Software
www.imceda.com|||I mean where data and logs are installed by default. Sorry I thought I said
that.
Example, adding a bigger HDD to a system and needing new data bases to
default to the new drive.
"David Gugick" wrote:

> Space Junk wrote:
> By "default location", do you mean where the executables are installed?
> Or do you mean where the data and log files are installed?
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||Space Junk wrote:
> I mean where data and logs are installed by default. Sorry I thought
> I said that.
> Example, adding a bigger HDD to a system and needing new data bases to
> default to the new drive.
Just add a new data file on the database to the new drive. SQL Server
will fill the data files (or log files) proportionally. If you want to
actually move the data and log files, you can use sp_detachdb and
sp_attach_db / sp_attach_single_file_db to disconnect them and reconnect
once they are on the new drive.
David Gugick
Imceda Software
www.imceda.com|||You can specify the database default folders for data and log files from
Enterprise Manager under server properties --> database settings.
Hope this helps.
Dan Guzman
SQL Server MVP
"Space Junk" <SpaceJunk@.discussions.microsoft.com> wrote in message
news:A66E48D4-8B2B-4948-B349-F2BDA2EFA09A@.microsoft.com...
> Is there a way to change the default location, including drive, of a SQL
> isntall that was initially installed to the C drive?|||I know how to move a data base, and data base settings only shows the C
drive. I do not need to change the folder data bases are being stored in.
I
need to change the DEFAULT drive.
It is looking like a re-installation.
"Dan Guzman" wrote:

> You can specify the database default folders for data and log files from
> Enterprise Manager under server properties --> database settings.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Space Junk" <SpaceJunk@.discussions.microsoft.com> wrote in message
> news:A66E48D4-8B2B-4948-B349-F2BDA2EFA09A@.microsoft.com...
>
>|||I tried a different physical HDD and then that new drive showed up under DB
Settings under DB properties. I am not sure why the other functioning drive
did not show up.
"Space Junk" wrote:
[vbcol=seagreen]
> I know how to move a data base, and data base settings only shows the C
> drive. I do not need to change the folder data bases are being stored in.
I
> need to change the DEFAULT drive.
> It is looking like a re-installation.
> "Dan Guzman" wrote:
>|||Space Junk wrote:
You can easily default new database data and log files under the
database settings tab in SQL EM. Just change the Default Data and
Default Log locations.
David Gugick
Imceda Software
www.imceda.com|||I was trying that, however me previous second HDD was not showing up in
there, only drive C. Not sure why, the drive was functioning normally. I
put a new drive in, and check again, then I had the option to choose other
than the C drive.
"David Gugick" wrote:

> Space Junk wrote:
> You can easily default new database data and log files under the
> database settings tab in SQL EM. Just change the Default Data and
> Default Log locations.
>
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>

Default Backup Directory

I have put my backup directory on a seperate drive from the data and logs.
Is the only way to change the default backup directory (that shows up when
you create a new maintenance plan) is to change the registry entry or is
there some option/ parameter that will do this?
Thanks
MACason,
Declare @.Backup_Directory VarChar(255)
exec master..xp_regread 'HKEY_LOCAL_MACHINE' ,
'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer',
'BackupDirectory', @.Backup_Directory OUTPUT
Select @.Backup_Directory
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
MACason wrote:
> I have put my backup directory on a seperate drive from the data and logs.
> Is the only way to change the default backup directory (that shows up when
> you create a new maintenance plan) is to change the registry entry or is
> there some option/ parameter that will do this?
> Thanks

Default Backup Directory

I have put my backup directory on a seperate drive from the data and logs.
Is the only way to change the default backup directory (that shows up when
you create a new maintenance plan) is to change the registry entry or is
there some option/ parameter that will do this?
ThanksMACason,
Declare @.Backup_Directory VarChar(255)
exec master..xp_regread 'HKEY_LOCAL_MACHINE' ,
'SOFTWARE\Microsoft\MSSQLServer\MSSQLSer
ver',
'BackupDirectory', @.Backup_Directory OUTPUT
Select @.Backup_Directory
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
MACason wrote:
> I have put my backup directory on a seperate drive from the data and logs
.
> Is the only way to change the default backup directory (that shows up when
> you create a new maintenance plan) is to change the registry entry or is
> there some option/ parameter that will do this?
> Thanks

Deault location for RSTempFiles

I currently have RS installed on my C: drive. Unfortunately, I did not
realize how much free space I was going to need for temp files, so now I'm
running out of space on my C: drive and RS restarts several times during a
schedule. Is it possible for me to point RSTempFiles to another drive
letter? I've searched for configuration files and the registry, but can't
find anything.
ThanksYes it is possible. It is documented in the SP1 readme. You can find this
here:
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm
Just search for RSTempFiles.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"troark" <t.roark@.excite.com.n0sp@.m> wrote in message
news:ei0jQFJpEHA.3896@.TK2MSFTNGP15.phx.gbl...
> I currently have RS installed on my C: drive. Unfortunately, I did not
> realize how much free space I was going to need for temp files, so now I'm
> running out of space on my C: drive and RS restarts several times during a
> schedule. Is it possible for me to point RSTempFiles to another drive
> letter? I've searched for configuration files and the registry, but can't
> find anything.
> Thanks
>|||Great. Worked like a charm!
Thanks
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:eEtgK8JpEHA.644@.tk2msftngp13.phx.gbl...
> Yes it is possible. It is documented in the SP1 readme. You can find
this
> here:
>
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79dd
aa510/SP1Readme_EN.htm
> Just search for RSTempFiles.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "troark" <t.roark@.excite.com.n0sp@.m> wrote in message
> news:ei0jQFJpEHA.3896@.TK2MSFTNGP15.phx.gbl...
> > I currently have RS installed on my C: drive. Unfortunately, I did not
> > realize how much free space I was going to need for temp files, so now
I'm
> > running out of space on my C: drive and RS restarts several times during
a
> > schedule. Is it possible for me to point RSTempFiles to another drive
> > letter? I've searched for configuration files and the registry, but
can't
> > find anything.
> >
> > Thanks
> >
> >
>