Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Problem with simple databases Expand / Collapse
Author
Message
Posted Tuesday, September 18, 2012 11:25 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, September 27, 2014 3:29 AM
Points: 108, Visits: 1,098
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
Posted Wednesday, September 19, 2012 1:49 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:19 AM
Points: 5,216, Visits: 5,109
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
Posted Wednesday, September 19, 2012 2:23 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, September 27, 2014 3:29 AM
Points: 108, Visits: 1,098
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

[/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
Posted Wednesday, September 19, 2012 2:37 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:19 AM
Points: 5,216, Visits: 5,109
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




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 #1361191
Posted Wednesday, September 19, 2012 2:37 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, September 19, 2014 3:37 AM
Points: 708, Visits: 3,288
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


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/


---------------------------------------------------------


It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Post #1361192
Posted Wednesday, September 19, 2012 3:04 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, September 27, 2014 3:29 AM
Points: 108, Visits: 1,098
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
Posted Wednesday, September 19, 2012 3:13 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, September 19, 2014 3:37 AM
Points: 708, Visits: 3,288
mah_j (9/19/2012)
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?


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.


---------------------------------------------------------


It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Post #1361214
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse