Viewing 15 posts - 5,056 through 5,070 (of 9,241 total)
Run DBCC CHECKDB with all_errormsgs and post full details
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 10, 2012 at 8:26 am
Jpotucek (9/10/2012)
awesome! Thank you Perry!
You're welcome
Jpotucek (9/10/2012)
IS it true that you you cannot share resources, including disk resources, between instances.You get one instance per "Service or Application"?
That's...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 10, 2012 at 8:22 am
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 10, 2012 at 6:34 am
Jpotucek (9/7/2012)
First, a little background. The Admin guys have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 10, 2012 at 4:33 am
Ignacio A. Salom Rangel (9/8/2012)
but for that to work there must be no new full backup since Log Shipping was started.
This is not completely true!
opc.three (9/9/2012)
-...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 10, 2012 at 2:46 am
Ignacio A. Salom Rangel (9/8/2012)
but for that to work there must be no new full backup since Log Shipping was started.
Is that from your experiences?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 8, 2012 at 2:07 pm
Differentials can indeed be used to repair a LS scenario
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 8, 2012 at 3:20 am
Best way to learn is to actually build one, see my guide starting at this link[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 7, 2012 at 3:54 pm
rohaandba (9/7/2012)
Thanks Guys for your detail step by step guidance.It worked great. My secondary database is up now.
I was panic, Thanks for all the help.
You were given two solutions...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 7, 2012 at 9:25 am
check this and this for more info
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 7, 2012 at 4:52 am
MissTippsInOz (9/7/2012)
rohaandba (9/7/2012)
though I have the tran-backup set, I think its all messed up now.
I see only way is to diable the respective...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 7, 2012 at 3:29 am
rohaandba (9/7/2012)
I see only way is to diable the respective jobs and reset the log-shipping again by resoting the new full backup.Thanks
Did you even bother to read my...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 7, 2012 at 2:59 am
Post it anyway with your solution as it may help others in the same situation
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 7, 2012 at 2:57 am
to add hours to days use the DATEADD function
today
select getdate()
today + 3 hours
select dateadd(hh, 3, getdate())
today - 3 hours
select dateadd(hh, -3, getdate())
today + 3 hours 1 week in the future
select...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 7, 2012 at 2:11 am
MissTippsInOz (9/6/2012)
Old post revival!! Just wondered how you managed to get this one resolved as I've a similar situation.Thanks
post full details into a new thread for more help
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 7, 2012 at 1:58 am
Viewing 15 posts - 5,056 through 5,070 (of 9,241 total)