Viewing 15 posts - 42,001 through 42,015 (of 49,571 total)
shahnawaz (1/5/2009)
infact i dont have a backup of the database.i was having only one copy of the database that is giving me this error.
Why no backup?
is there any way i...
January 5, 2009 at 1:32 am
Your only option to fix this is to restore a clean backup that was taken before the corruption. If the DB is in full recovery and there are tran log...
January 5, 2009 at 12:42 am
How are the two tables related?
What makes dd relate to ed and fr to gd?
If it's the order of the rows, then what column defines that order?
January 5, 2009 at 12:31 am
Oh, one other thought.
If you have a DB growing that fast with performance problems, you may want to consider getting a specialist in to analyse and make recommendations. Especially if...
January 5, 2009 at 12:18 am
DBADave (1/4/2009)
January 5, 2009 at 12:07 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic629584-323-1.aspx
January 5, 2009 at 12:05 am
Lester Policarpio (1/4/2009)
In situations like this can I take the database to offline mode then take it to online mode?
You can. It's not likely, by itself, to resolve anything though.
SQL...
January 4, 2009 at 11:40 pm
branovuk (1/3/2009)
Let me ask here, and not open new topic: what is best combination for backup: full+diff, or some combination with log backup as well.
Sorry, just noticed this...
January 4, 2009 at 11:32 pm
Jayakumar Krishnan (1/4/2009)
Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: 120.2.7.30]
That looks like a Kerberos issue. Are there any other errors in...
January 4, 2009 at 2:24 pm
As the error says, siteID cannot be in the order by clause, because it's not contained in the group by and it's not an aggregate.
What's the point of having it...
January 4, 2009 at 1:51 pm
peter.chafin (1/4/2009)
There has to be some way to read the TRN files to see what types of transactions were taking place.
There are, but they are not cheap. SQL has undocumented...
January 4, 2009 at 1:23 pm
nbourre (1/4/2009)
Can someone tell me what's wrong with this syntax?
SELECT @lastSite = MAX(siteID)
FROM sites
WHERE fkSectorID = @sectorID
ORDER BY siteID DESC;
January 4, 2009 at 1:16 pm
nbourre (1/4/2009)
Now let's take that a step further. Let say I would like to generate the site with the last number from the same...
January 4, 2009 at 12:47 pm
It's very hard to tell why after the fact.
Were there any reindex jobs running during the period the log grew?
Having deleted tran log backups, you should do a full back...
January 4, 2009 at 12:42 pm
Viewing 15 posts - 42,001 through 42,015 (of 49,571 total)