Backing up SQL database
Just don't want to forget this again....
RESTORE FILELISTONLY
FROM DISK='E:\Share\TamTools200611230902.bak'
RESTORE DATABASE TamTools
FROM DISK = 'E:\Share\TamTools200611230902.bak'
WITH MOVE 'TAMTools_Data' TO 'd:\data\TamTools.mdf',
MOVE 'TAMTools_Log' TO 'd:\data\TamTools.ldf'
GO
RESTORE FILELISTONLY
FROM DISK='E:\Share\TamTools200611230902.bak'
RESTORE DATABASE TamTools
FROM DISK = 'E:\Share\TamTools200611230902.bak'
WITH MOVE 'TAMTools_Data' TO 'd:\data\TamTools.mdf',
MOVE 'TAMTools_Log' TO 'd:\data\TamTools.ldf'
GO