Thursday, 3 June 2010

What files are in my backup?

An oversimplified example here , but revisiting a DBA basic as moving datafiles info a new configuration.

FROM DISK = 'c:\AdventureWorks2008.bak'

This lists the file locations and sizes of data files inside a backup.
By default, i.e. without specifying WITH MOVE, these are the locations that a RESTORE operation will move data back to.

My real scenario has a fact table partitioned into years and over multiple data files.

MS SQL Tips : What is in your SQL Server backup files?

No comments: