Posts

Showing posts from November, 2018

Restore Database backup from network

First you need to share that network folder with you user name, Then Remote to the server on which you want to restore database, Go to My computer and map network drive after mapping execute the below script by changing path, username and password according to your server  EXEC sp_configure 'show advanced options', 1 GO -- To update the currently configured value for advanced options. RECONFIGURE GO -- To enable the feature. EXEC sp_configure 'xp_cmdshell', 1 GO -- To update the currently configured value for this feature. RECONFIGURE GO EXEC xp_cmdshell 'NET USE Z: \\SystemName\FolderName PasswordofUser /USER:YourUserName@domain.com' if some drive is already mapped for the same user then you have to delete first one by below script. EXEC xp_cmdshell 'net use Y: /delete'