Viewing 15 posts - 5,071 through 5,085 (of 9,253 total)
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...
September 7, 2012 at 9:25 am
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...
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...
September 7, 2012 at 2:59 am
Post it anyway with your solution as it may help others in the same situation
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...
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
September 7, 2012 at 1:58 am
Follow these steps
enable and start LS copy...
September 7, 2012 at 1:53 am
You'll typically install a new instance for a database when there are different security requirements or performance requirements.
Some applications such as Blackberry ES are best off ring fenced due...
September 7, 2012 at 1:48 am
sierra4 (9/6/2012)
there were SAN issues on the server where E: and F: became unavailable.
we realized this when the log backups were failing.
now that the drives are back online this is...
September 7, 2012 at 1:42 am
Just out of interet why is hyperv installed, are you hosting VMs on this box too?
September 6, 2012 at 3:50 pm
ramyours2003 (9/6/2012)
what is preffered node in sql cluster ?
The preferred node setting will attempt to locate the clustered sql instance group on a particular node or nodes. There is also...
September 6, 2012 at 9:38 am
sjimmo (9/6/2012)
Freeing the buffers and cache will make EVERYTHING in SQL Server run slower.
Not quite everything. When you checkpoint a database and then run DBCC DROPCLEANBUFFERS it will only...
September 6, 2012 at 8:15 am
ananda.murugesan (9/6/2012)
Mr. Perry Whittle, one final question1. What is the best pratices & procedure restarted both server principal & Mirror? if restart required.
Depends, are you rebooting both at sametime or...
September 6, 2012 at 4:03 am
Viewing 15 posts - 5,071 through 5,085 (of 9,253 total)