Solved

ASpnetdb.mdf to sql server 2000

Posted on 2008-10-24
6
448 Views
Last Modified: 2013-11-08
I have created a local aspnetdb.mdf with the asp.net configuration utility in visual studio 2008.

How do I get that database information over to my remote sql server 2000 database?

thanks.
0
Comment
Question by:Starr Duskk
  • 4
  • 2
6 Comments
 
LVL 19

Assisted Solution

by:elimesika
elimesika earned 500 total points
ID: 22808751
0
 
LVL 2

Author Comment

by:Starr Duskk
ID: 22808941
I am not attaching to a desktop engine. I am trying copy the entire mdf to my sql server 2000.
 
0
 
LVL 19

Expert Comment

by:elimesika
ID: 22808972
I know, and still this article shows you how to copy the mdf & log file and attach them to your sql 2000 database.
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 2

Author Comment

by:Starr Duskk
ID: 22809024
okay, I'll check it out this week. thanks.
 
0
 
LVL 2

Author Comment

by:Starr Duskk
ID: 22862548
Okay, I had a chance to go through it. None of that makes sense to me.
Isn't there a way to use the sql server Import and Export utility to import the mdf files?
 
0
 
LVL 2

Accepted Solution

by:
Starr Duskk earned 0 total points
ID: 22876035
0

Featured Post

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question