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 Files

I have inherited a SQL Server environment that was haphazardly installed and managed. I am in the process of trying to apply some form of structure to this environment. Currently all data and log files reside in the default data directory. I am moving the
log files to a separate directory on a different drive. I know I can use sp_detach_db and sp_attach_db to move the log files, but how can I move the log files for master, msdb, model, and tempdb?
Any help would be greatly appreciated.
http://www.databasejournal.com/featu...le.php/3379901
|||Erik,
Thanks for the reply. This was exactly what I was looking for.
"erik perez" wrote:

> http://www.databasejournal.com/featu...le.php/3379901
>

Moving Log Files

I have inherited a SQL Server environment that was haphazardly installed and
managed. I am in the process of trying to apply some form of structure to t
his environment. Currently all data and log files reside in the default data
directory. I am moving the
log files to a separate directory on a different drive. I know I can use sp_
detach_db and sp_attach_db to move the log files, but how can I move the log
files for master, msdb, model, and tempdb?
Any help would be greatly appreciated.http://www.databasejournal.com/feat...cle.php/3379901|||Erik,
Thanks for the reply. This was exactly what I was looking for.
"erik perez" wrote:

> http://www.databasejournal.com/feat...cle.php/3379901
>