SQL 2005 MDF Attach Question

Discussion in 'Databases' started by Bruce, Jun 23, 2006.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Bruce

    Bruce DiscountASP.NET Staff

    When you attach a database, what actually happens is

    1) The .mdf file is copied to our SQL 2005 server

    2) We detach your existing database

    3) We attach the .mdf file to your existing database.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Jun 23, 2006
    #1
  2. wibble

    wibble

    I'm a little confused as to what is involved.

    If I 'attach' my MDF fileis it in factimported into the main SQL Server or am Istill faced with the SQL Server 2005 Express limitations such as database size, memory and cpu usage?

    Is there any documentation as to what actually happens in the attach procedure?

    Thanks
     
    wibble, Jun 23, 2006
    #2
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page