Will Altering and Modifying tables during backup result in a corrupted server after the restore?

2018-05-21 Thread Yashwanth Govinda Setty
Hi All, We are trying this scenario: Here are the steps being done: 1. Creating a big table. Identify the physical file on the disk. 1. While backup process is backing up a file associated with the table - update the rows , add a column. 2. Restore the server with transaction logs

Recommended way to copy database files on Windows OS (to perform file system level backup)

2018-05-14 Thread Yashwanth Govinda Setty
Hi all, We are facing this problem while performing file system level backup of database files: As each database will form a directory inside Base directory which consists of files representing the tables, when some tables are dropped during backup, We get error while copying since the files do