Viewing 15 posts - 33,286 through 33,300 (of 49,552 total)
What is the exact script that is running to backup the log?
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
March 30, 2010 at 8:46 am
Click the 'Edit Subscriptions' link (top right). There you can select and remove whichever subscriptions you like.
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
March 30, 2010 at 8:41 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/Topic892583-162-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
March 30, 2010 at 6:38 am
If you want to take it to the PASS board, have a chat first with Kevin Kline (I know he's not on the board any longer). He was involved last...
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
March 30, 2010 at 6:18 am
durai nagarajan (3/30/2010)
No log backup taken. No truncation also done.
Are you absolutely sure? Did you check the SQL error log?
Full recovery and no log backups will result in a transaction...
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
March 30, 2010 at 3:38 am
WayneS (3/29/2010)
dma-669038 (3/29/2010)
...found ... to be an MVP whose title was revoked in 2007.
Okay, I did a little bit of a search to find lists of revoked MVPs. Where do...
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
March 30, 2010 at 2:55 am
john.arnott (3/29/2010)
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
March 30, 2010 at 2:50 am
Alvin Ramard (3/29/2010)
hmmm, Gail, in Compatability Level thread, SQL 2009? 🙂(We'll assume it was a simple typo)
aka SQL 2008 R2 early release edition. 😀
That's from replying late at night.......
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
March 30, 2010 at 2:43 am
Ok, great.
Were there any log backups taken between the time of the full backup and the time that the mdf was deleted?
Were there any explicit log truncations? (switch to simple...
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
March 30, 2010 at 2:40 am
Yes, but it's not date-based.
SQL Server 2005 does not support compatibility level 65 (SQL Server 6.5)
SQL Server 2008 does not support compatibility level 70 (SQL Server 7)
p.s. Please in future...
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
March 29, 2010 at 2:00 pm
Brandie Tarvin (3/29/2010)
Right click the database, go to Properties. Check the Options page in the popup window. Does the second line (Recovery Model) say Simple, Bulk-Logged, or Full?
That may well...
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
March 29, 2010 at 1:44 pm
durai nagarajan (3/29/2010)
yes it is a full backup
I'm not asking what the backup was.
What recovery model was the database in? Simple, bulk logged or full recovery?
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
March 29, 2010 at 1:38 pm
What is the order of columns in the existing index? Post the index's definition.
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
March 29, 2010 at 1:37 pm
First and most important question.
Was the database in full recovery model?
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
March 29, 2010 at 9:39 am
SQL doesn't keep historical logs for this kind of thing by default. If you did not have a trace running at the time, there's no way to find out who...
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
March 29, 2010 at 9:03 am
Viewing 15 posts - 33,286 through 33,300 (of 49,552 total)