você pode usar o select into, mas o ideal é criar a nova tabela e depois inserir os dados com o insert into com select ...
--**********************SN1************************
Insert Into SIGA_6Horas.dbo.SN1010 (
N1_FILIAL, N1_CBASE, N1_ITEM, N1_AQUISIC, N1_DESCRIC, N1_QUANTD, N1_BAIXA, N1_CHAPA, N1_GRUPO, N1_CSEGURO,
N1_APOLICE, N1_DTVENC, N1_TIPOSEG, N1_FORNEC, N1_LOJA, N1_LOCAL, N1_LOCALDE, N1_NSERIE, N1_NFISCAL,
N1_PROJETO, N1_CHASSIS, N1_PLACA, N1_STATUS, N1_PATRIM, N1_CODCIAP, N1_DTBLOQ, N1_ICMSAPR, N1_FORN2,
N1_BASESUP, N1_ITEMSUP, N1_CODBEM, N1_SERIE, N1_MARCA, N1_DTGARAN, N1_IDENTI, N1_DOCMAC, N1_CODMODE, N1_CODCATE, N1_TEMOCOR, N1_CTRLFIS, D_E_L_E_T_, R_E_C_N_O_
)
--BACKUP
Select
N1_FILIAL, N1_CBASE, N1_ITEM, N1_AQUISIC, N1_DESCRIC, N1_QUANTD, N1_BAIXA, N1_CHAPA, N1_GRUPO, N1_CSEGURO,
N1_APOLICE, N1_DTVENC, N1_TIPOSEG, N1_FORNEC, N1_LOJA, N1_LOCAL, N1_LOCALDE, N1_NSERIE, N1_NFISCAL,
N1_PROJETO, N1_CHASSIS, N1_PLACA, N1_STATUS, N1_PATRIM, N1_CODCIAP, N1_DTBLOQ, N1_ICMSAPR, N1_FORN2,
N1_BASESUP, N1_ITEMSUP, N1_CODBEM, N1_SERIE, N1_MARCA, N1_DTGARAN, N1_IDENTI, N1_DOCMAC, N1_CODMODE, N1_CODCATE, N1_TEMOCOR, N1_CTRLFIS, D_E_L_E_T_, R_E_C_N_O_
From SIGA_6Horas.dbo.SN1010_ZEUS
