By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,575 Members | 1,948 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,575 IT Pros & Developers. It's quick & easy.

Import database from local system to server system

P: 53
Hi,

I have a problem with database.For my application i am using .net and sql server 2000. i am having database for my application in my local system.if i shutdown the system database is not working.i tried to import database from local system to server system.but it is not woking properly.is there any solution to import database.Please help me.

Thanks
pavani
Oct 20 '08 #1
Share this Question
Share on Google+
2 Replies


ck9663
Expert 2.5K+
P: 2,878
Your post is too generic.

But yes, there's a way. You have to install SQL Server on that server machine, backup your local database and restore it on the server machine.

You might also need to change your connection string to point your app to your server machine.

-- CK
Oct 21 '08 #2

P: 53
ok.thank you.I got the solution to my problem by using the following steps.

Sql Enterprise Manager,Right Click On Database SELECT Properties->Datafiles(Tab)->See th location of ur database and go to that location and find .ldf and .mdf files there now stop sql server running on ur machine and copy those files(.ldf,.mdf) now start ur Sql Server now go to ur actual server(Destination) system ,now create a folder any where on that Suppose on D:\\Database now paste these(.ldf,.mdf)files there and open Sql Enterprise Manager on that system and select Databases folder right clck on that All Tasks->Attach Database->click brose button(...)->select the mdf file(D:\\Database\\xxx.mdf) and say ok.
Oct 21 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.