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]
( FILENAME = N’\\storageip\foldername\TEST1.mdf’ ),
( FILENAME = N’\\storageip\foldername\TEST1_log.ldf’ )

And Execute it.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a website or blog at

Up ↑

%d bloggers like this: