Problem with simple databases

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Problem with simple databases

Problem with simple databases

Rate Topic

Display Mode

Topic Options

Author

Message

mah_j

Posted Tuesday, September 18, 2012 11:25 PM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 12:19 AM
Points: 91, Visits: 1,012

Hi

I have a database in simple recovery model (sql server enterprise edition 2008).I need its log , but because it's in simple ,i can't do.
how does Apex sql log do this with simple databases?is it possible to have logs for simple databases with SSMS?

I read that simple db s ,doesn't keep any logs so we can see that it keeps it some where which Apex can extract it.how can i have logs?

Post #1361137

anthony.green

Posted Wednesday, September 19, 2012 1:49 AM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 2:40 AM
Points: 5,075, Visits: 4,833

All databases have a log, the recovery model tells SQL how to handle the log.

Simple recovery, the log is marked as re-useable by a checkpoint which occurs at regular intervals
Bulk-Logged / Full, a transaction log backup marks the log as re-useable

What Apex is seeing is the live database log.

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1361176

mah_j

Posted Wednesday, September 19, 2012 2:23 AM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 12:19 AM
Points: 91, Visits: 1,012

tanks a lot

i'm so confused

1:in simple recovery when i shrink log file to zero i cant see the logs in fn_dblog(null, null) but still apex can show the logs,what do you mean by 'What Apex is seeing is the live database log'?

2:in full recovery,i have a full backup from 09:00 am yesterday,and a log backup from 11:00 pm yesterday,can i restore the data from 8:00 pm yesterday?
how can i obtain the right LSN?or how to restore to 8:00 pm?
i read these pages but understanding nothing Ermm

[/url]

[url=http://www.sqlservercentral.com/Forum/Topic1104430-391-1.aspx#bm1104439]

http://msdn.microsoft.com/en-us/library/ms191459.aspx
http://www.sqlservercentral.com/Forum/Topic1104430-391-1.aspx#bm1104439

Post #1361188

anthony.green

Posted Wednesday, September 19, 2012 2:37 AM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 2:40 AM
Points: 5,075, Visits: 4,833

Look at the STOPAT clause of the restore command.

So restore the full backup with NORECOVERY, then restore the log with STOPAT and RECOVERY

RESTORE DATABASE ...... FROM DISK = '...............' WITH NORECOVERY
GO
RESTORE LOG ........... FROM DISK = '...........' WITH STOPAT '2012-02-12 20:00', RECOVERY
GO

Post #1361191

Abu Dina

Posted Wednesday, September 19, 2012 2:37 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 10:26 AM
Points: 507, Visits: 2,229

mah_j (9/19/2012)

2:in full recovery,i have a full backup from 09:00 am yesterday,and a log backup from 11:00 pm yesterday,can i restore the data from 8:00 pm yesterday?
how can i obtain the right LSN?or how to restore to 8:00 pm?
i read these pages but understanding nothing Ermm

It's normal to be confused. There is so much to know before you get this right!

This link should help you:

http://www.mssqltips.com/sqlservertip/1229/sql-server-point-in-time-recovery/

-----------------------------------
http://www.SQL4n00bs.com

Post #1361192

mah_j

Posted Wednesday, September 19, 2012 3:04 AM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 12:19 AM
Points: 91, Visits: 1,012

great it works ,tanks alot both of you.

what about apex?is there any table that it reads from that?
i need to know it shows the log from where?

i think it is fn_dblog(null, null) .but when i shrink log or bakup full it shows nothing but apex still shows.
is it msdb.dbo.backupset?

Post #1361207

Abu Dina

Posted Wednesday, September 19, 2012 3:13 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 10:26 AM
Points: 507, Visits: 2,229

mah_j (9/19/2012)

Never used Apex tools I'm afraid so no idea.....Are you using ApexSQL Log?

I wonder, could it be cached information you're seeing? Maybe re-starting the tool to see if that makes any difference?

Excuse my ignorance but I've never used this tool before.

-----------------------------------
http://www.SQL4n00bs.com

Post #1361214

« Prev Topic | Next Topic »

Permissions