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

Restore SQL database (MSDE)

Hi!
We had to resoft our PC, but before we formatted the whole PC, we made a
backup of the MSDE db with OSQL (Osql "Backup database 'our dbname'...
etc.). Now, after we have installed MSDE on the "clean" PC, we're trying to
restore the db with Osql, ("Restore database 'our dbname'... etc.) but we
get the error message "The backup set holds a database other than the
existing 'our dbname' database". Both the old and the new db was created
with MSAccess, and when we try to restore with Access (adp), we get a
similar error msg.
Any ideas?
TIA
Ulf H.Read about the RESTORE command in Books Online, and especially the MOVE and
REPLACE parameters.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ulf Hansen" <someone@.somewhere.com> wrote in message news:j1OWc.2838$g%5.36571@.news2.e.nsc.
no...
> Hi!
> We had to resoft our PC, but before we formatted the whole PC, we made a
> backup of the MSDE db with OSQL (Osql "Backup database 'our dbname'...
> etc.). Now, after we have installed MSDE on the "clean" PC, we're trying t
o
> restore the db with Osql, ("Restore database 'our dbname'... etc.) but we
> get the error message "The backup set holds a database other than the
> existing 'our dbname' database". Both the old and the new db was created
> with MSAccess, and when we try to restore with Access (adp), we get a
> similar error msg.
> Any ideas?
> TIA
> Ulf H.
>|||Hi Ulf,
Thanks for using MSDN Managed Newsgroup!
Thanks MVP Tibor's greatest answer! How are things going on yours? Have you
use RESTORE successfully? I would appreciate it if you could post here to
let me know the status of the issue. If you have any questions or concerns,
please don't hesitate to let me know. I look forward to hearing from you,
and I am happy to be of assistance.
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Restore SQL database (MSDE)

Hi!
We had to resoft our PC, but before we formatted the whole PC, we made a
backup of the MSDE db with OSQL (Osql "Backup database 'our dbname'...
etc.). Now, after we have installed MSDE on the "clean" PC, we're trying to
restore the db with Osql, ("Restore database 'our dbname'... etc.) but we
get the error message "The backup set holds a database other than the
existing 'our dbname' database". Both the old and the new db was created
with MSAccess, and when we try to restore with Access (adp), we get a
similar error msg.
Any ideas?
TIA
Ulf H.
Read about the RESTORE command in Books Online, and especially the MOVE and REPLACE parameters.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ulf Hansen" <someone@.somewhere.com> wrote in message news:j1OWc.2838$g%5.36571@.news2.e.nsc.no...
> Hi!
> We had to resoft our PC, but before we formatted the whole PC, we made a
> backup of the MSDE db with OSQL (Osql "Backup database 'our dbname'...
> etc.). Now, after we have installed MSDE on the "clean" PC, we're trying to
> restore the db with Osql, ("Restore database 'our dbname'... etc.) but we
> get the error message "The backup set holds a database other than the
> existing 'our dbname' database". Both the old and the new db was created
> with MSAccess, and when we try to restore with Access (adp), we get a
> similar error msg.
> Any ideas?
> TIA
> Ulf H.
>
|||Hi Ulf,
Thanks for using MSDN Managed Newsgroup!
Thanks MVP Tibor's greatest answer! How are things going on yours? Have you
use RESTORE successfully? I would appreciate it if you could post here to
let me know the status of the issue. If you have any questions or concerns,
please don't hesitate to let me know. I look forward to hearing from you,
and I am happy to be of assistance.
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!