Post reply

dudas sobre la replicación

  • November 18, 2004 at 3:26 pm

    #87045

    I'm working on a contingence plan, we are gonna have a remote server with sql server, can i replicate the entire content of the server, i mean, the users, the dts packets, etc.

    Can you tell me about a software or something.

    Gracias.

  • November 19, 2004 at 7:48 am

    #530818

    I don't believe that Replication will work with Users and DTS packages.

    No creo que puede usar replicacion para todo.  Yo se que esta posible a duplicar Tables, Stored Procs, Views, Functions...pero no se sobre los usarios y especialmente yo dudo DTS.  Espero este ayuda...perdon por mi español mal

  • November 19, 2004 at 8:21 am

    #530845

    Hello!!

    There is a fuctionality for disaster recovery called Log Shipping you can replicate and entire database with users. It is a built-in fuctionality, you can find more info on http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship1.mspx

    I think that you can use log shipping to replicate your databases and create some custom-built jobs to have a backup for your users and DTS package, at least the scripts to create everything in you standby server.

    Si se replican los usuarios de la base de datos pero no los logins, esos los tendras que crear como te digo usando algun sql script para crearlos.

     

    Saludos

     

    Zareh

     

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

You must be logged in to reply to this topic. Login to reply