Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Backup troubles, cannot restore transaction logs

    Please try without truncating the log before the full backup

  • RE: Moving tables between servers

    To move DTS packages I use

    INSERT INTO msdb.dbo.sysdtspackages

    SELECT * FROM

    OPENDATASOURCE('SQLOLEDB', 'Data Source=SQL-Server;User ID=sa;Password=pwd').msdb.dbo.sysdtspackages

    It works fine from SQLAgent and keeps all servers synchronized.

    You might want to delete existing packages...

Viewing 2 posts - 1 through 2 (of 2 total)