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 SQL Server to a new domain

All,
I have the task of separating our AD into 2 domains due to selling one of
our companies off. Unfortunately, one of the SQL 2000 servers belongs to this
company and that needs to be moved to the new domain.
The machine in question is a windows 2003 server running SQL server 2000
sp3a. There are 3 databases on the machine, and there are domain accounts
that have permission to 2 of them.
The project will include creating the new domain and creating a trust
between them so that I can migrate user accounts with SID history, for
Exchange reasons.
How would I be able to move the server to the new domain? Do I just use the
Active Directory Migration Tool to move the server to the domain after the
user accounts have been moved, then assign the new domain user accounts to
the databases?
Any help would be appreciated
Thanks
Andoni
"Andoni" <Andoni@.discussions.microsoft.com> wrote in message
news:D3F1B0F8-53BA-43DB-8EB3-6A1E5C40AE33@.microsoft.com...

> How would I be able to move the server to the new domain? Do I just use
> the
> Active Directory Migration Tool to move the server to the domain after the
> user accounts have been moved, then assign the new domain user accounts to
> the databases?
After you migrate everything with ADMT, bounce the server into the new
domain, reset the service account and I do not believe you need to do
anything with login's based on domain accounts because they are sid based.
|||Hi Jason,
I have migrated the server, the user accounts were migrated beforehand. By
reset service account do you mean if SQL runs under a domain account? Also,
In the enterprise manager under security/logins, it's still showing domain
users in the old domain instead of the new one. will i need to create new
domain users?
thanks
A
"jason" wrote:

> "Andoni" <Andoni@.discussions.microsoft.com> wrote in message
> news:D3F1B0F8-53BA-43DB-8EB3-6A1E5C40AE33@.microsoft.com...
>
> After you migrate everything with ADMT, bounce the server into the new
> domain, reset the service account and I do not believe you need to do
> anything with login's based on domain accounts because they are sid based.
>
sql

Moving SQL Server to a new domain

All,
I have the task of separating our AD into 2 domains due to selling one of
our companies off. Unfortunately, one of the SQL 2000 servers belongs to this
company and that needs to be moved to the new domain.
The machine in question is a windows 2003 server running SQL server 2000
sp3a. There are 3 databases on the machine, and there are domain accounts
that have permission to 2 of them.
The project will include creating the new domain and creating a trust
between them so that I can migrate user accounts with SID history, for
Exchange reasons.
How would I be able to move the server to the new domain? Do I just use the
Active Directory Migration Tool to move the server to the domain after the
user accounts have been moved, then assign the new domain user accounts to
the databases?
Any help would be appreciated
Thanks
Andoni"Andoni" <Andoni@.discussions.microsoft.com> wrote in message
news:D3F1B0F8-53BA-43DB-8EB3-6A1E5C40AE33@.microsoft.com...
> How would I be able to move the server to the new domain? Do I just use
> the
> Active Directory Migration Tool to move the server to the domain after the
> user accounts have been moved, then assign the new domain user accounts to
> the databases?
After you migrate everything with ADMT, bounce the server into the new
domain, reset the service account and I do not believe you need to do
anything with login's based on domain accounts because they are sid based.|||Hi Jason,
I have migrated the server, the user accounts were migrated beforehand. By
reset service account do you mean if SQL runs under a domain account? Also,
In the enterprise manager under security/logins, it's still showing domain
users in the old domain instead of the new one. will i need to create new
domain users?
thanks
A
"jason" wrote:
> "Andoni" <Andoni@.discussions.microsoft.com> wrote in message
> news:D3F1B0F8-53BA-43DB-8EB3-6A1E5C40AE33@.microsoft.com...
> >
> > How would I be able to move the server to the new domain? Do I just use
> > the
> > Active Directory Migration Tool to move the server to the domain after the
> > user accounts have been moved, then assign the new domain user accounts to
> > the databases?
> After you migrate everything with ADMT, bounce the server into the new
> domain, reset the service account and I do not believe you need to do
> anything with login's based on domain accounts because they are sid based.
>