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