Re: Moving Transaction logs

From: Dinesh T.K (tkdinesh_at_nospam.mail.tkdinesh.com)
Date: 04/06/04


Date: Wed, 7 Apr 2004 02:38:43 +0530

Dedrick,

No, you cant.Refer the workaround mentioned in:

INF: Moving SQL Server databases to a new location with Detach/Attach
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q224071

--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Dedrick Winston" <anonymous@discussions.microsoft.com> wrote in message
news:A7C89F33-D9FE-43F8-8A6A-699B2B6C514F@microsoft.com...
> Hi everyone,
>
> My question today revolves around the placement of transaction logs. I
have used attach and detach procedures to move all of the user db
transaction logs to another drive. I would like to do this for all databases
but you cant seem to detach the system dbs...or can you?
>
> Anyone know?
>
> Dedrick


Relevant Pages

  • Re: Upgrade MSDE to SQL2000
    ... Easy method is to backup and restore or detach and attach the databases. ... http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases ... the versions of SQL server which can ...
    (microsoft.public.sqlserver.setup)
  • Re: How to upgrade MSDE databases to SQL Server Databases
    ... First however we are going to permute the install sequence on a 'web ... farm' parameter and then permute a server target on the WSS Web Admin ... between Microsoft Access, MSDE, SQL Server Express and SQL Server databases. ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Backup issues after changing administrator name
    ... I set the relevant sql server databases to simple and ... You back up data from a volume that contains a Microsoft SQL Server ... > As creating the volume shadow copy failed, the open files shown in the log ... > CSS (Customer Support Service) for the following hot fix. ...
    (microsoft.public.windows.server.sbs)
  • Re: transfer db from home to work.
    ... SQL Server MVP ... I would use detach / attach for this. ... > I want to transfer the database from home to work using a flash ...
    (microsoft.public.sqlserver.server)
  • Potential issue with DTS and Log Shipping
    ... My set up involves three SQL Server Databases. ... copy of first via log shipping. ... have a DTS packagage that that copys select ...
    (microsoft.public.sqlserver.dts)

Loading