Abu Dina (8/30/2012)What I want to say to the manager is that doing a full backup while people are still working is not an issue. SQL Server has the intelligence to backup the data as well as the necessary transactions so that doing a restore brings back the database in a consistent state.
correct .
Abu Dina (8/30/2012)
The days of offline backups are long gone surely?! Or am I missing something here?
Hope offline backup you are specifying backup during non-productio hours.
It is purely based on your company requirement, in our company we have scheduled full backup daily during non- production hours and log backup every hour , so my data loss is max 1 hour. for us the data loss has to be minimal.
Regards
Durai Nagarajan