467,917 Members | 1,302 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,917 developers. It's quick & easy.

Import database from local system to server system

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
  • viewed: 1693
Share:
2 Replies
ck9663
Expert 2GB
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
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.

Similar topics

15 posts views Thread by DesignGuy | last post: by
3 posts views Thread by Sam | last post: by
7 posts views Thread by Randy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.