example 1. open a query window in mssql studio 2. enable xp_cmdshell: EXEC sp_configure 'show advanced options', 1 GO RECONFIGURE GO EXEC sp_configure ‘xp_cmdshell’, 1 GO RECONFIGURE GO 3. register a networkshare in MSSQL Studio EXEC XP_CMDSHELL 'net use Z: \\192.168.80.166\SHARENAME MYPASS /user:foo' 4. do the commune mssql database restore, you will find now a D drive to select under Device

http://blog.sqlauthority.com/2007/04/26/sql-server-enable-xp_cmdshell-using-sp_configure/

EXEC XP_CMDSHELL 'net use M: \\192.168.80.101\sql_backup password# /USER:foo /PERSISTENT:yes' 04.09.15 to automatically map a windows network in the mssql server with a store procedure USE [master] GO /****** Object: StoredProcedure [dbo].[map_drive_satrtup] Script Date: 6/16/2016 8:39:39 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[map_drive_satrtup] AS EXEC sp_configure 'show advanced options', 1 EXEC sp_configure 'xp_cmdshell', 1 EXEC XP_CMDSHELL 'net use M: \\192.168.80.101\sql_backup pass# /USER:foo /PERSISTENT:no' EXEC sp_procoption N'map_drive_satrtup', 'startup', 'on' 04.09.15 Use Master GO EXEC master.dbo.sp_configure 'show advanced options', 1 RECONFIGURE WITH OVERRIDE GO EXEC master.dbo.sp_configure 'xp_cmdshell', 1 RECONFIGURE WITH OVERRIDE GO 04.09.15

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024