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