Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

Solved

How to create new db and reimport data

Posted on 2013-10-29

1 solution

Medium Priority

241 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 1500 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

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

Introduction to SQL Server Containers

Article by: Paul

Windocks is an independent port of Docker's open source to Windows. This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.

Getting Server / Database / Connection Information via T-SQL (SQL Server)

Video by: Steve

Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

Microsoft SQL Server

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.