Viewing 15 posts - 16 through 30 (of 34 total)
I have restored the last transactional Log backup with the option of STANDBY on SSMS. The database is now back to ReadOnly / STANDBY. Now I users will be able...
February 7, 2013 at 12:49 pm
I'm doing REBUILDs . I'm on Enterprise 2008 R2.
Cannot do ONLINE=ON . We have BLOBs datatypes.
February 7, 2013 at 12:08 pm
Ok, Guys the The Restore was successful and the Log shipping is back on sync. I can confirm it by looking at the restore log on the Log File Viewer....
February 7, 2013 at 12:06 pm
Very good Alternative Scott.
But don't want to go with Partitioning yet. I will definitely keep that on mind though.
If I can figure a way out to split the job into...
February 7, 2013 at 10:49 am
Guys,
Is the full restore possible on the Secondary Database while it is being Replicated ?
My secondary database for this log shipping is replicated. So do i have to...
February 7, 2013 at 10:13 am
Very much appreciate George and Perry.
February 7, 2013 at 9:56 am
Hi Sotn,
One question I would like to ask is why the log backups are not taken during the period of 21:00 to 7:00 ?
I believe that it would be...
February 7, 2013 at 9:50 am
Yes , that's what i thought . But I take Full backups every 3 days and diffs everyday. And the LS is out of sync for like a week now....
February 7, 2013 at 8:39 am
Hey, ya'll are right guys. Looks like the Restore jobs on the Secondary database is not restored successfully.
( Eventhough it shows that job run successfully )
The sql event...
February 6, 2013 at 9:15 am
Hi,
Log shipping to a secondary server is also an option . You can query on the secondary log shipping database as well. LS is also very easy to implement.
January 29, 2013 at 3:07 pm
Hi
Recently I was asked lots of questions on SQL Failover Clustering.
Like :
1. What is the difference between Active/Active , Active/Passive Clustering.
2. What are the main things to be...
January 29, 2013 at 1:15 pm
Hey, thank your for your suggestion.
What i was doing was setting up log shipping which had created an extra log backup job. I already had an existing Transactional log backup...
November 30, 2012 at 11:31 am
Is it possible that I use the Log shipping backups as my Regular transactional log backup in case of future Restore of Database?
November 30, 2012 at 11:02 am
Hey Gail,
I have my Log shipping running and transactional log is shipped to a non-production server for DBCC CHECKDB purposes. My regular log shipping which is hourly is running parallel....
November 30, 2012 at 10:45 am
Viewing 15 posts - 16 through 30 (of 34 total)