Viewing 15 posts - 91 through 105 (of 173 total)
Applying the transaction logs at the secondary server is done through the RESTORE command, which means that while those logs are being restored, the database has to be in...
May 5, 2009 at 8:32 pm
Hi Edwin,
I was not having access to system yesterday as I was away with personal work hence cann't reply back.
Neol has suggested a solution, hope that worked, if you...
May 5, 2009 at 4:21 am
sam rebus (5/3/2009)
oh, and distributor is the same server as publisher. it is a push subscription. replication is over WAN, coast to coast over 10mbs link
Based on the link value...
May 3, 2009 at 3:50 pm
sam rebus (5/3/2009)
I cannot use backup-restore for initialization. some of the tables are not replicated and also SPs are different.
You can always drop the tables that are not replicated....
May 3, 2009 at 3:48 pm
Do you have separate distributor and is this is pull or push subscription?
Why you do you have to reinitialize at time when there is good amount of latency,...
May 3, 2009 at 3:02 pm
It seems to be that data that distribution agent is trying to insert at subscriber already exists. This could have happened either some one possibly could have inserted records...
May 2, 2009 at 7:31 am
AAkula (4/9/2009)
Hi,please advice me how to configure Logshipping for share point databases
You can configure share point databases to logship similar to the other databases that you configure.
April 28, 2009 at 7:50 pm
AAkula (4/28/2009)
1.if we give the backup path of the databases directly to secondary server, then there is no need of Copy job right? or
2.do...
April 28, 2009 at 7:48 pm
Ville Lucander (4/28/2009)
I've loaded 170 million rows of data from an old Orcale DW to a staging DB (SQL2008, simple recovery model) and I'm now trying to fetch/update the table...
April 28, 2009 at 7:37 am
Hi Mike,
Are you running out of disk space?
If not, this can be avoided, by allocating sufficient space. Calculate approx space required for next quarter or two quarters or...
April 27, 2009 at 4:09 pm
Tara (4/27/2009)
yes there was some processing running and the reboot was done according to our shedule.anyways if nothing much i can do i will wait to recover.
Tara,
Going forward, if this...
April 27, 2009 at 3:40 pm
Database is still recovering, nothing much you can do, you have to wait.
Did you restart the server when any big transaction or process is happening?
April 27, 2009 at 9:00 am
I got the solution for that one, its SQL problem, I don't know whether the solution is correct or not,now my database is working fine,
What was...
April 24, 2009 at 7:15 am
Did the job LSCopy_ has ever run, if so can you pls. send run details
April 24, 2009 at 4:35 am
You are correct that is what I meant to say.
April 23, 2009 at 6:52 am
Viewing 15 posts - 91 through 105 (of 173 total)