Microsoft SQL Server 2008
--
Questions
--
Followers
Top Experts
SQL Server 2005/2008 backups
When you do a full backup each morning(4AM-takes 1 hour to finish) and NO log backups (recovery set to full) and you want to do a point in time recovery from 8AM this morning what do you do? Remember I have no log backups just a full from 4AM..
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
This is not my answer.. My question is, if you do not do log backups and you ONLY do a full backup can you do a point in time?
SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
What about the log from 4:AM to 8:AM? Can't I recover this? (BTW I'm a developer not a DBA) I thought backing up is like making a copy.. I guess transactions do not stay in the log?
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
If the recovery model is full, you can take a log backup now and use it to a point-in-time recovery to any time you would like [unless you've explicitly done something at some point to effectively truncate the log].
However, if you have not been doing regular log backups, the log backup could be extraordinarily large relative to the db.
You can see the size of the log file, and how much of it is used, by running these commands:
USE <db_name>
EXEC sp_helpfile
DBCC SQLPERF ( LOGSPACE )
However, if you have not been doing regular log backups, the log backup could be extraordinarily large relative to the db.
You can see the size of the log file, and how much of it is used, by running these commands:
USE <db_name>
EXEC sp_helpfile
DBCC SQLPERF ( LOGSPACE )
SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Thanks!
Microsoft SQL Server 2008
--
Questions
--
Followers
Top Experts
Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the Always On technologies and support for unstructured data types.