How to Create a File or Filegroup Backup Using T-SQL Alternatively, you can use the T-SQL commands to create files or filegroups backup. BACKUP DATABASE [Northwind] FILEGROUP = N'PRIMARY' TO DISK = ...

allowing you to make safe backup copies or send data to branch offices. Once you disconnect a database, you must restore it from its .MDF file in a process called "attachment." SQL Server offers ...

Method 2-Recover Database from an Existing Backup If you fail to rebuild the corrupted Log files, then you can recover the SQL database from an existing backup using the below steps: First launch ‘SQL ...