Look at the RESTORE DATABASE command in BOL. Why do you only suppose it is
a backup?
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Arijit Mahapatra" <arijitm (AT) catsglobal (DOT) co.in> wrote
Quote:
Hi ,
I have a file presumably backup of a User database from a SQL Server(2k)
database. I want to load/restore that in a local SQL Server to be able
to see the table , views , etc present in the database.
How do I do that ?
Thanks,
Arijit
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it! |