Click here to Skip to main content
15,849,494 members
Please Sign up or sign in to vote.
5.00/5 (2 votes)
Hai all,

I have some doubt.
I wish known about Back up and restore in SQL-Server. and i have some questions?

1)What is actually backup and restore..?
2)What is advantage of Backup..?
3)what is happening in backup..?
4)What are things which is restoring..?

while searching in google i am not getting the answer for these questions..

wish to know more about it..?

please help me..

Share this answer
Back up means to copy the data to a secondary location, so that if you have a problem you can use it to RESTORE the data as it was when the backup was taken. A general rule of thumb is: Take backups, regularly. The most important backup is the one you didn't take. You may never need a backup, but it is absolutely certain that if you do not have a backup, you are going to need one!

Restore can be variable: restore some or all of the data. It can restore to exactly where you were, or it can restore only that information that you know you need.

It's like writing a large Word document: You save it regularly in case the power fails. Because it will, the day you don't save!
Share this answer
mottudeepu 22-Aug-11 6:42am    
Ok.. new question..

what is information schema in SQL Server..
OriginalGriff 22-Aug-11 6:45am    
Pravin Patil, Mumbai 22-Aug-11 6:46am    
An information schema view is one of several methods SQL Server provides for obtaining metadata & Metadata is data about data.
It seems like Google is blocked on your system. Why don't you try Bing or any other search engine, you will get better answers.......... Trust me.....
mottudeepu 22-Aug-11 6:48am    
One more and the last question
Is it possible to take the backup of information schema..?
if possible how..?
mottudeepu 22-Aug-11 6:57am    
Need a good tutorial link.. please help..

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900