Moving SQL Server Databases and a few random thoughts on moving to SQL Server 2005
Posted by: Rick Strahls WebLog,
on 13 Feb 2006 |
View original | NEW Bookmarked: 0 time(s)
Sql Server Backup and Restore operations are a drag. Well sort of. I've been moving over my databases from my old development machine to my new machine and the process is a lot more painful than it should. I can't quite figure out how to easily move files between two machines, but the process I've been using goes something like this:
Do a full backup to file
Then restore from the backup a query window like this. First:
RESTORE FILELISTONLY
FROM DISK = 'c:\sqlbackups\webstore.bak'
to...