Locate the directory of your SQL Database needing to be moved. By default (which isn’t a good practice) the location of your databases are here: C:\Program Files\Microsoft SQL Server\MSSQL10_50 ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small ... To do that, create a backup in SSMS and select the Script > Script Action to job option.