Click here to Skip to main content
15,902,938 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more:
Is there any way to backup SQL Database of today only or of between dates only instead of full backup ??
Posted
Updated 19-Feb-16 20:17pm
Comments
Herman<T>.Instance 21-Jan-16 4:50am    
it is just backuping the underlying files. It does not check changes by date.
jaket-cp 21-Jan-16 5:35am    
You may be interested in or maybe not - but have a read of:
Restore a SQL Server Database to a Point in Time (Full Recovery Model)
https://msdn.microsoft.com/en-us/library/ms179451.aspx

No there is nothing out of the box what will enable you. The closest you can get is do a Point in Time recovery.
 
Share this answer
 
The
SQL
sys.dm_exec_requests
DMV has some columns that can be helpful in predicting how much time a database will take in its backup.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900