Use&restore DB from different physical source

The most important for DBA is to have and save a disk space on server for this reason i use a different physical source from the SQL Server instance.

• In one server we have installed and configured SQL Server 2012 or 2014 instance only that
• In another for example storage we have all mdf, ldf, bak file

Is achieved from another physical location to use these file from SQL Server instance.

I will shows the steps which has been taken to realize with success this very useful technical:

1. You should start the SQL service with domain account in the same with the storage
2. Open SSMS & connect to your local instance
3. Move your mdf and ldf file in different physical location
4. From your local SQL Server instance please go to Attach process but from T-SQL write the command

USE [master]
GO
CREATE DATABASE [TEST1] ON
( FILENAME = N’\\storageip\foldername\TEST1.mdf’ ),
( FILENAME = N’\\storageip\foldername\TEST1_log.ldf’ )
FOR ATTACH
GO

And Execute it.