How to detach attach database in sql 7.0

  • Hi,

    I want to know the query to detach and attach database in sql server 7.0.

    i want to move original ldf file and want to provide new ldf file keeping original mdf as it is.....

    also i am shrinking original ldf file in sql 2005 but it is not working.....i am enable to find error in it......please guide

    Thanks,

  • Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic660187-146-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Hi Sameer,

    Please post your questions separetly and properly so that people can try to help you.

    Thanks, Atul

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply