Viewing 15 posts - 2,926 through 2,940 (of 4,745 total)
Install RS on the new server exactly as installed on the original
follow these instructions
February 12, 2010 at 9:32 am
thats very bad practice. Are you sure you did not miss out a 'use database' when you did the install?
Master database is not intended for user tables.
Master database always operates...
February 12, 2010 at 6:51 am
does this coincide with a 'starting up database' message?.
Everytime a database starts SQL displays the last successful time CHECKDB ran. check the time , it won't be the current time...
February 12, 2010 at 6:23 am
Jeff Moden (2/10/2010)
February 11, 2010 at 7:13 am
Lynn, step away from this one.
you'll end up writing it and I think the guy is just having a play.
February 10, 2010 at 10:55 am
I got here as quick as I could.........:-)
in the awe enabled you will need reconfigure WITH OVERRIDE
yes enable lock pages in memory for the account SQL runs under.
set max memory...
February 10, 2010 at 10:51 am
right click on the primary database, select properties, select database mirroring, follow the steps through the wizard.
A witness is not a requirement, up to you whether you require high availability...
February 10, 2010 at 9:40 am
That you did, Gail, and callously informed me that my beloved sp_GoBackInTime had been deprecated.
which when you opened the code actually just called xp_GoBackIntime
I am SO looking forward to your...
February 10, 2010 at 4:59 am
Meanwhile, I'll do a bit more testing, but I think I've found a set of universes in which TSQL cursors and while-loops are nearly always demonstrably faster than set-based logic....
February 10, 2010 at 3:31 am
Gianluca Sartori (2/10/2010)
Is any of you willing to help this OP with the correct syntax to get his DB back? I don't remember all the parameters right now...
I think Gail...
February 10, 2010 at 3:29 am
the latest security patch you should apply for SQL2005 can be found by googling MS09-062
February 9, 2010 at 9:55 am
that looks like an error from a third party backup tool. What does their documentation say?
February 9, 2010 at 9:51 am
GilaMonster (2/9/2010)
george sibbald (2/9/2010)
GilaMonster (2/9/2010)
I've never been more serious in my life. At last I can join in a discussion on an area where I am a real self-appointed expert.
Expert?...
February 9, 2010 at 9:15 am
Alvin Ramard (2/9/2010)
Oh oh. Someone is asking for documentation or white paper for the "command". :w00t:Gus, wipe that smile off you face! 😀
surely that was asked tongue in...
February 9, 2010 at 9:07 am
Viewing 15 posts - 2,926 through 2,940 (of 4,745 total)