Viewing 15 posts - 1,081 through 1,095 (of 1,319 total)
Look at free space on the drive your writing to. Also, have a look at these links. Varied answers but they may provide some other direction towards a resolution.
http://support.microsoft.com/kb/326485
http://www.dbforums.com/t812439.html
http://www.sqlservercentral.com/Forums/Topic128881-24-1.aspx
http://sql-server-performance.com/Community/forums/t/4946.aspx
-- You can't be late until you show up.
June 12, 2008 at 2:17 pm
Haven't heard or said tuple in ages...probably from my school days, long, long ago! It's a funny sounding word actually. I asked my 13 year-old if she had ever heard...
-- You can't be late until you show up.
June 12, 2008 at 2:04 pm
Your posting in the wrong forum. For quicker, more accurate responses, post in SQL2005. See Ed's post. Quit shrinking the database. Size it properly with enough free disk remaining for...
-- You can't be late until you show up.
June 12, 2008 at 1:52 pm
See Steve's suggestion. Call an outage and restart the services/server. It'll rebuild tempdb. Can you determine what's filling it up (maintenance job? runaway query?) or are you dead in the...
-- You can't be late until you show up.
June 12, 2008 at 1:48 pm
That's about the only way in SQL2K. There are third party tools, like LiteSpeed that will allow you to restore a table (or other objects) individually but I don't recall...
-- You can't be late until you show up.
June 12, 2008 at 1:41 pm
Anything by Itzik Ben-Gan and Kalen Delaney are good ones. The link below has many book reviews, depending on what you want to do (there is one for .NET programming...
-- You can't be late until you show up.
June 12, 2008 at 1:31 pm
I'd be very careful killing jobs that are "sleeping". Why would you want to delete the jobs? Are you trying to do a restore and have an active thread into...
-- You can't be late until you show up.
June 9, 2008 at 3:25 pm
My oldest IS going to college this fall. I can't believe how fast the time has gone by. When she was born, I decided that I had to have a...
-- You can't be late until you show up.
June 6, 2008 at 8:44 am
If your database is set to "simple", you cannot backup the log. Are you running any maintenance jobs like rebuilding indexes? As far as delete versus truncate, is it purging...
-- You can't be late until you show up.
June 6, 2008 at 8:08 am
A lot of hits on Google. Does the file exist in that location, with that name? Is it a network drive as opposed to a physical drive? Also, take a...
-- You can't be late until you show up.
June 6, 2008 at 7:59 am
Glad you sorted it out. It is an online operation, I forgot that SQL will grab as much as it can (up to the max, if there is one) but...
-- You can't be late until you show up.
June 5, 2008 at 11:33 am
Can you run a DBCC CHECHKDB WITH NO_INFOMSGS, ALL_ERRORMSGS on the database in question and post the results? Wondering if you might have corruption....
-- You can't be late until you show up.
June 5, 2008 at 8:16 am
If you can supply some table layouts and code samples, we might be able to help. What are the sprocs doing, selects/updates/deletes? Are your indexes optimized? How many is "and...
-- You can't be late until you show up.
June 5, 2008 at 8:01 am
Great tool. You can download a trial version, for free, and check it out. I've used it in the past to actually resolve an issue we were having. Trying to...
-- You can't be late until you show up.
June 5, 2008 at 7:51 am
I don't believe there are limits to number of rows (laks = 100,000 -right??). I have tables with 500 times that amount and don't have issues (I'm running SQL2K, sp4)....
-- You can't be late until you show up.
June 4, 2008 at 7:31 am
Viewing 15 posts - 1,081 through 1,095 (of 1,319 total)