moving sql srvr logs

what is the quickest and safest way to move sql srvr logs
to a different partition in the server.
is there a way to do it using enterprise manager?
thanx team!!Yep. Read KB 224071 for more info.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"dalatingod" <dalatingod@.hotmail.com> wrote in message
news:12ac501c3f6c6$2248a6d0$a001280a@.phx
.gbl...
> I think i found the solution
> detaching the database, then phisically moving the logs
> to a different partition
> and after that re attaching the database
> please confirm that this is correct
> Thanx
>
> logs|||Cheers Tibor
the KB describes it in a lot of detail
many many Thanks!!

>--Original Message--
>Yep. Read KB 224071 for more info.
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"dalatingod" <dalatingod@.hotmail.com> wrote in message
> news:12ac501c3f6c6$2248a6d0$a001280a@.phx
.gbl...
>
>.
>

moving sql srvr logs

what is the quickest and safest way to move sql srvr logs
to a different partition in the server.
is there a way to do it using enterprise manager?
thanx team!!I think i found the solution
detaching the database, then phisically moving the logs
to a different partition
and after that re attaching the database
please confirm that this is correct
Thanx
>--Original Message--
>what is the quickest and safest way to move sql srvr
logs
>to a different partition in the server.
>is there a way to do it using enterprise manager?
>thanx team!!
>.
>|||Yep. Read KB 224071 for more info.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"dalatingod" <dalatingod@.hotmail.com> wrote in message
news:12ac501c3f6c6$2248a6d0$a001280a@.phx.gbl...
> I think i found the solution
> detaching the database, then phisically moving the logs
> to a different partition
> and after that re attaching the database
> please confirm that this is correct
> Thanx
>
> >--Original Message--
> >what is the quickest and safest way to move sql srvr
> logs
> >to a different partition in the server.
> >is there a way to do it using enterprise manager?
> >
> >thanx team!!
> >.
> >|||hi,
1. sp_helpdb pubs , will show u the existing file path
of .mdf and .ldf files.
output:
C:\database\Pubs.mdf
C:\database\Pubs_log.ldf
2. sp_detach_db 'pubs','false'
will detach the database and run UPDATE STATISTICS on all
the tables before detaching.
once detached ,copy the .ldf file to the desired location.
Assuming that u r moving pubs_log.ldf to D drive, execute
point 3.
3. EXEC sp_attach_db @.dbname = 'pubs',
@.filename1 = 'C:\Database\pubs.mdf',
@.filename2 = 'D:\Database\pubs_log.ldf'
4. You can execute Point 1 to see the new path. You may
also delete the .ldf file from the old location.
HTH
Regards
Thirumal
>--Original Message--
>I think i found the solution
>detaching the database, then phisically moving the logs
>to a different partition
>and after that re attaching the database
>please confirm that this is correct
>Thanx
>
>>--Original Message--
>>what is the quickest and safest way to move sql srvr
>logs
>>to a different partition in the server.
>>is there a way to do it using enterprise manager?
>>thanx team!!
>>.
>.
>|||Cheers Tibor
the KB describes it in a lot of detail
many many Thanks!!
>--Original Message--
>Yep. Read KB 224071 for more info.
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"dalatingod" <dalatingod@.hotmail.com> wrote in message
>news:12ac501c3f6c6$2248a6d0$a001280a@.phx.gbl...
>> I think i found the solution
>> detaching the database, then phisically moving the logs
>> to a different partition
>> and after that re attaching the database
>> please confirm that this is correct
>> Thanx
>>
>> >--Original Message--
>> >what is the quickest and safest way to move sql srvr
>> logs
>> >to a different partition in the server.
>> >is there a way to do it using enterprise manager?
>> >
>> >thanx team!!
>> >.
>> >
>
>.
>

Moving SQL 6.5 from NT 4.0 to W2K3. Please help

Hello,
As part of Active Directory migration (from NT 4.0 to Server 2003
Enterprise), we will be replacing our current SQL server hardware with a
newer server which will be running windows 2003. Can anyone point me to any
document on how to go about doing this please. I am very new to SQL
migration, what are the things that I should be watching? The customer does
not want to upgrade to SQL2000 (prefers to stay with 6.5). Any issues with
doing that?
ThanksHi
SQL 6.5 is not supported on Windows 2003, and neither is SQL Server 7.0
SQL 6.5 is no longer supported since 31-Jan-2002 and SQL 7.0 dies
31-Dec-2005.
SQL 2000 is his only option.
http://support.microsoft.com/gp/lifesrvr
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"warsai" <warsai@.discussions.microsoft.com> wrote in message
news:842BB3B4-47AF-499C-B0BC-A91683255F7E@.microsoft.com...
> Hello,
> As part of Active Directory migration (from NT 4.0 to Server 2003
> Enterprise), we will be replacing our current SQL server hardware with a
> newer server which will be running windows 2003. Can anyone point me to
any
> document on how to go about doing this please. I am very new to SQL
> migration, what are the things that I should be watching? The customer
does
> not want to upgrade to SQL2000 (prefers to stay with 6.5). Any issues with
> doing that?
> Thanks
>