Hello, say I have the following scenario:
1 - Perform a long running restore of a large DB (from a backup of another SQL Server as source) with brand new name (this DB doesn't yet exist on target SQL Server) i.e. starts at 9pm takes two hours to complete restore
2 - We have a scheduled nightly SQL Agent DB backup job starts at 10pm on this target server that the long restore is running so both restore and backup processes would overlap
Could this be potentially dangerous and cause DB corruption or any other things I should be concerned/aware of?
Thanks in advance.