Create back up of SQL database to an external hard disk

Asked By 0 points N/A Posted on -
qa-featured

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?

SHARE
Best Answer by lee hung
Best Answer
Best Answer
Answered By 10 points N/A #105523

Create back up of SQL database to an external hard disk

qa-featured

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

 

Answered By 0 points N/A #105524

Create back up of SQL database to an external hard disk

qa-featured

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.

Login/Register to Answer

Related Questions