I'm trying to add a databse from a sql baclup and assign the databse a new name. I'm unable to do it using the following code.
Svr = New Server(cn)
Dim TargetDB as string = "NewDB"
Dim SourceDb as string = "OldDB"
DirString = Svr.Information.RootDirectory + "\Backup\"
Dim res As Restore = New Restore()
res.Devices.AddDevice(DirString + "FUNDEZ_BackupData.bak", DeviceType.File)
res.Database = TargetDb
res.NoRecovery = False
res.ReplaceDatabase = False
res.RelocateFiles.Add(New RelocateFile(SourceDB + "_Data", Svr.Information.RootDirectory.ToString + "data\" + TargetDb + ".mdf"))
res.RelocateFiles.Add(New RelocateFile(SourceDB + "_log",Svr.Information.RootDirectory.ToString + "data\" + TargetDb + ".ldf"))
I always get error "Logical file 'FUNDEZ_backup test 1' is not part of database 'FUNDEZ_backup test 1'. Use RESTORE FILELISTONLY to list the logical file names.
RESTORE DATABASE is terminating abnormally."
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed.
Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…