how to backup SQL database of a time period

Question

4.00/5 (1 vote)

See more:

SQL

Is there any way to backup SQL Database of today only or of between dates only instead of full backup ??

Posted 20-Jan-16 18:46pm

Madhuri Gamane

Updated 19-Feb-16 20:17pm

Add a Solution

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

2 solutions

Add a Solution

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

Member 12001186 · Answer 1 · 2016-01-22T11:43:00

Solution 1

No there is nothing out of the box what will enable you. The closest you can get is do a Point in Time recovery.

Posted 22-Jan-16 11:43am

Member 12001186

JasonClark03 · Answer 2 · 2016-02-19T20:17:00

Solution 2

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.

Posted 19-Feb-16 20:17pm

JasonClark03

how to backup SQL database of a time period

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

how to backup SQL database of a time period

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us