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.

Advertisements

About Buja Atdhe

CEO of the platform
Gallery | This entry was posted in SQL Server 2012, SQL Server 2014 and tagged , , , . Bookmark the permalink.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s