Thursday, June 3, 2010

What files are in my backup?

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

RESTORE FILELISTONLY
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: