Can App_Data directory be emptied?

Discussion in 'Databases' started by theyknewlif, Sep 10, 2007.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Can the App_Data directory be emptied since I am using your Sql Server 2005 server and my connection strings are pointing there instead?
     
  2. If App_Data contain's only the database files,you can empty App_Data after you have attached the database files to the MS SQL 2005 database.

    Vikram

    DiscountASP.NET
    www.DiscountASP.NET
     
  3. Great news! Thanks. I originally had my FullText catalog in there too, can I also remove that?
     
  4. You will not be able to use the same fulltext catalog on the remote server nor you will be able to attach the mdf which has this catalog associated with it.So ,first you will have to disable the fulltext catalog on the database locally followed by attaching the database to the remote sql server and then recreating the fulltext catalog on that.After that ,you can delete both the mdf anf fulltext catalog from your App_Data folder.

    Vikram

    DiscountASP.NET
    www.DiscountASP.NET
     
  5. Hello,
    Thank you for the help. In summary, I attached my SQL Server 2005 Express MDF via the SQL Tool Suite, then edited and uploaded my web.config ConnectionString's to point to the sql2k510.discountasp.net server.
    I used SQL Server Management Studio to DROP the old fulltext catalog from the hosted database and created a new fulltext catalog while connected to my database at sql2k510.discountasp.net. I created all the fulltext indexes I required on the hosted database.
    I then completely deleted the contents of my App_Data directory, which was no longer used by the hosted application.
     
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