Daily SQL database restore issueHi Team,
just one clarification about sql server restore database as daily basis. i have two servers like Primary and secondary server. primary server backup file .bak stored in one shared location.
i am goint to create one sql job to restore the primary database's backup to secondary server. so i will write one sql job and its run daily after business hours and restore the database into secondary server.
is this possible to update only updated records on secondary server?.
can you please tell me the better option. i want to make it active both.