Tips and Tricks in a world of Mix

Archive for the ‘sql server’ Category

Database (mdf ) cannot be opened due to inaccessible files/insufficient memory/disk space.

 

If the database is inaccessible and received the error mentioned below through MSSQL Server Management studio:

Please follow the steps mentioned below:
1. Make sure that the Windows server has got enough disk space.
2. If the disk space is ok, then login to the MSSQL Server Management studio.
3. Select the particular database and right click on it. Click on "Detach" option to detach the database from the MSSQL management studio.
(Before that make sure that you have the backup of the database or a MDF file)
4. The database will be removed.
5. Click on Databases, right click on it and select the option of "Attach".
6. Click on Add to attach the MDF file of the database.
7. Click Ok.

Advertisements

The Northwind and pubs sample databases into Sql Server 2008

Download the databases

image

Install the msi file.

The DB-es are installed in your C:\SQL Server 2000 Sample Databases

You can either move the MDF files to Sql Server 2008 DB Directory , or use it from the original installation folder. C:\SQL Server 2000 Sample Databases

Enter Management Studio

image

Right Click on Databases and Attach..

image

Press Ok and Ok .

Do it with each MDF you want to use and you’re done .

Tag Cloud

%d bloggers like this: