Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I not able to restore DB from maped Network Drive, Only from HDD initialized in Native OS,

my enviroment is MsSql2008 on Win2008R2 Standard (as virtual in VMware ESX4.1),

Win2008R2 Standard doesn't supports adding Networks drive(s) as HDD, RAM, Procesors on Runtime, these resources are accesible after enviroment restarted,

I could be able to import DB from another instance, but there are some another internal rulles that doesn't allows me that (middle and huge DB)

1) backup in OmniBack form or Full_Backup_File

2) no available space on HDD to copy dump on local enviroment for middle and huge DB

3) another crazy rulles about Network trafics from local end_user_PC, reduced DiskArea, for moving files betwees luns....

is there someone that solved this issue, or this issue is strictly rellated with resources from WinOS

EDIT:

Answer from Microsoft Q&A

SQL Server Management Studio -> Server Objects -> Backup Devices -> Add

share|improve this question
2  
You have a hardware problem: lack of HDD space etc. This would be the simplest solution –  gbn Oct 11 '11 at 8:33
    
is in conflicts with internal rulles max is 30pct FreeSpace on HDD, there not possible to hold huge reserve for available HDD space, meaning for middle and huge DB –  mKorbel Oct 11 '11 at 8:40
1  
The internal rule stops you doing your job. Fix the rule. –  gbn Oct 11 '11 at 8:43
    
hehehe :-) thanks, not possible in all cases go ahead against the wall, because always there exist another idiot that did that without thinking about that –  mKorbel Oct 11 '11 at 8:48
add comment

1 Answer

up vote 4 down vote accepted

We just had a similar problem and noted that we could use UNC-pathes to specify the source of a restore.

The restore is done by some account with rather restricted permissions and therefore it does not see the drive mappings you see.

To make it work in domain context, allowing read access to the backup file to the computer.

In other cases, when the machines aren't in the same domain giving read permission to the file to everyone might be the last resort.

Edit:

Good to know that there is a build in option to add backup devices. For DBAs it might be the preferred way, developers in restricted environments have sometimes to try other options depending on the rights they where given.

For the German version of SSMS. You find the tool mentioned by mKorbel at

SQL Server Management Studio -> Server Objects -> Sicherungsmedien -> Neues Sicherungsmedium...
share|improve this answer
    
that make me sence, in this moments only thanks and +1 –  mKorbel Oct 11 '11 at 12:07
    
since not completed, because some accesses from/to AD still something cried, but thank you –  mKorbel Oct 11 '11 at 12:39
    
there is built-in Option, please see my edit :-) –  mKorbel Oct 11 '11 at 14:14
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.