Moving Tranaction Logs for existing DBs

Hi,
Just wondering if anyone knows if it's possible to change
locations of a tranaction log of an exisiting database? It
seems whenever I try to detach, move the log and attach it
always looks for the transaction log in the original
location and won't let me specify the new one.
Any help appreciated. Thanks.
-BrianBrian,
While attaching it , mention the new path for the .ldf file explicitly, as
in:
EXEC sp_attach_db @.dbname = N'pubs',
@.filename1 = N'c:\Program Files\Microsoft SQL
Server\MSSQL\Data\pubs.mdf',
@.filename2 = N'c:\Program Files\Microsoft SQL
Server\MSSQL\Data\pubs_log.ldf'
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Brian R." <reaburn.brian@.colteng.com> wrote in message
news:05b201c36017$ab486ab0$a001280a@.phx.gbl...
> Hi,
> Just wondering if anyone knows if it's possible to change
> locations of a tranaction log of an exisiting database? It
> seems whenever I try to detach, move the log and attach it
> always looks for the transaction log in the original
> location and won't let me specify the new one.
> Any help appreciated. Thanks.
> -Brian

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