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 :-
- How to do backup on Shared Location.
- How to Restore from Shared Location to Local System
- 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
Comments
Post a Comment
Plz dont forget to like Facebook Page..
https://www.facebook.com/pages/Sql-DBAcoin/523110684456757