Forum Replies Created

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

  • RE: transaction log backup/maintenance plan failure

    I hope that you aren't trying to Backup the Transaction log of the Master and MSDB databases.  You didn't state that in your question, so if you are the the...

  • RE: Log shipping in SQL Server 2000

    I put the stored procedures in the master database, because that is how Log shipping steps were explained to me.  You are the first person that has told me to...

  • RE: Log shipping in SQL Server 2000

    Thank you for you help.  I will try your suggestion.  this has been bothering me for two weeks now.

    Rob Broyles

  • RE: Log shipping in SQL Server 2000

    I may have made some mistakes on where I put statements, but this is what I have on my servers.  If you see anything that is out of place let...

  • RE: Query a backup file?

    YOu can have your DBA run a DTS package that can update the information in the database that your restored from his backup file.  He can create a linked server...

  • RE: .mdf and .ldf file dates

    If you impliment log shipping you will see that on the Warm(production server) that the modified dates of the MDF files on the databases never change.  On the standby server the modification dates...

  • RE: using xp_cmdshell in SQL server 2000 to copy file

    Ma'am, thank you for your reply.  I figured it out.  I thought that I had synchronized the accounts running the services on both my warm and standby servers.  I hadn't...

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