Viewing 15 posts - 39,166 through 39,180 (of 49,571 total)
mark (5/12/2009)
Also, I don't think that your log file should exceed your database size, which will inevitably happen if you leave it alone.
Log file should never get that...
May 12, 2009 at 8:05 am
Steve Jones - Editor (5/12/2009)
May 12, 2009 at 7:55 am
tosscrosby (5/12/2009)
Hey, watch your language!
I suspect that was nothing more than a mistype. "Tell me the procedure how to restore a DB"
May 12, 2009 at 7:52 am
RPSql (5/12/2009)
It is running since 20 hours....Any idea why it is taking so long and why it is not completed yet?
Maybe because there is corruption.
The checkDB algorithms are written in...
May 12, 2009 at 7:47 am
Any idea why allow_updates is getting set to 1? If something's messing badly with the system tables it could be the cause of the suspect status.
May 12, 2009 at 7:30 am
Please spoon-feed me...
http://www.sqlservercentral.com/Forums/Topic714789-357-1.aspx
Anyone want to take time to write a step-by-step process for restoring a database from full backups and log backups?
May 12, 2009 at 7:29 am
mrlucmorin (5/12/2009)
I guess that internally, the server "knows" which rows of TableA are included in the JOIN, though what I'd like to know is how it knows 🙂
It will start,...
May 12, 2009 at 7:27 am
venu_ksheerasagaram (5/12/2009)
Let me know how to Restore a DB using Log transaction files?
I just did.
Give me a Practical situation and step by step procedure?
Look in Books Online under RESTORE DATABASE....
May 12, 2009 at 7:25 am
Regarding future editions, there will be a SQL 2008 R2 released sometime in 2010, first CTP later this year. It's not a complete new version, more a set of add-ons...
May 12, 2009 at 7:17 am
jcrawf02 (5/12/2009)
May 12, 2009 at 7:03 am
Can you check the previous error log. Looks like the DB was suspect before the restart, need to see if there's anything there that hints as to why it was...
May 12, 2009 at 6:54 am
venu_ksheerasagaram (5/12/2009)
1)What is the use of Log shipping transaction ?
Log shipping creates a warm secondary server so that if anything happens to the primary server, apps can use the...
May 12, 2009 at 6:54 am
Samuel Vella (5/12/2009)
As far as I know, this isn't ANSI standard SQL
You are correct, it's not.
There was nothing wrong with his syntax. That first FROM is optional. These are equivalent...
May 12, 2009 at 6:51 am
Grant Fritchey (5/12/2009)
Paul White (5/12/2009)
Vinoo (5/12/2009)
May 12, 2009 at 6:45 am
Go to 2008. At this point there's no sense to upgrade to 2005. The prices of the two are the same.
If you were on 2005 I would suggest not...
May 12, 2009 at 6:45 am
Viewing 15 posts - 39,166 through 39,180 (of 49,571 total)