Refer http://www.sql-server-performance.com/articles/clustering/log_shipping_70_p1.aspx this will work on 2000 version too.

Hi, see if this link http://support.microsoft.com/kb/891058 helps you

I have to genrate a Store procedures script from SQL sever 2000 when i try to execute these script on Sql Server 2005 it gives the following Error "Msg 15157,Setuser failed because of one of the following reasons: the database principal 'nust' does not exist, its corresponding server principal...

Dear All, Just i want to know the different type of constarints (Primary Key,Foreign Key ..etc..)on each table in a database. could any one help me the script file to list all the coulmns and there realtion. Thanks, THulasi R

Buenas tardes: Algo que se me ocurre es: Checa el nivel de auditoría que tienes en la propiedades del servidor. Seleccionar el servidor, boton derecho , propiedades, seguridad, nivel de auditoria para que el log no crezca tanto puedes seleccionar "None" en el nivel. Espero sirva de algo

Hi Danny, Here is the interesting discussion here on the same http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2283786&SiteID=1 and http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=889290&SiteID=1 IMO, you can drop the device and then you can delete the physical t-log files, and, then...

Hi, You have to analyse and foresee the growth of the database for the next 5 years (atleast) and based on that you have to keep hard disk space available for database. When you configure database growth option its always recommended that you set it for fix mb refer http://www.extremeexperts.com/SQL...

Hi, Here is a link from where you can download evaluation copy http://www.microsoft.com/downloads/details.aspx?FamilyID=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en hth

Hola Enrique No se si recuerdes si encontraste alguna solución para esto. Saludos,

No, AFAIK changing IP for an alias won't require service restart.