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
kyleshireAsked:
Who is Participating?
 
guswebbConnect With a Mentor Commented:
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
 
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
All Courses

From novice to tech pro — start learning today.