RESTORE databaseName FROM DISK='filename'
Dig Deeper on Microsoft SQL Server 2005
Related Q&A from Greg Robidoux
Avoid restoring your SQL Server database to solve the SQL Server error message "server out of memory." The problem could be the memory settings. Continue Reading
Find out how to restore data from a corrupt database. Continue Reading
Have you upgraded to SQL Server 2005 and need to configure log shipping between SQL Server 2000 and SQL Server 2005? Learn about that possibility. Continue Reading