Moving system database physical file locations

Hi,
as I'm sure most of you know system databases (except msdb) cannot be
detached and re-attached in SQL Server. Unfortunately I have inherited a SQL
Server environment where the system databases are located on a small
partition and this is causing the partition to run out of disk as it contains
the tempdb database. Does anyone know of a way to move the physical files
for system databases...or will I need to backup all of the databases,
re-install SQL Server and restore the database backups?
Cheers
--
John - DBAHi John,
This KB article should provide all the information you need.
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"John" <John@.discussions.microsoft.com> wrote in message
news:FD9BE33F-1AAA-4D58-8134-4A76223ABB2E@.microsoft.com...
> Hi,
> as I'm sure most of you know system databases (except msdb) cannot be
> detached and re-attached in SQL Server. Unfortunately I have inherited a
> SQL
> Server environment where the system databases are located on a small
> partition and this is causing the partition to run out of disk as it
> contains
> the tempdb database. Does anyone know of a way to move the physical files
> for system databases...or will I need to backup all of the databases,
> re-install SQL Server and restore the database backups?
> Cheers
> --
> John - DBA|||"John" <John@.discussions.microsoft.com> wrote in message
news:FD9BE33F-1AAA-4D58-8134-4A76223ABB2E@.microsoft.com...
> Hi,
> as I'm sure most of you know system databases (except msdb) cannot be
> detached and re-attached in SQL Server. Unfortunately I have inherited a
> SQL
> Server environment where the system databases are located on a small
> partition and this is causing the partition to run out of disk as it
> contains
> the tempdb database. Does anyone know of a way to move the physical files
> for system databases...or will I need to backup all of the databases,
> re-install SQL Server and restore the database backups?
Detach, move files, reattach.
Regards, Wojteksql

Moving system database physical file locations

Hi,
as I'm sure most of you know system databases (except msdb) cannot be
detached and re-attached in SQL Server. Unfortunately I have inherited a SQL
Server environment where the system databases are located on a small
partition and this is causing the partition to run out of disk as it contains
the tempdb database. Does anyone know of a way to move the physical files
for system databases...or will I need to backup all of the databases,
re-install SQL Server and restore the database backups?
Cheers
John - DBA
Hi John,
This KB article should provide all the information you need.
http://support.microsoft.com/default...b;en-us;224071
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"John" <John@.discussions.microsoft.com> wrote in message
news:FD9BE33F-1AAA-4D58-8134-4A76223ABB2E@.microsoft.com...
> Hi,
> as I'm sure most of you know system databases (except msdb) cannot be
> detached and re-attached in SQL Server. Unfortunately I have inherited a
> SQL
> Server environment where the system databases are located on a small
> partition and this is causing the partition to run out of disk as it
> contains
> the tempdb database. Does anyone know of a way to move the physical files
> for system databases...or will I need to backup all of the databases,
> re-install SQL Server and restore the database backups?
> Cheers
> --
> John - DBA
|||"John" <John@.discussions.microsoft.com> wrote in message
news:FD9BE33F-1AAA-4D58-8134-4A76223ABB2E@.microsoft.com...
> Hi,
> as I'm sure most of you know system databases (except msdb) cannot be
> detached and re-attached in SQL Server. Unfortunately I have inherited a
> SQL
> Server environment where the system databases are located on a small
> partition and this is causing the partition to run out of disk as it
> contains
> the tempdb database. Does anyone know of a way to move the physical files
> for system databases...or will I need to backup all of the databases,
> re-install SQL Server and restore the database backups?
Detach, move files, reattach.
Regards, Wojtek

Moving system database physical file locations

Hi,
as I'm sure most of you know system databases (except msdb) cannot be
detached and re-attached in SQL Server. Unfortunately I have inherited a SQ
L
Server environment where the system databases are located on a small
partition and this is causing the partition to run out of disk as it contain
s
the tempdb database. Does anyone know of a way to move the physical files
for system databases...or will I need to backup all of the databases,
re-install SQL Server and restore the database backups?
Cheers
John - DBAHi John,
This KB article should provide all the information you need.
http://support.microsoft.com/defaul...kb;en-us;224071
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"John" <John@.discussions.microsoft.com> wrote in message
news:FD9BE33F-1AAA-4D58-8134-4A76223ABB2E@.microsoft.com...
> Hi,
> as I'm sure most of you know system databases (except msdb) cannot be
> detached and re-attached in SQL Server. Unfortunately I have inherited a
> SQL
> Server environment where the system databases are located on a small
> partition and this is causing the partition to run out of disk as it
> contains
> the tempdb database. Does anyone know of a way to move the physical files
> for system databases...or will I need to backup all of the databases,
> re-install SQL Server and restore the database backups?
> Cheers
> --
> John - DBA|||"John" <John@.discussions.microsoft.com> wrote in message
news:FD9BE33F-1AAA-4D58-8134-4A76223ABB2E@.microsoft.com...
> Hi,
> as I'm sure most of you know system databases (except msdb) cannot be
> detached and re-attached in SQL Server. Unfortunately I have inherited a
> SQL
> Server environment where the system databases are located on a small
> partition and this is causing the partition to run out of disk as it
> contains
> the tempdb database. Does anyone know of a way to move the physical files
> for system databases...or will I need to backup all of the databases,
> re-install SQL Server and restore the database backups?
Detach, move files, reattach.
Regards, Wojtek

Moving Log file

I took my production database offline first, moved LDF file to a new disk
partion, re-attached the database, and pointed to new location of the Log
file. (SQL 2000, using Enterprise manager console)
It seem to be OK, but could there be a problem doing it this way?
Thanks
MC
If by "Offline" you mean that you detached the db then it should be fine.
Andrew J. Kelly SQL MVP
"MC" <webmaster@.ozoptics.com> wrote in message
news:uaouUOvRGHA.5220@.TK2MSFTNGP10.phx.gbl...
>I took my production database offline first, moved LDF file to a new disk
> partion, re-attached the database, and pointed to new location of the Log
> file. (SQL 2000, using Enterprise manager console)
> It seem to be OK, but could there be a problem doing it this way?
> Thanks
> MC
>

Moving Log file

I took my production database offline first, moved LDF file to a new disk
partion, re-attached the database, and pointed to new location of the Log
file. (SQL 2000, using Enterprise manager console)
It seem to be OK, but could there be a problem doing it this way?
Thanks
MCIf by "Offline" you mean that you detached the db then it should be fine.
Andrew J. Kelly SQL MVP
"MC" <webmaster@.ozoptics.com> wrote in message
news:uaouUOvRGHA.5220@.TK2MSFTNGP10.phx.gbl...
>I took my production database offline first, moved LDF file to a new disk
> partion, re-attached the database, and pointed to new location of the Log
> file. (SQL 2000, using Enterprise manager console)
> It seem to be OK, but could there be a problem doing it this way?
> Thanks
> MC
>

Moving Log file

I took my production database offline first, moved LDF file to a new disk
partion, re-attached the database, and pointed to new location of the Log
file. (SQL 2000, using Enterprise manager console)
It seem to be OK, but could there be a problem doing it this way?
Thanks
MCIf by "Offline" you mean that you detached the db then it should be fine.
--
Andrew J. Kelly SQL MVP
"MC" <webmaster@.ozoptics.com> wrote in message
news:uaouUOvRGHA.5220@.TK2MSFTNGP10.phx.gbl...
>I took my production database offline first, moved LDF file to a new disk
> partion, re-attached the database, and pointed to new location of the Log
> file. (SQL 2000, using Enterprise manager console)
> It seem to be OK, but could there be a problem doing it this way?
> Thanks
> MC
>