• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

SQL Guru question

E

err

Platinum Member
I have a database that I would like to restore in SQL 2000. Lets us a hypothetical example.

Database Name: dba
Old Database Name: dbb
Database Location: D:\mssql\data
Old Database Location: c:\sql2000\data

I am not familiar with query analyzer at all. What would I write in query analyzer to restore the database from my old backup file to a different database name and database location ?

Thank you for any help.

eRr
 
Yeah, I was about to say, you would need to do this from Enterprise Manager, NOT query analyzer. 😀
 
well, there is only a certain degree of possibility that you can do from enterprise manager. Writing a query through the QA gives you much stronger syntaxes and capability of restoring a database.

 
You must log in or register to reply here.

TRENDING THREADS

Back
Top