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

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