Queries for Back up and restore the databases

Hi,
I would like to know what are the queries for back up and restore of
the DB in SQL Server.
Kindly help. Thanks in advance.
urs,
Sundar The Great!Good ol' Books Online says:
http://msdn.microsoft.com/library/d...br />
35ww.asp
http://msdn.microsoft.com/library/d...br />
25rm.asp
Only *you* know what you actually need. Unless you tell us.
ML
http://milambda.blogspot.com/

QA stuck on 'Results in Text'

How do I get it back to the default 'Results in Grid'? No matter if I
change it and close, change is and save and close, it always comes up as
"Results in Text" and has to be changed everytime I open QA.
Scott
Configure it in Tools -> Options ->Results, if you are not already doing
that. It sure remembers this setting.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Wm. Scott Miller" <Scott.Miller@.spamkillerwvinsurance.gov> wrote in message
news:OLODrcgjFHA.3348@.tk2msftngp13.phx.gbl...
How do I get it back to the default 'Results in Grid'? No matter if I
change it and close, change is and save and close, it always comes up as
"Results in Text" and has to be changed everytime I open QA.
Scott
|||Yeah, the key word is "should" but it doesn't as I said in my original post.
I have not had problems in the past. But now I am completely stuck on
Results as Text no matter how I change it.
Scott
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%239S5cugjFHA.3064@.TK2MSFTNGP15.phx.gbl...
> Configure it in Tools -> Options ->Results, if you are not already doing
> that. It sure remembers this setting.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Wm. Scott Miller" <Scott.Miller@.spamkillerwvinsurance.gov> wrote in
> message
> news:OLODrcgjFHA.3348@.tk2msftngp13.phx.gbl...
> How do I get it back to the default 'Results in Grid'? No matter if I
> change it and close, change is and save and close, it always comes up as
> "Results in Text" and has to be changed everytime I open QA.
> Scott
>
>
|||Wm. Scott Miller wrote:
> Yeah, the key word is "should" but it doesn't as I said in my
> original post. I have not had problems in the past. But now I am
> completely stuck on Results as Text no matter how I change it.
> Scott
>
Try setting the following key to 0:
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQL
Query Analyzer\Options\ResultsTab\DefResultsTarget
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||David:
That key is already set to 0 (zero). So I tried to set it to 1 and open the
app. That fixed it. Thanks for the key.
Scott
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:uLdfgamkFHA.4000@.TK2MSFTNGP12.phx.gbl...
> Wm. Scott Miller wrote:
> Try setting the following key to 0:
> HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQL
> Query Analyzer\Options\ResultsTab\DefResultsTarget
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com