Backup-Restore on Network Shared drive

Hi friends,

This is my post on Backup-Restore on Network Shared drive. After 2 days holidays coming back on job is difficult task and today I am not well due to cold. I did some wrong with myself eaten sweets more and after that cold water. SO my throat is not working properly.

Actually Every Enterprise is facing with Crunch of resources for running application and keeping backups. Sometime we require to restore database and we have no more space on local server drive. We all facing in our life as a SQL-DBA. If you have space on Shared drive then we can use it for our backup-restore task test activity. I am sharing you how to do on Network shared drive below tasks but be sure SQL have proper access on such drive or shares :-

1. How to do backup on Shared Location.
2. How to Restore from Shared Location to Local System
3. How to Restore from Shared Location to another shared location by new database.

    1.)   How to Backup Database on Network Shares?

       BACKUP DATABASE world TO  DISK = N'\\192.168.X.XX\ITDev\suman\bak\abc.bak' WITH NOFORMAT, NOINIT,  NAME = N'FileStreamDB-Full Database ackup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10


GO

2.)   How to Restore Database Backup from Network Shares to Local System?

RESTORE DATABASE [world] FROM  DISK = N'\\192.168.X.XX\ITDev\suman\bak\abc.bak' WITH  FILE = 1, 

MOVE N'world' TO N'C:\Program Files\Microsoft SQL Server\MSSQL11.MYSERVER\MSSQL\DATA\world1.mdf', 

MOVE N'world_log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL11.MYSERVER\MSSQL\DATA\world_log2.ldf',  NOUNLOAD,  STATS  

5

    3.)   How to Restore Database Backup from Network Shares to Share Location?

RESTORE DATABASE [world] FROM  DISK = N'\\192.168.X.XX\ITDev\suman\bak\abc.bak' WITH  FILE = 1, 

MOVE N'world' TO \\192.168.X.XX\ITDev\suman\bak\world1.mdf', 

MOVE N'world_log' TO \\192.168.X.XX\ITDev\suman\bak\world_log2.ldf',  NOUNLOAD,  STATS = 5

GO

6 percent processed.

11 percent processed.

15 percent processed.

22 percent processed.

26 percent processed.

30 percent processed.

35 percent processed.

41 percent processed.

46 percent processed.

50 percent processed.

55 percent processed.

61 percent processed.

66 percent processed.

70 percent processed.

75 percent processed.

81 percent processed.

86 percent processed.

90 percent processed.

97 percent processed.

100 percent processed.

Processed 360 pages for database 'world', file 'world' on file 1.

Processed 3 pages for database 'world', file 'world_log' on file 1.

RESTORE DATABASE successfully processed 363 pages in 0.342 seconds (8.280 MB/sec).

  

use world2

select * from City