|
|
|
SSC Journeyman
 
Group: General Forum Members
Last Login: Thursday, June 18, 2009 8:34 AM
Points: 83,
Visits: 37
|
|
Interesting. This problem doesn't seem to exist in my SQL Server 2000 -- at least not working with the Enterprise Manager > [server name] > Properties, which is the only way I know to do it. It just has discrete slots for startup parameters and I added /T3226 to the end of the list. If there are any spaces, semicolons, etc. to be added, it adds them. I don't have to worry about it.
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Monday, April 27, 2009 8:58 AM
Points: 6,
Visits: 67
|
|
| It's always good to know the differences b/t the 2 products:) Microsoft loves to keep us on our toes and make us earn our pay!:) I just updated 7 of our dev instances so I can keep an eye on it. I've got 500 databases on each of my SQL 2k5 32 bit instances so 23 hourly tran log backups, plus a full backup every day, makes each of our errorlogs a complete nightmare (24 backup ops * 500 databases = 12000 rows of unneeded informational data every day)! I was wondering if you have encountered any oddities or any issues in your experience with using the flag? I'm rolling this change out to our production servers in a few weeks so any input would be helpful!
|
|
|
|
|
SSC Journeyman
Group: General Forum Members
Last Login: Thursday, June 18, 2009 8:34 AM
Points: 83,
Visits: 37
|
|
Absolutely no problems. The thing keeps humming right along, on a 24/7 application.
|
|
|
|
|
SSCrazy
Group: General Forum Members
Last Login: Monday, June 01, 2009 6:51 AM
Points: 2,138,
Visits: 127
|
|
Use DBCC TRACEON (3226,-1) for global scope. I set it on my dev server and it's great! I'm planning on setting it in production next week
|
|
|
|
