|
|
You're in the
sql server new users
group:SQL 2005 Database Location
sql server new users:
'default' location for new databases. To move the current databases, see: Moving Databases to a new location http://support.microsoft.com/kb/224071/EN-US/ -- Arnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous [quoted text, click to view] "SW" <SW@nospam.invalid> wrote in message news:ePN$QnY4GHA.3556@TK2MSFTNGP02.phx.gbl... > Hi, > > I installed SQL 2005 onto my D: drive but somehow the data is being stored > on my C: drive. (I only noticed this when my c: drive filled up!). > In Server Properties, there is a Default location for datafiles box. If I > just enter the desired location in there (it's currently blank) will the > existing data be transferred to the new location? > > Thanks in advance, > > SW >
Hi,
I installed SQL 2005 onto my D: drive but somehow the data is being stored on my C: drive. (I only noticed this when my c: drive filled up!). In Server Properties, there is a Default location for datafiles box. If I just enter the desired location in there (it's currently blank) will the existing data be transferred to the new location? Thanks in advance, SW
Thank you Arnie, that's done the job.
SW [quoted text, click to view] "Arnie Rowland" <arnie@1568.com> wrote in message news:e0wqNtY4GHA.3400@TK2MSFTNGP04.phx.gbl... > No the existing data will remain in its present location. That defines the > 'default' location for new databases. > > To move the current databases, see: > > Moving Databases to a new location > http://support.microsoft.com/kb/224071/EN-US/ > > > -- > Arnie Rowland, Ph.D. > Westwood Consulting, Inc > > Most good judgment comes from experience. > Most experience comes from bad judgment. > - Anonymous > > > "SW" <SW@nospam.invalid> wrote in message > news:ePN$QnY4GHA.3556@TK2MSFTNGP02.phx.gbl... >> Hi, >> >> I installed SQL 2005 onto my D: drive but somehow the data is being >> stored on my C: drive. (I only noticed this when my c: drive filled up!). >> In Server Properties, there is a Default location for datafiles box. If I >> just enter the desired location in there (it's currently blank) will the >> existing data be transferred to the new location? >> >> Thanks in advance, >> >> SW >> > >
Arnie,
The "How to" article was fine for moving the user databases, but when I tried to move the Model database, I couldn't restart the SQL Server Agent after adding -T3608 to the start up parameters, and I also got an error message when I tried to detach the Model database: Location: dbmgr.cpp:6728 Expression: !FindDB(dbid) SPID: 53 Process ID: 2872 Msg 3624, Level 20, State 1, Line 1 A system assertion check has failed. Check the SQL Server error log for details The SQL Server error log showed that there was a problem with Agent XPs. Is there something else I should be doing? Regards SW [quoted text, click to view] "Arnie Rowland" <arnie@1568.com> wrote in message news:e0wqNtY4GHA.3400@TK2MSFTNGP04.phx.gbl... > No the existing data will remain in its present location. That defines the > 'default' location for new databases. > > To move the current databases, see: > > Moving Databases to a new location > http://support.microsoft.com/kb/224071/EN-US/ > > > -- > Arnie Rowland, Ph.D. > Westwood Consulting, Inc > > Most good judgment comes from experience. > Most experience comes from bad judgment. > - Anonymous > > > "SW" <SW@nospam.invalid> wrote in message > news:ePN$QnY4GHA.3556@TK2MSFTNGP02.phx.gbl... >> Hi, >> >> I installed SQL 2005 onto my D: drive but somehow the data is being >> stored on my C: drive. (I only noticed this when my c: drive filled up!). >> In Server Properties, there is a Default location for datafiles box. If I >> just enter the desired location in there (it's currently blank) will the >> existing data be transferred to the new location? >> >> Thanks in advance, >> >> SW >> > >
You didn't say 'system databases'. That is VERY different, as you noticed.
Here is additional information. http://msdn2.microsoft.com/en-us/library/ms345408(en-US,SQL.90).aspx Moving system dbs 2005 http://www.databasejournal.com/features/mssql/article.php/3379901 Moving system DB's 2000 http://www.support.microsoft.com/?id=314546 Moving DB's between Servers http://www.support.microsoft.com/?id=221465 Using WITH MOVE in a Restore -- Arnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous [quoted text, click to view] "SW" <SW@nospam.invalid> wrote in message news:%23O6wfmt4GHA.4560@TK2MSFTNGP03.phx.gbl... > Arnie, > > The "How to" article was fine for moving the user databases, but when I > tried to move the Model database, I couldn't restart the SQL Server Agent > after adding -T3608 to the start up parameters, and I also got an error > message when I tried to detach the Model database: > > Location: dbmgr.cpp:6728 > Expression: !FindDB(dbid) > SPID: 53 > Process ID: 2872 > Msg 3624, Level 20, State 1, Line 1 > A system assertion check has failed. Check the SQL Server error log for > details > > The SQL Server error log showed that there was a problem with Agent XPs. > > Is there something else I should be doing? > > Regards > SW > > "Arnie Rowland" <arnie@1568.com> wrote in message > news:e0wqNtY4GHA.3400@TK2MSFTNGP04.phx.gbl... >> No the existing data will remain in its present location. That defines >> the 'default' location for new databases. >> >> To move the current databases, see: >> >> Moving Databases to a new location >> http://support.microsoft.com/kb/224071/EN-US/ >> >> >> -- >> Arnie Rowland, Ph.D. >> Westwood Consulting, Inc >> >> Most good judgment comes from experience. >> Most experience comes from bad judgment. >> - Anonymous >> >> >> "SW" <SW@nospam.invalid> wrote in message >> news:ePN$QnY4GHA.3556@TK2MSFTNGP02.phx.gbl... >>> Hi, >>> >>> I installed SQL 2005 onto my D: drive but somehow the data is being >>> stored on my C: drive. (I only noticed this when my c: drive filled >>> up!). >>> In Server Properties, there is a Default location for datafiles box. If >>> I just enter the desired location in there (it's currently blank) will >>> the existing data be transferred to the new location? >>> >>> Thanks in advance, >>> >>> SW >>> >> >> > >
Don't see what you're looking for? Try a search.
|
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |