SQL Server 2005 Attach size restrictions

Discussion in 'Databases' started by bpaksicom00, Jun 15, 2006.

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

    bpaksicom00

    When attaching a MDF file to a SQL Service instance, is the data file (MDF) physically moved to the server SQL Server is running on?

    If not, then is this a way to increase your database quota size without paying extra for the SQL Server hosting disc space? I.E. Hosting plan paid for 100MB however a 500MB MDF stored on web server is attached to SQL Server.

    What is discountASP.net's policy in this regard? Are there any other issues to be concerned about when doing this type of database deployment (performance, security...)?
     
    bpaksicom00, Jun 15, 2006
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    Yes. The MDF is moved to the SQL server and attach.

    When you try to attach an MDF with bigger size than what you subscribed, the attach process will fail and the original DB will roll back.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Jun 15, 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