Viewing 15 posts - 181 through 195 (of 195 total)
Sure Gila, thanks that was a million tons ausome Advise for a fresher like me 🙂
September 10, 2012 at 3:59 am
Thanks Gila 🙂
But one more question..
Will the EXEC sp_updatestats; & EXEC sp_recompile 'sp_name';
help to fatser the performance?????
How should i go ahead and use it .. i mean whne thier is...
September 10, 2012 at 3:22 am
Perry Whittle (8/29/2012)
runal_jagtap (8/28/2012)
if it runs correct then the same setup needs to be done in accordance to Production...
😀
Log Shipping is not a new feature, it's solid and robust and...
August 29, 2012 at 1:17 am
MissTippsInOz (8/29/2012)
runal_jagtap (8/28/2012)
August 29, 2012 at 12:08 am
I cannot question the client directly as to what he is up to.. its just that i am asked to learn and implement LS on Test servers & if it...
August 28, 2012 at 11:17 pm
GilaMonster (8/28/2012)
Seriously, if this is a critical problem and you don't have any knowledge of performance tuning, get someone in to help.
Hi Gail,
Na its not that serious as of now.....
August 28, 2012 at 7:23 am
Thanks All 🙂 i will follow your answers :-):-)
August 28, 2012 at 6:26 am
I dont know the exact query.. but the network team says that its a DB issue & you should look into it..
How do i confirm whether its a DB issue...
August 28, 2012 at 6:06 am
Divine Flame (8/28/2012)
greeshma.patla (8/28/2012)
I Dont have .mdf and .ldf files tooo 🙁
I have only Transaction Log file and Data File
Is it possible to restore db ?
Please ...
August 28, 2012 at 5:51 am
greeshma.patla (8/28/2012)
I Dont have .mdf and .ldf files tooo 🙁
I have only Transaction Log file and Data File
Is it possible to restore db ?
Please help...
August 28, 2012 at 5:42 am
anthony.green (8/28/2012)
Yes, lookup sp_attach_db in BOL or a search engine of your choice.
Yes, this is also another way you can try which anthony said.....
Here you go with an example..
EXEC sp_attach_db...
August 28, 2012 at 4:55 am
I am new here as a DBA, but i think restoring wont work here.. instead you can right click on DATABASE and then select Attach Option & there you can...
August 28, 2012 at 4:48 am
Hi all,
I made it... it got solved with slight modifications... Thanks al:)
August 28, 2012 at 1:34 am
Thanks Gila & Divine 🙂
Will try out the steps but what should i be ready with apart from the steps???
I have got system with Enterprise edition & two servers to...
August 27, 2012 at 6:54 am
Hi Gila,
Thanks for the quick reply, i do have some stuff's and links..
I am not sure whether the link is complete solution....
http://www.mssqltips.com/sqlservertip/2301/step-by-step-sql-server-log-shipping/
1) Can you tell me whether the...
August 27, 2012 at 6:42 am
Viewing 15 posts - 181 through 195 (of 195 total)