Viewing 15 posts - 1,756 through 1,770 (of 4,745 total)
good Point. whats the question again, venkat?
----------------------------------------------------------------------------------------
george sibbald
university of life and school of hard knocks
🙂
---------------------------------------------------------------------
June 4, 2011 at 3:53 pm
GilaMonster (6/4/2011)
george sibbald (6/4/2011)
its perfectly reasonable to start with the full restore in norecovery and have the log restores in standby mode.
I'm just wondering if the wizard does something...
---------------------------------------------------------------------
June 4, 2011 at 3:43 pm
no this will not adversely affect your live database
---------------------------------------------------------------------
June 4, 2011 at 1:38 pm
its perfectly reasonable to start with the full restore in norecovery and have the log restores in standby mode.
The log shipping jobs may be running and suceeding but are...
---------------------------------------------------------------------
June 4, 2011 at 1:23 pm
agent jobs owned by sa should not fail because of a password change - are you sure that was the cause?
---------------------------------------------------------------------
June 4, 2011 at 1:18 pm
Before the delete of the Database we took a netapp snapshot of the system to make we could get the files back if they were deleted. Unfortunately the snapshot only...
---------------------------------------------------------------------
June 4, 2011 at 7:25 am
what you did above is the method of last resort if your database is corrupted and you have no backup. Well done on saving the day but in reality if...
---------------------------------------------------------------------
June 3, 2011 at 12:58 pm
profiler trace should do it
---------------------------------------------------------------------
June 3, 2011 at 10:33 am
2011-06-02 08:53:46.28 Server Detected 8 CPUs. This is an informational message; no user action is required.
2011-06-02 08:53:46.34 Server Cannot use...
---------------------------------------------------------------------
June 2, 2011 at 3:38 pm
its very similar but you have to restart SQL for it to take effect.
Exact process is documented in the link I provided above.
---------------------------------------------------------------------
June 2, 2011 at 7:05 am
Kevin Skinner (6/1/2011)
---------------------------------------------------------------------
June 2, 2011 at 6:37 am
It will work.
Personally I run them under the same account.
---------------------------------------------------------------------
June 1, 2011 at 3:12 pm
Craig Farrell (6/1/2011)
Lowell (6/1/2011)
if not too much time has past, the default trace, which logs DDL events like CREATE ALTER DROP, might still have it:
Good call, Lowell, I forgot about...
---------------------------------------------------------------------
June 1, 2011 at 2:35 pm
do it through configuration manager and ONLY configuration manager. all required permissions will be taken care of that way.
Before the agent was running with local admin rights so would have...
---------------------------------------------------------------------
June 1, 2011 at 2:30 pm
tempdb is a system database and that has the potential to grow and fill a drive, it just takes one bad query.
As I said it depends on how tight space...
---------------------------------------------------------------------
June 1, 2011 at 2:20 pm
Viewing 15 posts - 1,756 through 1,770 (of 4,745 total)