Click here to Skip to main content
15,867,453 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
Is There Any Solution For Online SQL Server Backup To Local Sql Server ?
i want Automatics Backup to local system or any online solution for backup automatically after 10 to 15 minutes .

What I have tried:

i did not found any solution after very long search
Posted
Updated 7-Mar-22 0:19am

1 solution

"Backing up" your database every 10 to 15 minutes is a very bad idea. It won't be long before it just won't be usable because all it will be doing is backing up.

What you probably want is "database synchronisation" - try researching that instead

E.g. https://www.sqlshack.com/what-is-sql-data-sync/[^]
What is SQL Data Sync for Azure? - Azure SQL Database | Microsoft Docs[^]
 
Share this answer
 
Comments
Naqash Younis 7-Mar-22 7:07am    
WHat's the best method or solution for Sync
Richard Deeming 7-Mar-22 7:22am    
You wouldn't want to do a full backup that frequently, but a transaction log backup every 10-15 minutes seems perfectly reasonable. :)
Naqash Younis 7-Mar-22 7:27am    
need method
CHill60 7-Mar-22 7:58am    
There are literally instructions on how to do it in the second link I gave you!
Naqash Younis 7-Mar-22 13:25pm    
But i want free solution azure is paid solution

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