Viewing 15 posts - 211 through 225 (of 307 total)
Hmmm a bit strange but also happened to me the first time i setup a log shipping with a copy and restore threshold of 15 minutes. In my case the...
November 8, 2007 at 6:27 pm
Joseph (11/7/2007)
FYI:by the way, if copy delta is too high, while checking the secondary server, please check the free space of drive of secondary server.
Whats your range of too high???
November 7, 2007 at 6:02 pm
whats your scheduled backup and restore threshold interval????
November 7, 2007 at 5:56 pm
Log Shipping is now successfull The reason why it has many errors yesterday is that MSSQLSERVER is not using the domain account (My Bad) 😀 Anyways many thanks to Ratnesh...
November 6, 2007 at 10:57 pm
I made a database test in server A then make a backup of it then restore it to server B in read-only mode then apply the log shipping but after...
November 6, 2007 at 2:34 am
What i did is that i restore the database using EM choosing the option in recovery completion state "leave database read-only and able to store additional transaction logs" then the...
November 6, 2007 at 2:00 am
The "Transaction Log Backup job for db maintenance plan" is now on error.
I am now getting this error message.
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3036: [Microsoft][ODBC SQL Server Driver][SQL Server]Database...
November 6, 2007 at 12:31 am
Thanks!!!! I think i have an idea about the error i encountered Do you think the process i did is right?? the only problem is that i must first restore...
November 6, 2007 at 12:06 am
Thanks Ratnesh Kumar Dwivedi for giving time to answer my questions so here it is....
Assuming Production ServerName = A, Destination and log shipping monitor = B
1. i pick the northwind...
November 5, 2007 at 11:10 pm
Hi this is the error message in the log shipping monitor. Transaction log backups are now seen in the secondary server folder its the log shipping restore (in the secondary...
November 5, 2007 at 7:09 pm
I encountered the same problem months ago i think the problem is with the auto close being checked in your database property check each of your databases to see those...
November 5, 2007 at 3:04 am
Ratnesh Kumar Dwivedi (11/5/2007) You can also check physical path of destination folder and make sure file is getting copied or not.
YEah your right the destination folder is not updated...
November 5, 2007 at 2:55 am
I thought the duty of replication is to replicate or copy data from 1 publisher to subscriber/s?? Our reason of replicating databases is that my superior wnats a live backup...
October 30, 2007 at 8:33 pm
that's a good script you have there gdmilner but in order to script all the users you must run the script in each of the databases and not to mention...
October 30, 2007 at 2:09 am
Yeah my scenario is also same as you i searched for many commands that will do the trick but end up making 1 😀
Ohhh 1 thing.... the script i gave...
October 29, 2007 at 6:45 pm
Viewing 15 posts - 211 through 225 (of 307 total)