Solved

How to create new db and reimport data

Posted on 2013-10-29

1 solution

233 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

Suggested Solutions

Title	# Comments	Views	Activity
Access PS SQLSERVER from powershell	1	30	2017-05-11
SQL Server Pivot	5	42	2017-05-18
How to Rank results in SQL Server based on the search criteria	3	12	2d
first parameter x of the decimal (x, y)	1	25	8h

5 Lessons the Delta Outage Should Teach Us About Datacenter Security and Disaster Prevention

Article by: Concerto Cloud

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…

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

Executing a SQL Script from a Unix Shell Script and Passing Parameters

Video by: Steve

This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

Dealing with Dates: Data Types and String Conversions (SQL Server)

Video by: Steve

Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.