how to back and restore database in sqlce

for Backup:
right click over database then go over Task and then To Backup

for Restore:

right click over database then go over task and then restore

Thanks & Regards,
Alokssm

Chaithragm, if this helps please login to Mark As Answer. | Alert Moderator

Hello

Backup

Open Sql Server Management Studio

Expand the databases.

Right Click on the Database -> Select Task -> Backup -> Choose Location -> Givename.bak

Restore

Create a New Database

Then right click on the new database -> Select Task -> Restore -> Choose the .bak file and then check the restore button and the go to options on left corner and select overwrite option and click ok

Regard's
Raj.Trivedi
"Sharing is Caring"
Please mark as answer if your Query is resolved

Chaithragm, if this helps please login to Mark As Answer. | Alert Moderator

im asking back up and restore in sqlCE compact edition

Chaithragm, if this helps please login to Mark As Answer. | Alert Moderator

I think u need to check out these links...

http://social.msdn.microsoft.com/forums/en-US/sqlce/thread/79d2f8a2-1366-4d14-8c61-220f47183368/

http://msdn.microsoft.com/en-us/library/ms172411.aspx

http://social.msdn.microsoft.com/forums/en-US/sqlce/thread/79d2f8a2-1366-4d14-8c61-220f47183368/

"I cannot teach anybody anything. I can only make them think"~ Socrates
Thanks And Regards

Chaithragm, if this helps please login to Mark As Answer. | Alert Moderator

It's the actual way Alok has suggested, click on database - scroll to task and Backup, similarly for restore.

Chaithragm, if this helps please login to Mark As Answer. | Alert Moderator