Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 How to open this database

Author  Topic 

karnatik
Starting Member

5 Posts

Posted - 2005-05-02 : 07:50:37
Hello friends,

I am an Indian student working in Germany as a programmer. First time am dealing with SQL Server databases. And also first time posting a message in this SQL Team forums.

Now I got a backup copy of SQL server database. I have to open this database and draw a data model diagram for that databse. but I don't have SQL server installed on my computer. what should I install on my computer to open this database.

- this is a .bak file

1. - How to open this backup database and look into the data?

I heared from some friends that it is possible to draw a data model isgram automatically with MS Visio. any one knows how to do it? or
any other way to do it.

2. How to draw a data model diagram automatically for this SQL server database?

Kiran Karnati.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-05-02 : 08:28:27
You would have to install SQL Server to be able to restore the backup file to a database. You can download a 120-day evaluation copy of SQL Server, you can find it here:

http://www.microsoft.com/sql

Once you install it, look in Books Online under "RESTORE". It would be worth your time to read Books Online before you try to get too deeply into SQL Server, so you can learn a bit about it before diving in.
Go to Top of Page

karnatik
Starting Member

5 Posts

Posted - 2005-05-02 : 09:48:16
woww thank you very much for your reply, am doing this and tell you if am succeded, thank you again, have a nice day, till then babaiii.

Kiran.
Go to Top of Page
   

- Advertisement -