Open database .mssql type

MrFantastic
MrFantastic used Ask the Experts™
on
Hi
I have a database file type .mssql .50 mb
What is the easiest way to open/convert this to access database?

Have SQL 2005, 2003 server with access available.
Br
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
By default SQL Server files are *.mdf (data) and *.ldf (logs).
In SQL Server Management Studio, right-click in Databases and choose Attach Database.

Author

Commented:
Hi
Thanks for your'e reply.
Tried attaching but get error. Unable to attach.
The file extension on the database is .mssql not mdf.

Any other ideas? Is it possible this base originates from mysql or similar.
Im a bit lost when it comes to these things, google wasn't helpfull either.

Br
IT Engineer
Distinguished Expert 2017
Commented:
SQL Server database is formed at least by 2 files (.mdf and .ldf), so even the file you have it's one of those files you still need another one. Without that you can't do nothing with the file you have.

Where you got that file from? There's a chance that you have a backup file from a database (usualy it's .bak extension) but you can verify that trying to restore (In SQL Server Management Studio, right-click in Databases and choose Restore Database).

Good luck

Author

Commented:
Turns out that it was a sql backup from SQL server 2000.
Managed to do a restore by query restore.
Using this guide: http://blogs.techrepublic.com.com/window-on-windows/?p=454

All well, thank you for assisting.

Br

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial