Click here to Skip to main content
15,867,308 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I am using MS SQL Server 2016. Already restored the database using domain name. Now I want to restore database from network workgroup.

What I have tried:

<pre>USE MASTER
GO
ALTER DATABASE MyDB
SET SINGLE_USER WITH
ROLLBACK IMMEDIATE

RECONFIGURE
GO

-- To enable xp_cmdshell
EXEC sp_configure 'xp_cmdshell', 1
GO
-- Update currently configured values for advanced options.
RECONFIGURE
GO

EXEC xp_cmdshell 'NET USE Z: \\Server\path passoword /USER:DOMAIN-NAME\UserName'

RESTORE DATABASE MyDB
FILE = N'logicalName'
FROM DISK = N'Z:\backupfilename'
WITH REPLACE,
FILE = 1, NOUNLOAD, STATS = 10,
MOVE N'logicalName'
TO N'C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\MyDB.mdf',
MOVE N'logicalName_log'
TO N'C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\MyDB_log.ldf'

EXEC xp_cmdshell 'net use Z: /delete'
GO

ALTER DATABASE MyDB SET MULTI_USER
GO
Posted
Updated 16-Aug-18 19:46pm
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900