Viewing 15 posts - 36,211 through 36,225 (of 49,562 total)
Philip Millwood-419646 (10/20/2009)
2.1 billion transactions rolled forward. 34 rolled back.
If I may suggest...
Do some ongoing monitoring on the frequency and duration of the checkpoint operations. With a default recovery...
October 21, 2009 at 12:48 am
Jeffrey Williams-493691 (10/20/2009)
October 21, 2009 at 12:47 am
Shark Energy (10/20/2009)
How do you all go about rolling back to Server A after a period of time of using the Server B Recovery box?
Depends on what High Availability technology...
October 20, 2009 at 3:08 pm
Agreed. Interviews that I did for admins I rather ask for two types of SQL backups.
October 20, 2009 at 8:49 am
October 20, 2009 at 8:47 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/Topic805754-386-1.aspx
October 20, 2009 at 8:42 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/Topic805754-386-1.aspx
October 20, 2009 at 8:40 am
steveb. (10/20/2009)
GilaMonster (10/16/2009)
Index types. Never yet found someone who could tell me two types and the differences between them
Seriously? I find this a bit worrying, ...
October 20, 2009 at 8:26 am
I've seen a case (posted here actually) where someone implemented the recommended indexes and performance degraded 40%.
I have a client that ran DTA, implemented all of it's recommendations and now...
October 20, 2009 at 8:26 am
Bru Medishetty (10/19/2009)
Well, according to my knowledge, SQL Server uses round robin procedure.
If there are multiple log files, they are used in a round-robin approach, but not the data...
October 19, 2009 at 10:35 pm
SQL uses a proportional fill algorithm if there are two data files in a filegroup. So if there are two files (the same size), both empty, the table/index will be...
October 19, 2009 at 10:33 pm
Philip Millwood-419646 (10/19/2009)
By the same token, I'm guessing that replication is part of why the log file recovery is taking so long based on a couple things I've found.
Shouldn't be....
October 19, 2009 at 10:18 pm
Because seeks are not always optimal, especially when the actual data row is required (as in an update or a non-covering nonclustered index) and the rows affected is a significant...
October 19, 2009 at 10:14 pm
How big is your log file? Do you perhaps know how much of it was active before the restart?
For that matter, how big's the data file?
Have you changed recovery interval...
October 19, 2009 at 2:30 pm
Adam Bean (10/19/2009)
GilaMonster (10/19/2009)
What happens if you try and start SQL from the command line? For the default instance, go to the directory with the executable and just run sqlservr.exe
Hi...
October 19, 2009 at 10:34 am
Viewing 15 posts - 36,211 through 36,225 (of 49,562 total)