I need help!!!
I have to do backups of production database
and restore them on the backup server.
The database should be updated from backups every 20-30 miniets
and this database on the backup server should be operational.
How is it possible to do? There are a lot of problems:
1.I can’t run backup if the database is in use.(Operational???)
2. I load full backup(from Sunday) and every 20-30 miniets ( till the next full backup)
I have to restore on backup server Transaction LOG backups.
To be able to load Transaction LOG backups
I have to specify WITH NORECOVERY or WITH STANDBY for all but the final step.
It means that nobody will not be able to work with this database.