Home Forums SQL Server 2012 SQL 2012 - General Faster way to move all the data from one database to another ( without backups)? RE: Faster way to move all the data from one database to another ( without backups)?

  • February 7, 2014 at 1:04 pm

    #1687208

    ALTER DATABASE <database name>

    MODIFY FILE (Name = <file name>, OFFLINE);

    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