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
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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now