Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 257
  • Last Modified:

How to create new db and reimport data

Hi, I have a database that keeps dropping from the SQL.  I would like to export all my data from this database, create a new db, reimport all the data back.

How do I accomplish this.

Thanks
0
kyleshire
Asked:
kyleshire
Advertise Here
1 Solution
 
Rajkumar GsSoftware EngineerCommented:
Hi Kyleshire

To export data, you may follow these steps
http://www.mssqltips.com/sqlservertutorial/203/simple-way-to-import-data-into-sql-server/

Raj
0
 
guswebbCommented:
I'd look more closely at the reason for the DB dropping as it sounds like you might create a replacement DB and hit the same issue. Disk space being exhausted by large log files would certainly cause this.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Go Premium
Advertise Here
Tackle projects and never again get stuck behind a technical roadblock.
Join Now