Viewing 15 posts - 36,496 through 36,510 (of 49,562 total)
Samji_S (10/1/2009)
Yes, we do take log backups every 10 minutes and for my bad we recycle t-logs every 3 days :crying :
*sigh* You waited 2 weeks to fix a critical...
October 1, 2009 at 3:17 am
litu deb (10/1/2009)
As server is running out of space i have to shrink either log files/database file.I can't take log back up because of space issue.
Have you requested more space...
October 1, 2009 at 3:11 am
Why, on a server with 12 GB of memory, do you have the max for SQL Server set at 6? Are there other things running on this server?
32 bit or...
October 1, 2009 at 1:33 am
p.s. oh, the reason for the 67GB log file and small mdf. Full recovery model, no log backups. In that state, once the firstr full backup has been taken, log...
October 1, 2009 at 1:23 am
Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.
Shrinking causes massive fragmentation and will just result in the...
October 1, 2009 at 1:20 am
Try dropping the database completely and then restoring a complete new copy. The errors may have to do with trying to replace a file that isn't there.
Restore will put a...
October 1, 2009 at 1:19 am
Samji-389836 (9/30/2009)
We are getting this consistency errors since two weeks, that means I should be restoring affected...
October 1, 2009 at 1:04 am
As far as I know, that's not a repairable error.
Do you have a clean backup (one without these errors)? If so, restore it.
If not, try taking the DB into...
September 30, 2009 at 9:58 am
river-653653 (9/30/2009)
What about using BDCC shrink file instead of using the GUI (EM) to shrink the log file?
All the GUI does is run DBCC ShrinkDatabase or DBCC ShrinkFile.
September 30, 2009 at 9:44 am
ErickTreeTops (9/30/2009)
I have tried to disable the FK constraints temporarily so that i can remove the records but the usual syntax appears not to work.
You have to drop the constraint...
September 30, 2009 at 1:46 am
Silverfox (9/30/2009)
I have heard that UDF's; while not technically stored procedures will get traced with the statement level events, such as SP:StmtStarting
Yup, but so will every other statement in the...
September 30, 2009 at 1:42 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 30, 2009 at 1:11 am
For the stored procedures, the event SP:Completed. Not sure offhand about the functions.
September 30, 2009 at 1:10 am
Glen Moffitt-317424 (9/29/2009)
Thanks for pointing out that distinction. For tracking/gathering blocking information what method would you suggest?
Query sys.dm_exec_requests. That will show you which connections are blocked and which...
September 30, 2009 at 1:05 am
Lynn Pettis (9/29/2009)
Add I must that article to the library in my sig block.
Much more and your sig will be larger than...
September 29, 2009 at 11:52 am
Viewing 15 posts - 36,496 through 36,510 (of 49,562 total)