Create back up of SQL database to an external hard disk

Asked By molly bailey 0 points N/A Posted on - 11/30/2011

I am using SQL Express 2008 as my local server and I am receiving a message that it’s running low on disk space. However, I would like to create a database in a new drive or back-up my current database to an external hard disc. Is this possible? If yes, how can I make this possible?

• Status: Open
• Question Views: 1260
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MySQL Server

Best Answer by lee hung

Go To Solution

Best Answer

Best Answer

Answered By lee hung 75 points N/A #105523

Create back up of SQL database to an external hard disk

Hello Molly Bailey,

You can just choose those files that are on the partition that you have stored your SQL database files and then transfer them to an external hard drive so as to create more space for the database to function properly instead of trying to transfer the location for the SQL database files.

Although it is possible for you to store the SQL files to a different location like an external drive, it will take you a lot of process because you will need to reconfigure the SQL commands to point to the new storage location, and every time you want to use the database you will need to be having the external hard drive.

Hope this helps.

__

Regards
Lee Hung

 

About lee hung

Questions
3

Answers
1451

Best Answers
463

• Vote Up 0 Vote Down

• Posted on - 11/30/2011
• Question Category: MySQL Server

Answered By rahul84 0 points N/A #105524

Create back up of SQL database to an external hard disk

This is possible:
1. Backup database using  sql management studio. Or back up using sql query and then create database in another drive and restore back up .
2. Using sql management studio detached the database, copy database (*.mdf and *.ldf ) files to another drive and again attach the database from new location.

 

thanks.

About rahul84

Questions
0

Answers
8

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 12/01/2011
• Question Category: MySQL Server