Hi,
Good morning to All,
I have SQL Server 2005 installed on my system. Recently I have formatted by computer. But I couldn't take backup of my data. Big loss.
For this, I've googled also. but I couldn't get clear information.
I want like the following:
I could able to backup entire the Database either into my pen-drive, or some other media.
And,latter I could able to put the Data back into my system.
Can anyone please tell how to take backup of my Data, and Restore also.
Thanks in advance,
Ashok kumar.
You can do the backup/restore using SQL Management Studio. If you are using 2005 Express Edition, you will need the Express Edition of the management studio. Do a quick search on download.microsoft.com for Microsoft SQL Server Management Studio Express (SSMSE).
Once you have it loaded, login and right-click on the database. Under 'tasks' is the option to create the backups and perform the restores.
No comments:
Post a Comment