T-SQL Syntax Error in SQL Server 2016

Vijay Kumar 2,016 Reputation points
2023-05-08T06:09:36.0233333+00:00

Hi Team,

I am getting below syntax error. Please help me.

Msg 102, Level 15, State 1, Line 17

Incorrect syntax near ','.

DECLARE @backup_files varchar(8000)
exec DBADB.dbo.pr_BUILD_RESTORE_STRING_SINGLE_FOLDER '\1.2.3.4.5\ciFF_KBDsql_dev_qa_bkup_vol01\DCLSXYZPT1D$XYZPT1D\ABCD_DM_SOURCE\FULL\', 'ABCD_DM', @backup_files OUTPUT
DECLARE @SQL VARCHAR(8000)
SET @SQL = @backup_files + CHAR(10) +
'WITH 
,  MOVE ''ABCD_DM'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM.mdf''
,  MOVE ''ABCD_DM_FG_IX'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_IX.ndf''
,  MOVE ''ABCD_DM_FG_PK_DEF'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK_DEF.ndf''
,  MOVE ''ABCD_DM_FG_PK1_NJMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK1_NJMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK10_NMMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK10_NMMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK101_WVMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK101_WVMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK102_CAMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK102_CAMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK103_SCMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK103_SCMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK104_INMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK104_INMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK11_NYMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK11_NYMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK12_MDMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK12_MDMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK13_TNMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK13_TNMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK14_SCMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK14_SCMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK15_VAMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK15_VAMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK16_FLMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK16_FLMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK17_TNMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK17_TNMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK18_NYMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK18_NYMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK19_NJMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK19_NJMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK2_ILMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK2_ILMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK20_VAMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK20_VAMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK21_NVMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK21_NVMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK22_OHMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK22_OHMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK23_TXCOP'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK23_TXCOP.ndf''
,  MOVE ''ABCD_DM_FG_PK24_GAMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK24_GAMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK25_FLMDR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK25_FLMDR.ndf''
,  MOVE ''ABCD_DM_FG_PK26_NJMDR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK26_NJMDR.ndf''
,  MOVE ''ABCD_DM_FG_PK27_TXMDR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK27_TXMDR.ndf''
,  MOVE ''ABCD_DM_FG_PK28_LAMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK28_LAMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK29_WAMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK29_WAMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK3_FLMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK3_FLMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK30_KSMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK30_KSMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK31_VAMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK31_VAMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK32_VAMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK32_VAMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK33_WAMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK33_WAMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK34_KYMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK34_KYMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK35_SCMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK35_SCMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK36_CAMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK36_CAMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK37_VAMDD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK37_VAMDD.ndf''
,  MOVE ''ABCD_DM_FG_PK38_WIMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK38_WIMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK39_CAMDD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK39_CAMDD.ndf''
,  MOVE ''ABCD_DM_FG_PK4_TXMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK4_TXMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK40_NYMDD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK40_NYMDD.ndf''
,  MOVE ''ABCD_DM_FG_PK41_NYMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK41_NYMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK42_CTMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK42_CTMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK43_NHMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK43_NHMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK44_MEMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK44_MEMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK45_MOMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK45_MOMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK46_OHMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK46_OHMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK47_INMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK47_INMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK48_KYMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK48_KYMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK49_GAMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK49_GAMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK5_MDMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK5_MDMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK50_WIMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK50_WIMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK51_CAMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK51_CAMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK52_TXMDD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK52_TXMDD.ndf''
,  MOVE ''ABCD_DM_FG_PK53_COMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK53_COMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK54_IAMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK54_IAMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK55_GA'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK55_GA.ndf''
,  MOVE ''ABCD_DM_FG_PK56_NY'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK56_NY.ndf''
,  MOVE ''ABCD_DM_FG_PK57_TX'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK57_TX.ndf''
,  MOVE ''ABCD_DM_FG_PK58_OH'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK58_OH.ndf''
,  MOVE ''ABCD_DM_FG_PK59_VA'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK59_VA.ndf''
,  MOVE ''ABCD_DM_FG_PK6_DCMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK6_DCMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK60_CA'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK60_CA.ndf''
,  MOVE ''ABCD_DM_FG_PK7_GAMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK7_GAMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK8_TXMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK8_TXMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK9_NMMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK9_NMCMR.ndf''
,  MOVE ''ABCD_DM_FG_PK61_TEST'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK61_TEST.ndf''
,  MOVE ''ABCD_DM_FG_ALL_MEDSUP'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_ALL_MEDSUP.ndf''
,  MOVE ''ABCD_DM_FG_ALL_UNICARE'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_ALL_UNICARE.ndf''
,  MOVE ''ABCD_DM_FG_PK88_TXSETON'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK88_TXSETON.ndf''
,  MOVE ''ABCD_DM_FG_PK89_WNY'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK89_WNY.ndf''
,  MOVE ''ABCD_DM_FG_ALL_GRS'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_ALL_GRS.ndf''
,  MOVE ''ABCD_DM_FG_PK103_MNMMP'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK103_MNMMP.ndf''
,  MOVE ''ABCD_DM_FG_PK104_MNMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK104_MNMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK168_NCMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK168_NCMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK100101_WVMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK100101_WVMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK100102_CAMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK100102_CAMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK100103_SCMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK100103_SCMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK100104_INMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK100104_INMCD.ndf''
,  MOVE ''ABCD_DM_log'' TO ''L:\LOG\XYZPT1D\ABCD_DM_NEW\ABCD_DM_log.ldf''
,  REPLACE
,  RESTRICTED_USER
,  RECOVERY'
exec (@SQL)
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,607 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Chandu_0124 11 Reputation points
    2023-05-30T05:05:07.3666667+00:00

    @vijay kumar

    I don't see syntax issue with in the script, you might missing '' in the end of line 17. Check this below:

    User's image

    DECLARE @backup_files varchar(8000)
exec DBADB.dbo.pr_BUILD_RESTORE_STRING_SINGLE_FOLDER '\1.2.3.4.5\ciFF_KBDsql_dev_qa_bkup_vol01\DCLSXYZPT1D$XYZPT1D\ABCD_DM_SOURCE\FULL', 'ABCD_DM', @backup_files OUTPUT
DECLARE @SQL VARCHAR(8000)
SET @SQL = @backup_files + CHAR(10) +
'WITH 
,  MOVE ''ABCD_DM'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM.mdf''
,  MOVE ''ABCD_DM_FG_IX'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_IX.ndf''
,  MOVE ''ABCD_DM_FG_PK_DEF'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK_DEF.ndf''
,  MOVE ''ABCD_DM_FG_PK1_NJMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK1_NJMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK10_NMMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK10_NMMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK101_WVMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK101_WVMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK102_CAMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK102_CAMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK103_SCMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK103_SCMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK104_INMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK104_INMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK11_NYMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK11_NYMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK12_MDMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK12_MDMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK13_TNMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK13_TNMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK14_SCMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK14_SCMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK15_VAMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK15_VAMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK16_FLMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK16_FLMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK17_TNMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK17_TNMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK18_NYMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK18_NYMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK19_NJMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK19_NJMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK2_ILMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK2_ILMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK20_VAMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK20_VAMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK21_NVMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK21_NVMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK22_OHMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK22_OHMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK23_TXCOP'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK23_TXCOP.ndf''
,  MOVE ''ABCD_DM_FG_PK24_GAMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK24_GAMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK25_FLMDR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK25_FLMDR.ndf''
,  MOVE ''ABCD_DM_FG_PK26_NJMDR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK26_NJMDR.ndf''
,  MOVE ''ABCD_DM_FG_PK27_TXMDR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK27_TXMDR.ndf''
,  MOVE ''ABCD_DM_FG_PK28_LAMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK28_LAMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK29_WAMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK29_WAMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK3_FLMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK3_FLMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK30_KSMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK30_KSMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK31_VAMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK31_VAMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK32_VAMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK32_VAMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK33_WAMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK33_WAMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK34_KYMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK34_KYMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK35_SCMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK35_SCMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK36_CAMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK36_CAMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK37_VAMDD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK37_VAMDD.ndf''
,  MOVE ''ABCD_DM_FG_PK38_WIMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK38_WIMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK39_CAMDD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK39_CAMDD.ndf''
,  MOVE ''ABCD_DM_FG_PK4_TXMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK4_TXMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK40_NYMDD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK40_NYMDD.ndf''
,  MOVE ''ABCD_DM_FG_PK41_NYMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK41_NYMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK42_CTMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK42_CTMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK43_NHMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK43_NHMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK44_MEMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK44_MEMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK45_MOMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK45_MOMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK46_OHMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK46_OHMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK47_INMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK47_INMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK48_KYMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK48_KYMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK49_GAMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK49_GAMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK5_MDMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK5_MDMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK50_WIMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK50_WIMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK51_CAMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK51_CAMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK52_TXMDD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK52_TXMDD.ndf''
,  MOVE ''ABCD_DM_FG_PK53_COMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK53_COMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK54_IAMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK54_IAMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK55_GA'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK55_GA.ndf''
,  MOVE ''ABCD_DM_FG_PK56_NY'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK56_NY.ndf''
,  MOVE ''ABCD_DM_FG_PK57_TX'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK57_TX.ndf''
,  MOVE ''ABCD_DM_FG_PK58_OH'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK58_OH.ndf''
,  MOVE ''ABCD_DM_FG_PK59_VA'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK59_VA.ndf''
,  MOVE ''ABCD_DM_FG_PK6_DCMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK6_DCMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK60_CA'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK60_CA.ndf''
,  MOVE ''ABCD_DM_FG_PK7_GAMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK7_GAMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK8_TXMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK8_TXMCR.ndf''
,  MOVE ''ABCD_DM_FG_PK9_NMMCR'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK9_NMCMR.ndf''
,  MOVE ''ABCD_DM_FG_PK61_TEST'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK61_TEST.ndf''
,  MOVE ''ABCD_DM_FG_ALL_MEDSUP'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_ALL_MEDSUP.ndf''
,  MOVE ''ABCD_DM_FG_ALL_UNICARE'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_ALL_UNICARE.ndf''
,  MOVE ''ABCD_DM_FG_PK88_TXSETON'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK88_TXSETON.ndf''
,  MOVE ''ABCD_DM_FG_PK89_WNY'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK89_WNY.ndf''
,  MOVE ''ABCD_DM_FG_ALL_GRS'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_ALL_GRS.ndf''
,  MOVE ''ABCD_DM_FG_PK103_MNMMP'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK103_MNMMP.ndf''
,  MOVE ''ABCD_DM_FG_PK104_MNMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK104_MNMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK168_NCMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK168_NCMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK100101_WVMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK100101_WVMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK100102_CAMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK100102_CAMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK100103_SCMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK100103_SCMCD.ndf''
,  MOVE ''ABCD_DM_FG_PK100104_INMCD'' TO ''L:\DATA\XYZPT1D\ABCD_DM_NEW\ABCD_DM_FG_PK100104_INMCD.ndf''
,  MOVE ''ABCD_DM_log'' TO ''L:\LOG\XYZPT1D\ABCD_DM_NEW\ABCD_DM_log.ldf''
,  REPLACE
,  RESTRICTED_USER
,  RECOVERY'
exec (@SQL)
    0 comments
  2. Olaf Helper 40,576 Reputation points
    2023-05-30T06:02:04.23+00:00

    exec DBADB.dbo.pr_BUILD_RESTORE_STRING_SINGLE_FOLDER

    What for a horrible database archticture.

    What does the stored procedure above do?

    0 comments