Monday, March 26, 2012

Is it possible to import a backup

Had sql database on a dual boot machine... backed up the sql database ...
now put sql on the windows 2003 server... not sure how to import the databas
e to the new sql server... any suggestions or links would be appreciated."Vincent Keller" <anonymous@.discussions.microsoft.com> wrote in message
news:E69894D4-2385-4242-A34A-016B2AA94462@.microsoft.com...
> Had sql database on a dual boot machine... backed up the sql database
... now put sql on the windows 2003 server... not sure how to import the
database to the new sql server... any suggestions or links would be
appreciated.
>
RESTORE DATABASE dbname
FROM wherever
WITH MOVE logical_name TO 'C:\data\whatever.mdf'
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.647 / Virus Database: 414 - Release Date: 29/03/2004sql

No comments:

Post a Comment