Move SQL Server Database to Different Location

Move SQL Server Database to Different Location :

There are several way to do this but I find this option being simple.Sometimes we face the issue with Drive being full. It happens when we have Database on C Drive and we usually don’t allocate much space on C Drive.Its absolutely bad practice to put any database files on C. By default Microsoft installs on System Drive and we need to be cognizant of this fact while installing and configuring new SQL Server.

Even in Lab, this needs to be taken into account.

Leave a Reply

Your email address will not be published. Required fields are marked *

*