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)