SQL Server Performance Forum – Threads Archive
difference between back upsDear all, Greeting!!!!!!! what is the difference between Datafile backup and Database backup?
There is no concept of datafile backup in SQL server and in turn you can backup FILEGROUPS using EM – Under Backup, click File and filegroup,and then click the browse (…) button. In general BACKUP DATABASE is to create the file and filegroup backup, by specifying:
-backup device where the database backup will be written.
-FILE clause for each file to back up.
-FILEGROUP clause for each filegroup to back up. # A database backup creates a copy of the full database. Not all pages are copied to the backup set, only those actually containing data. Both data pages and transaction log pages are copied to the backup set. _________
May be the confusion came from : with datafiles (.mdf, .ndf) is posible to attach to SQL, but with database backup the only way is via restore. Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
…and for them you have to use SP_ATTACH_DB, provided they are properly detached earlier. _________