Click here to Skip to main content
15,846,211 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi,

I have some databases to take backup, I don't want to take all. Whichever the table got updated or modified those databases only I want to take the backup. Please suggest me how to take using query or using other technology. Thanks in advance. :cool:
Posted

The easiest way is taking incremental backup of transactional log. So you will create a full backup (lets say once a week) and thereafter transactional log backup, which you can schedule each xx minutes.
 
Share this answer
 
Comments
Kiran B S 1-Oct-10 4:57am    
I think your answer will workout for me. Could you explain me in deep or give some blog link regarding this issue please.
voloda2 1-Oct-10 5:28am    
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/e7a6b542-65df-43e3-b211-03ecdabb2fba
You could use the query for each database.

SQL
SELECT
        [name]
       ,create_date
       ,modify_date
FROM
        sys.tables


or perhaps define modified time frame,

SQL
SELECT
        [name]
       ,create_date
       ,modify_date
FROM
        sys.tables
WHERE
        modify_date > DATEADD(day,-30,GETDATE())


And take the Backup of the DB which have modified date between expected range.

Please vote and Accept Answer if it Helped.
 
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