Post reply

moving database to another machine

  • July 11, 2008 at 3:19 am

    #841318

    You have to attach following way

    USE [master]

    GO

    CREATE DATABASE [abc] ON

    ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\abc.mdf')

    FOR ATTACH_REBUILD_LOG

    🙂

Viewing post 16 (of 15 total)

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