How to set up the SQL Server to read a database from external hard disk or a different hard disk from my PC Is it possible for SQL Server to access a database from a different location? My Primary Hard Disk (C:) is almost full, however I have a second Hard Disk in my computer. 

When I try to restore the database, SQL Server says 


  There is insufficient free space on Disk C:// to create Database


Is there any way to move from C:\ to D:\?
You will want to use the MOVE option in the restore command to tell the restore process where to put each of the files in the backup set. This is done for each logical file name specifying the new physical location. 

See the details in this technet article 

It also shows how to get the logical file names from the backup set.