Can Full backup and Transaction log backup run simultaneously...When we schedule the backups for the databases as per the disaster recovery policies of our company, as a DBA we may get a doubt --can a full or transaction log backup conflict with other backups?...
In earlier versions of SQL Server like 2000, a backup will not start until the earlier backup completed. Whereas this constraint is removed in the later versions of SQL Server.
In SQL Server 2005 and above we can run the full backup and transaction log backup simultaneously. This will effect in lot of I/O operations. There will be no locking kindof activity happens when both backups got fired simultaneosly. But backing up of database will take longer time than usual.
In earlier versions of SQL Server like 2000, a backup will not start until the earlier backup completed. Whereas this constraint is removed in the later versions of SQL Server.
In SQL Server 2005 and above we can run the full backup and transaction log backup simultaneously. This will effect in lot of I/O operations. There will be no locking kindof activity happens when both backups got fired simultaneosly. But backing up of database will take longer time than usual.
