Restore the database

I have abackup of an SQL Server database named "UserData.bak" now i wantRestore this backup to my SQL Server.

pls tell me whole process.

Can i also restore it to MS-Access, if possible pls do let me know.

Thanks

Open the SQL Enterprise Manager. Select Import Data and this will start the wizard just read and follow. It must be simple.

|||

ravipahuja1:

Open the SQL Enterprise Manager. Select Import Data and this will start the wizard just read and follow. It must be simple.

I am using SQLEXPRESS 2005 server. then what's the process

|||

You must first download the sql express management studio and then use the standard restore process. Download SQL Express management studio herehttp://msdn.microsoft.com/vstudio/express/sql/

|||

richardsoeteman.net:

You must first download the sql express management studio and then use the standard restore process. Download SQL Express management studio herehttp://msdn.microsoft.com/vstudio/express/sql/

Yaa i have but pls tell the process.

|||

Hi sawan.singh,

I've reproduced the process in Sql Server 2005, and i think the process should be similiar for Sql Express Management Studio(or almost the same). So, just give you some advices and you can take as a reference.

1.Open your Sql Express Mangement Studio and right click your database that you need to restore;

2.From the pop-up menue, clickTasks--> Restore--> Databases, this should open a restoration wizard;

3.In the wizard window, select your backup file in the "Specify the source and location of backup sets to restore" section and click OK;

4. After a few minutes (depends on how large your database is) a message box will pop up and say,"restore succeed"

BTW, you can also refer to this link in msdn:http://msdn2.microsoft.com/en-us/library/ms177429.aspx

Hope my suggestion helps

sql