Many thanks to you all for you suggestions. I'm now able to restore my full and log backups onto a standby server. I used the Database Maintenance...
I'm not quite sure what you mean by re-enabling the Tlog backup schedule. I can restore the full backup onto the standby server without a problem;...
Thanks for the suggestions. I've tried backing up the log WITH INIT which resolved the log backup file size isses, but when I try to restore this log...
Hi, I've set up backup jobs to perform a full database backup daily and a transaction log backup hourly during working hour. The transaction Log...
That the document I've been following so far. I see from this forum that someone previously logged a call experiencing the same problem. He/She...
I've run the SP_resolve_logins SP and it was successful. I still get the Role Change failed error message when I run the SP_Chanage_Monitor_role SP.
Many thanks; the error was due to the Service Pack being different on both servers. I have now encountered another problem when running the next...
One of the servers is SP3. the Other has the letters RTM in the section where SP details should be. What does RTM mean??
The SQL services on both servers have full admin privilages. Both serveres are W2K SP4 running SQL 2000 Enterprice Edition.
I've looked at the article and the job created with the Database Maintenance Plan wizard completes successfully. My problem is when I run the...
I've come across a problem performing role change in Log shipping. I'm following the instruction on BOL and when executing the...
At the moment I'm only testing so both the Primary and Secondary databases are test copies and are not accessed by anyone even for reporting. I set...
I'm in the process of setting up log shipping and have come across a problem. It looks like the Transaction log backups are being backed up ok on the...
Separate names with a comma.
