question

GnterHagedorn-1615 avatar image
0 Votes"
GnterHagedorn-1615 asked GnterHagedorn-1615 commented

SQL SERVER 2016 Copy database Wizard on same server failing with Error 12550

Hi! I need help here...

I want to schedule a daily overwrite copy from one database with a new name on the same server.
Using the Copy Wizard I was able to set everything up but it fails with Error 12550 when running.

Source and Target are the same machine
I am using SMO Method
The SQLSERVERAGENT user has rights for local execution and local activation for SSIS

Any help appreciated.

Guenter

sql-server-generalsql-server-integration-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

fails with Error 12550 when running.

Error numbers are useless, please post the full error message text.



0 Votes 0 ·
Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered

Hello,

From the information you showed, this task failed because an error was encountered when starting to transfer data: Index was out of range. Must be non-negative and less than the size of the collection

Regarding this error, I recommend that you first install the latest updates (SP, CU) for your SQL Server 2016 instance to avoid any problems that have been fixed.

Then please check the restrictions in the Copy Database Wizard document to make sure the operation is correct.


Backup&restore is an alternative.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

GnterHagedorn-1615 avatar image
0 Votes"
GnterHagedorn-1615 answered GnterHagedorn-1615 published

Hi Olaf,

Thanks for the feedback. It's a German SQL Server. The error message is

Der Index lag außerhalb des Bereichs. Er darf nicht negativ und kleiner als die Auflistung sein.

which means that "the index is out of range. it should not be negative or less than the listing"


Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message

OnPreValidate,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,
OnPreValidate,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,
OnPostValidate,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,
OnPostValidate,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,
PackageStart,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,Beginn der Paketausführung.

DiagnosticEx,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,<?xml version="1.0"?><DTS:PipelineColumnMap xmlns:DTS="www.microsoft.com/SqlServer/Dts"/>;
Diagnostic,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,Maximale Anzahl von gleichzeitig ausführbaren Dateien ist auf 1 festgelegt.

DiagnosticEx,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,<?xml version="1.0"?><DTS:ParameterValues xmlns:DTS="www.microsoft.com/SqlServer/Dts"/>;
OnPreExecute,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,
OnPreExecute,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,
OnPreValidate,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,
OnPostValidate,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,
OnProgress,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,Die Ausführung des Tasks wurde soeben gestartet.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,Verbindung mit dem Server "POL_INST_SQL" wird hergestellt
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,Verbindung mit dem Server "POL_INST_SQL" wird hergestellt
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,Die Verbindung mit dem Server "POL_INST_SQL" wurde hergestellt.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,Die Verbindung mit dem Server "POL_INST_SQL" wurde hergestellt.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,Verbindung mit dem Server "POL_INST_SQL" wird hergestellt
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,Verbindung mit dem Server "POL_INST_SQL" wird hergestellt
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,Die Verbindung mit dem Server "POL_INST_SQL" wurde hergestellt.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,Die Verbindung mit dem Server "POL_INST_SQL" wurde hergestellt.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,Die Serverobjekte werden von "POL_INST_SQL" an den Server "POL_INST_SQL" übertragen.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,Die Serverobjekte werden von "POL_INST_SQL" an den Server "POL_INST_SQL" übertragen.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,Die Serverobjekte werden von "POL_INST_SQL" an den Server "POL_INST_SQL" übertragen.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,Die Serverobjekte werden von "POL_INST_SQL" an den Server "POL_INST_SQL" übertragen.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,Die Serverobjekte wurden an "POL_INST_SQL" übertragen.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,Die Serverobjekte wurden an "POL_INST_SQL" übertragen.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,LAGER_AZP_prod-Datenbank wird vom POL_INST_SQL Server als LAGER_AZP_prod_new an den POL_INST_SQL Server übertragen
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,LAGER_AZP_prod-Datenbank wird vom POL_INST_SQL Server als LAGER_AZP_prod_new an den POL_INST_SQL Server übertragen
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,Die Datendatei "LAGER_AZP_prod" im Pfad "e:\install\databases\LAGER_AZP_prod_new.mdf" wurde der Dateigruppe "[PRIMARY]" hinzugefügt.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:52,04.06.2021 08:45:52,0,0x,Die Datendatei "LAGER_AZP_prod" im Pfad "e:\install\databases\LAGER_AZP_prod_new.mdf" wurde der Dateigruppe "[PRIMARY]" hinzugefügt.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:53,04.06.2021 08:45:53,0,0x,Die Protokolldatei "LAGER_AZP_prod_log" wurde im Pfad "e:\install\databases\LAGER_AZP_prod_new_log.ldf" hinzugefügt.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:53,04.06.2021 08:45:53,0,0x,Die Protokolldatei "LAGER_AZP_prod_log" wurde im Pfad "e:\install\databases\LAGER_AZP_prod_new_log.ldf" hinzugefügt.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:53,04.06.2021 08:45:53,0,0x,Daten werden von "LAGER_AZP_prod" an die Datenbank "LAGER_AZP_prod_new" übertragen
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:53,04.06.2021 08:45:53,0,0x,Daten werden von "LAGER_AZP_prod" an die Datenbank "LAGER_AZP_prod_new" übertragen
OnError,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:56,04.06.2021 08:45:56,0,0x,Der Index lag außerhalb des Bereichs. Er darf nicht negativ und kleiner als die Auflistung sein.
Parametername: index
StackTrace: bei System.Collections.BitArray.Set(Int32 index, Boolean value)
bei Microsoft.SqlServer.Management.Smo.PermissionWorker.GetPermissionSetBase(PermissionEnumKind kind, Int32 i)
bei Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetPermissionsFromCache(PermissionEnumKind kind)
bei Microsoft.SqlServer.Management.Smo.SqlSmoObject.AddScriptPermissions(StringCollection sc, PermissionEnumKind kind, ScriptingPreferences sp)
bei Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptCreateSpecialUrn(Urn urn, ScriptingPreferences sp, ObjectScriptingType& scriptType)
bei Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptCreate(Urn urn, ScriptingPreferences sp, ObjectScriptingType& scriptType)
bei Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptCreateObjects(IEnumerable`1 urns)
bei Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptUrns(List`1 orderedUrns)
bei Microsoft.SqlServer.Management.Smo.ScriptMaker.DiscoverOrderScript(IEnumerable`1 urns)
bei Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptWorker(List`1 urns, ISmoScriptWriter writer)
bei Microsoft.SqlServer.Management.Smo.DataTransferBase.GetScriptLoadedTransferWriter()
bei Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
bei Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer()
OnError,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:56,04.06.2021 08:45:56,0,0x,Der Index lag außerhalb des Bereichs. Er darf nicht negativ und kleiner als die Auflistung sein.
Parametername: index
StackTrace: bei System.Collections.BitArray.Set(Int32 index, Boolean value)
bei Microsoft.SqlServer.Management.Smo.PermissionWorker.GetPermissionSetBase(PermissionEnumKind kind, Int32 i)
bei Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetPermissionsFromCache(PermissionEnumKind kind)
bei Microsoft.SqlServer.Management.Smo.SqlSmoObject.AddScriptPermissions(StringCollection sc, PermissionEnumKind kind, ScriptingPreferences sp)
bei Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptCreateSpecialUrn(Urn urn, ScriptingPreferences sp, ObjectScriptingType& scriptType)
bei Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptCreate(Urn urn, ScriptingPreferences sp, ObjectScriptingType& scriptType)
bei Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptCreateObjects(IEnumerable`1 urns)
bei Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptUrns(List`1 orderedUrns)
bei Microsoft.SqlServer.Management.Smo.ScriptMaker.DiscoverOrderScript(IEnumerable`1 urns)
bei Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptWorker(List`1 urns, ISmoScriptWriter writer)
bei Microsoft.SqlServer.Management.Smo.DataTransferBase.GetScriptLoadedTransferWriter()
bei Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
bei Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer()
OnProgress,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:56,04.06.2021 08:45:56,0,0x,Fehler bei Datenbankübertragung für 1 Datenbank(en).
OnProgress,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:56,04.06.2021 08:45:56,100,0x,Die Übertragung von Objekten wurde ausgeführt.
OnTaskFailed,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:56,04.06.2021 08:45:56,0,0x,
OnPostExecute,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:56,04.06.2021 08:45:56,0,0x,
OnWarning,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:56,04.06.2021 08:45:56,-2147381246,0x,SSIS-Warnungscode "DTS_W_MAXIMUMERRORCOUNTREACHED". Die Execution-Methode wurde erfolgreich ausgeführt, aber die Anzahl von ausgelösten Fehlern (1) hat den maximal zulässigen Wert erreicht (1). Deshalb tritt ein Fehler auf. Dieses Problem tritt auf, wenn die Anzahl von Fehlern den in "MaximumErrorCount" angegebenen Wert erreicht. Ändern Sie den Wert für "MaximumErrorCount", oder beheben Sie die Fehler.

OnPostExecute,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:56,04.06.2021 08:45:56,0,0x,
DiagnosticEx,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:56,04.06.2021 08:45:56,0,0x,<?xml version="1.0"?><DTS:ProcessMemoryUsage xmlns:DTS="www.microsoft.com/SqlServer/Dts"><DTS:PeakWorkingSetSize>213864448</DTS:PeakWorkingSetSize></DTS:ProcessMemoryUsage>;
PackageEnd,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{F9771DE5-EC97-4510-BB33-81DC19654220},04.06.2021 08:45:56,04.06.2021 08:45:56,1,0x,Ende der Paketausführung.

OnPreValidate,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:21,04.06.2021 08:53:21,0,0x,
OnPreValidate,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:21,04.06.2021 08:53:21,0,0x,
OnPostValidate,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:21,04.06.2021 08:53:21,0,0x,
OnPostValidate,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:21,04.06.2021 08:53:21,0,0x,
PackageStart,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:21,04.06.2021 08:53:21,0,0x,Beginn der Paketausführung.

DiagnosticEx,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,<?xml version="1.0"?><DTS:PipelineColumnMap xmlns:DTS="www.microsoft.com/SqlServer/Dts"/>;
Diagnostic,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,Maximale Anzahl von gleichzeitig ausführbaren Dateien ist auf 1 festgelegt.

DiagnosticEx,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,<?xml version="1.0"?><DTS:ParameterValues xmlns:DTS="www.microsoft.com/SqlServer/Dts"/>;
OnPreExecute,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,
OnPreExecute,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,
OnPreValidate,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,
OnPostValidate,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,
OnProgress,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,Die Ausführung des Tasks wurde soeben gestartet.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,Verbindung mit dem Server "POL_INST_SQL" wird hergestellt
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,Verbindung mit dem Server "POL_INST_SQL" wird hergestellt
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,Die Verbindung mit dem Server "POL_INST_SQL" wurde hergestellt.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,Die Verbindung mit dem Server "POL_INST_SQL" wurde hergestellt.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,Verbindung mit dem Server "POL_INST_SQL" wird hergestellt
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,Verbindung mit dem Server "POL_INST_SQL" wird hergestellt
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,Die Verbindung mit dem Server "POL_INST_SQL" wurde hergestellt.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,Die Verbindung mit dem Server "POL_INST_SQL" wurde hergestellt.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,Die Serverobjekte werden von "POL_INST_SQL" an den Server "POL_INST_SQL" übertragen.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,Die Serverobjekte werden von "POL_INST_SQL" an den Server "POL_INST_SQL" übertragen.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,Die Serverobjekte werden von "POL_INST_SQL" an den Server "POL_INST_SQL" übertragen.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,Die Serverobjekte werden von "POL_INST_SQL" an den Server "POL_INST_SQL" übertragen.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,Die Serverobjekte wurden an "POL_INST_SQL" übertragen.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,Die Serverobjekte wurden an "POL_INST_SQL" übertragen.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,LAGER_AZP_prod-Datenbank wird vom POL_INST_SQL Server als LAGER_AZP_prod_new an den POL_INST_SQL Server übertragen
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,LAGER_AZP_prod-Datenbank wird vom POL_INST_SQL Server als LAGER_AZP_prod_new an den POL_INST_SQL Server übertragen
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,Die Datendatei "LAGER_AZP_prod" im Pfad "e:\install\databases\LAGER_AZP_prod_new.mdf" wurde der Dateigruppe "[PRIMARY]" hinzugefügt.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,Die Datendatei "LAGER_AZP_prod" im Pfad "e:\install\databases\LAGER_AZP_prod_new.mdf" wurde der Dateigruppe "[PRIMARY]" hinzugefügt.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,Die Protokolldatei "LAGER_AZP_prod_log" wurde im Pfad "e:\install\databases\LAGER_AZP_prod_new_log.ldf" hinzugefügt.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,Die Protokolldatei "LAGER_AZP_prod_log" wurde im Pfad "e:\install\databases\LAGER_AZP_prod_new_log.ldf" hinzugefügt.
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,Daten werden von "LAGER_AZP_prod" an die Datenbank "LAGER_AZP_prod_new" übertragen
OnInformation,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:22,04.06.2021 08:53:22,0,0x,Daten werden von "LAGER_AZP_prod" an die Datenbank "LAGER_AZP_prod_new" übertragen
OnError,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:25,04.06.2021 08:53:25,0,0x,Der Index lag außerhalb des Bereichs. Er darf nicht negativ und kleiner als die Auflistung sein.
Parametername: index
StackTrace: bei System.Collections.BitArray.Set(Int32 index, Boolean value)
bei Microsoft.SqlServer.Management.Smo.PermissionWorker.GetPermissionSetBase(PermissionEnumKind kind, Int32 i)
bei Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetPermissionsFromCache(PermissionEnumKind kind)
bei Microsoft.SqlServer.Management.Smo.SqlSmoObject.AddScriptPermissions(StringCollection sc, PermissionEnumKind kind, ScriptingPreferences sp)
bei Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptCreateSpecialUrn(Urn urn, ScriptingPreferences sp, ObjectScriptingType& scriptType)
bei Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptCreate(Urn urn, ScriptingPreferences sp, ObjectScriptingType& scriptType)
bei Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptCreateObjects(IEnumerable`1 urns)
bei Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptUrns(List`1 orderedUrns)
bei Microsoft.SqlServer.Management.Smo.ScriptMaker.DiscoverOrderScript(IEnumerable`1 urns)
bei Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptWorker(List`1 urns, ISmoScriptWriter writer)
bei Microsoft.SqlServer.Management.Smo.DataTransferBase.GetScriptLoadedTransferWriter()
bei Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
bei Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer()
OnError,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:25,04.06.2021 08:53:25,0,0x,Der Index lag außerhalb des Bereichs. Er darf nicht negativ und kleiner als die Auflistung sein.
Parametername: index
StackTrace: bei System.Collections.BitArray.Set(Int32 index, Boolean value)
bei Microsoft.SqlServer.Management.Smo.PermissionWorker.GetPermissionSetBase(PermissionEnumKind kind, Int32 i)
bei Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetPermissionsFromCache(PermissionEnumKind kind)
bei Microsoft.SqlServer.Management.Smo.SqlSmoObject.AddScriptPermissions(StringCollection sc, PermissionEnumKind kind, ScriptingPreferences sp)
bei Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptCreateSpecialUrn(Urn urn, ScriptingPreferences sp, ObjectScriptingType& scriptType)
bei Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptCreate(Urn urn, ScriptingPreferences sp, ObjectScriptingType& scriptType)
bei Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptCreateObjects(IEnumerable`1 urns)
bei Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptUrns(List`1 orderedUrns)
bei Microsoft.SqlServer.Management.Smo.ScriptMaker.DiscoverOrderScript(IEnumerable`1 urns)
bei Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptWorker(List`1 urns, ISmoScriptWriter writer)
bei Microsoft.SqlServer.Management.Smo.DataTransferBase.GetScriptLoadedTransferWriter()
bei Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
bei Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer()
OnProgress,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:25,04.06.2021 08:53:25,0,0x,Fehler bei Datenbankübertragung für 1 Datenbank(en).
OnProgress,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:25,04.06.2021 08:53:25,100,0x,Die Übertragung von Objekten wurde ausgeführt.
OnTaskFailed,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:25,04.06.2021 08:53:25,0,0x,
OnPostExecute,POL_INST_SQL,NT Service\SQLSERVERAGENT,POL_INST_SQL_POL_INST_SQL_Transfer Objects Task,{4C4C4876-8375-4C4D-85B1-FF132688E7EA},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:25,04.06.2021 08:53:25,0,0x,
OnWarning,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:25,04.06.2021 08:53:25,-2147381246,0x,SSIS-Warnungscode "DTS_W_MAXIMUMERRORCOUNTREACHED". Die Execution-Methode wurde erfolgreich ausgeführt, aber die Anzahl von ausgelösten Fehlern (1) hat den maximal zulässigen Wert erreicht (1). Deshalb tritt ein Fehler auf. Dieses Problem tritt auf, wenn die Anzahl von Fehlern den in "MaximumErrorCount" angegebenen Wert erreicht. Ändern Sie den Wert für "MaximumErrorCount", oder beheben Sie die Fehler.

OnPostExecute,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:25,04.06.2021 08:53:25,0,0x,
DiagnosticEx,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:25,04.06.2021 08:53:25,0,0x,<?xml version="1.0"?><DTS:ProcessMemoryUsage xmlns:DTS="www.microsoft.com/SqlServer/Dts"><DTS:PeakWorkingSetSize>233639936</DTS:PeakWorkingSetSize></DTS:ProcessMemoryUsage>;
PackageEnd,POL_INST_SQL,NT Service\SQLSERVERAGENT,CDW_POL_INST_SQL_POL_INST_SQL_6,{42519877-A599-4A66-B5ED-A5820BE03281},{CE44C36D-C455-47B5-AF65-3FCBE0CA4820},04.06.2021 08:53:25,04.06.2021 08:53:25,1,0x,Ende der Paketausführung.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered Criszhan-msft edited

Hi,

This seems to be a permissions issue.

To use the Copy Database Wizard, you must be a member of the sysadmin fixed server role on the source and target servers.

In addition, please check the permissions of the service account of SQL Server Agent and make sure that it is also a member of the sysadmin fixed server role.

I have tested on one server many times and failed to reproduce your problem, I am using SSMS18.9.1

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

GnterHagedorn-1615 avatar image
0 Votes"
GnterHagedorn-1615 answered

Hi Criszhan,

Thanks for your answer. I am logged in as Administrator. The SQL Server Agent user has been added to the Administrator group as well. Source and Target server is the same SQL Server. I am also using SSMS18.9.1.

So this seems not to be the problem?

Guenter



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

GnterHagedorn-1615 avatar image
0 Votes"
GnterHagedorn-1615 answered

Hi Chriszhan,

I will check it out. Thanks!

Backup&restore .... I want to schedule it on a daily basis. How can I do this without manual work?

Thanks again,
Guenter

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered

Hi,

Backup&restore .... I want to schedule it on a daily basis. How can I do this without manual work?

If you need to backup and then automatically restore the new database on the same SQL Server instance may be complicated, and you need to use SQL Server Agent jobs to run some scripts. This is also related to your database recovery model, you don't need to consider transaction log backups for simple recovery model.

If you need to copy the source database to a different SQL Server instance, you can consider SQL Server's HA/DR technology, such as Always On AG, log shipping, etc.

Before that, I would like to know the results of using the Copy Database Wizard after you apply the latest update to the instance of SQL Server 2016.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

GnterHagedorn-1615 avatar image
0 Votes"
GnterHagedorn-1615 answered GnterHagedorn-1615 commented

Hi again,

The SP and CU Updates did the trick. Thanks again!

But the idea of doing it all without the integration services sounds great. All the work is done on the same server, so it souldn't be too difficult. And it is a very simple database with special needs.

I checked the TSQL documentation and there are commands for BACKUP and RESTORE of databases, that I could put into a stored procedure and run it from the SQL Server Agent.

Is there an existing script that has beed tested and that I could adapt for this?

Cheers,
Guenter

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello,

I am glad to know that your original problem has been resolved. It seems that this is a error that has been fixed.

Sorry I don't have any ready-made automated backup and restore scripts, you can try to look for information on the Internet. The key to automatic backup/restore is a backup file of a unique name(or it under a directory of a unique name), and then the agent can find this backup file when restoring.

1 Vote 1 ·

Thanks again!

0 Votes 0 ·