January 7, 2013 at 8:32 am
Hi All,
i have a backup on the network drive. and i want to restore it on my local server.....but the problam is that on time of restoration i am not able to see network drive.....
So my Question is can i restore backup from network drive????
and how can we do that...???
January 7, 2013 at 8:39 am
You could copy the backup file to your local machine then perform a restore.
And if that's not possible then check to make sure the SQL Server service account has access to the network share where the backup file is.
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
January 7, 2013 at 8:41 am
thanks abu,
i know that we can move backup to local disk.but this thing i do not want to do.....
i want to know can we restore from network drive and how ???????
if u know the way please explain in detail.
January 7, 2013 at 8:43 am
Are you using the UNC path or where you mapping a drive?
January 7, 2013 at 8:43 am
Please check to make sure that the SQL Server service account has at least read permissions on the network share?
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
January 7, 2013 at 8:48 am
abu ..no they are not having that
January 7, 2013 at 8:49 am
anthony ....yes i m using UNC path
January 7, 2013 at 8:52 am
"i want to know can we restore from network drive and how ???????"
The answer is yes, check this out http://www.mssqltips.com/sqlservertip/1126/sql-server-backup-and-restore-to-network-drive/
You need to first see if you can access the shared drive from your local PC, and that there is no security problem
use: restore dbname from disk ='\\servername\$shareddrive\...path.bak
January 7, 2013 at 8:52 am
If using UNC path, then you need to ensure that the SQL service accounts have at-least read access to the network share to be able to access the file.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply