SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Problem with simple databases


Problem with simple databases

Author
Message
mah_j
mah_j
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1407 Visits: 1262
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?
anthony.green
anthony.green
SSC Guru
SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)

Group: General Forum Members
Points: 53462 Visits: 8000
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.



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
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger


mah_j
mah_j
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1407 Visits: 1262
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 nothingErmm

[/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
anthony.green
anthony.green
SSC Guru
SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)SSC Guru (53K reputation)

Group: General Forum Members
Points: 53462 Visits: 8000
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



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
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger


Abu Dina
Abu Dina
SSCertifiable
SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)

Group: General Forum Members
Points: 6197 Visits: 3325
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 nothingErmm


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
mah_j
mah_j
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1407 Visits: 1262
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?
Abu Dina
Abu Dina
SSCertifiable
SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)

Group: General Forum Members
Points: 6197 Visits: 3325
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search