I am trying to restore a big database in SQL Server 2008 R2. The database is about 700GB in size. My SQL Server is installed in C drive which has only 100GB of space left in it. I have the .bak file on the D drive from which I need to restore the database. Is there a way I can restore this database without increasing the space on C drive? (The D drive has 5TB of space and I would want SQL Server to access/place the data from/on D drive)
Any input will be highly appreciated.