restore existing sql 2005 db's
Re-invent ASP.NET Hosting Community
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



restore existing sql 2005 db's Expand / Collapse
Author
Message
Posted 9/6/2006 1:21:00 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 9/21/2006 5:29:00 PM
Posts: 3, Visits: 1
Hi,

I have 2 databases:
ASPNETDB.MDF => my asp2.0 membership db
TTCWebsiteDB.mdf => my website data and content db

These 2 db's are populated.
How can I attach them to my domain space?
And what will be their connectionstring?

Thanks in advance
Post #353
Posted 9/7/2006 3:58:00 PM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Administrators
Last Login: 1/1/2009 9:27:17 AM
Posts: 106, Visits: 276

You can attach 1 database but not both.   You would first attach the database where all your data resides which is probably TTCWebSiteDB.mdf.

After that is attached you would follow the instructions in this Knowledge Base Article:
http://support.re-invent.com/article.aspx?id=10353 

(How to set up the new ASP.NET 2.0 Membership, Role Management, and Personalization services to use a regular hosted SQL Server 2005 or SQL 2000 instead of Microsoft SQL Server Express)

After this is configured you would update your connection string to point to the hosted SQL 2005 database rather than the Express Database.

 



Plato
Re-invent Technologies LLC
Re-invent Support Team
http://www.re-invent.com

Specializing in ASP.NET Hosting

Post #354
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Administrator, Re-invent (Paul), Re-invent (Nick)

Permissions Expand / Collapse

All times are GMT -5:00, Time now is 11:05pm

Powered By InstantForum.NET v4.1.4 © 2009
Execution: 0.047. 13 queries. Compression Disabled.


Copyright 2007 Re-invent Technologies LLC All Rights Reserved.