Viewing 15 posts - 33,286 through 33,300 (of 49,552 total)
What is the exact script that is running to backup the log?
March 30, 2010 at 8:46 am
Click the 'Edit Subscriptions' link (top right). There you can select and remove whichever subscriptions you like.
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
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...
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...
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...
March 30, 2010 at 2:55 am
john.arnott (3/29/2010)
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.......
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...
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...
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...
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?
March 29, 2010 at 1:38 pm
What is the order of columns in the existing index? Post the index's definition.
March 29, 2010 at 1:37 pm
First and most important question.
Was the database in full recovery model?
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...
March 29, 2010 at 9:03 am
Viewing 15 posts - 33,286 through 33,300 (of 49,552 total)