Viewing 15 posts - 37,516 through 37,530 (of 49,552 total)
However the transaction log cannot be truncated (by a log backup or checkpoint) while a full backup is running.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2009 at 4:22 pm
Lowell (7/21/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2009 at 4:18 pm
JohnSQLServerCentral (7/21/2009)
I've been at this for 20 years, remember DOS and dBase?
Very well, thank you. The first PC that I built for myself was an 8086 (XT)....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2009 at 4:12 pm
The only thing I can see at the moment that looks suspect is that all of your indexes have been set to not auto update stats. Is there a reason...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2009 at 3:57 pm
Glad to hear that you've resolved the problem.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2009 at 3:34 pm
Ankur Bajaj (7/21/2009)
Heres the solution I have tested and which is...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2009 at 3:25 pm
JohnSQLServerCentral (7/21/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2009 at 3:24 pm
Kit G (7/21/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2009 at 2:56 pm
Doing that the transaction remains open, holding locks, until the connection is closed, at which point the transaction will rollback. It is bad practice, and it's got some subtle side...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2009 at 7:32 am
Mainstream support for SQL 2000 ended last year August. Extended support (if you're paying for it) ends in 2013
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2009 at 7:23 am
Saw Startrek. Loved it. Good story, emotional scenes (Spock's mother), tension, explosions, etc. What really clinched it for me was all the little bits, sayings, mannerisms that linked back to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2009 at 7:19 am
praveen_manyam (7/21/2009)
Well you got the link,,, i did'nt, i got tht from my inbox from one of my friends
You should still acknowledge that what you're posting is not your own...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2009 at 7:14 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/Topic756507-148-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2009 at 6:24 am
Steps 2 and 6 are not required as, once you've backed up the tail of the log, you can restore over the existing database.
Problem is that the original poster said...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2009 at 6:10 am
Not sure I understand what you want.
If you want the date of 5 days ago, this will get it. If you want something else, please explain further what it is...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2009 at 6:06 am
Viewing 15 posts - 37,516 through 37,530 (of 49,552 total)