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 2008 Forums
 Other SQL Server 2008 Topics
 SQL 2000 mdb & ldb for SQL 2008

Author  Topic 

ursri
Starting Member

1 Post

Posted - 2011-08-16 : 03:12:22
A dump of sql 2000 mdb and ldb files exists without MS SQL 2000 engine. How best these mdb and ldb to be made active in MS SQL server 2008 without backup and restore technique?

Thanks in advance for any help.
- ursri

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-08-16 : 05:51:38
Copy them to the 2008 server, open management studio and look for the attach database command.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2011-08-16 : 23:01:40
And pray that the database was shut down cleanly before copying the files - or backing them up with file based backup utilities.
Go to Top of Page
   

- Advertisement -