Solved

How to create new db and reimport data

Posted on 2013-10-29

1 solution

235 Views

Last Modified: 2013-11-06

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

Comment

Question by:kyleshire

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

2 Comments

LVL 23

Expert Comment

by:Rajkumar Gs

ID: 396108002013-10-29

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

LVL 9

Accepted Solution

by:guswebb

guswebb earned 500 total points

ID: 396130692013-10-30

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.

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to deploy a WordPress Site in Azure

Article by: Shaun

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install

Three Things to Consider When Thinking About Containers

Article by: Percona

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .

SQL - Inserting Data

Video by: Zia

Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.