Backup and Restore in SQL server

Question

5.00/5 (2 votes)

See more:

SQL-server-2000

SQL-Server-2005

, +

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..

Posted 22-Aug-11 0:29am

mottudeepu

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Pravin Patil, Mumbai · Answer 1 · 2011-08-22T01:14:00

Solution 3

For more information on SQL Information Schema, you can refer :

1. http://weblogs.asp.net/jgalloway/archive/2006/07/07/455797.aspx
2. http://www.mssqltips.com/tutorial.asp?tutorial=179
3. http://www.alberton.info/sql_server_meta_info.html

Hope this helps.
All the best.

Posted 22-Aug-11 1:14am

Pravin Patil, Mumbai

OriginalGriff · Answer 2 · 2011-08-22T00:35:00

Solution 1

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!

Posted 22-Aug-11 0:35am

OriginalGriff

Comments

mottudeepu 22-Aug-11 6:42am

Ok.. new question..

what is information schema in SQL Server..

OriginalGriff 22-Aug-11 6:45am

Google! http://www.google.co.uk/search?sourceid=chrome&ie=UTF-8&q=information+schema+in+SQL+Server

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..

Pravin Patil, Mumbai 22-Aug-11 7:12am

Buddy, Information schema is just a view that is there in each database. There is not need to take explicit back up of Information Schema. Hope this solves your query.

mottudeepu 22-Aug-11 7:34am

Thank you sir.. Have a nice day..

Toniyo Jackson · Answer 3 · 2011-08-22T00:41:00

Solution 2

Read this article.

http://technet.microsoft.com/en-us/library/cc966495.aspx[^]

http://sqlserverdatarecovery.com/sql_backup_restore_feature.html[^]

Posted 22-Aug-11 0:41am

Toniyo Jackson