Re: ISV Using SQL Authentication - a login concern

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 05/27/04 

Date: Thu, 27 May 2004 11:21:17 -0400

SQL Backup and restore are done online. No restart is needed. It sounds
like you really need to read the BOL (Books On-Line) section on backup and
restore. You can download the latest edition from:

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp 

-- 
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"dev" <anonymous@discussions.microsoft.com> wrote in message
news:ED26EE2A-1437-4B27-96E9-84547DC52B2E@microsoft.com...
> Thanks Geoff, some more question (sorry about so many qs):
> -do I need to start the SQLServer service before backing up or restoring
from my app. (generally for simple db work there is no need to start the
service)
> -Is it best to store the backup and restore T-SQL command in stored
procedures.  If yes then I will keep them in my app's database.  But if I
want to backup Master db too then is it ok to say "Use Master" in stored
procedure which is residing in my app's db.
>
> I am sorry if these questions have too simple reply.  I am learning (fast)
>
> Thanks

Relevant Pages

  • Re: SQL backup questions
    ... I support the Professional Association for SQL Server ... Copy DB is functionally the same as Backup and Restore. ...
    (microsoft.public.sqlserver.server)
  • Re: SBS Sharepoint (CompanyWeb) DR restore process
    ... If your site does not contain any custom web parts (which have to be installed on the new server) the move should be straight forward. ... Copy the backup file from the old server to the new. ... the process to perform a backup and restore of the sharepoint component of SBS. ... However, most of the documentation I've found refers to scenario's involving MSDE ONLY, and specifically mention the process is not identical for scenario's where full SQL is installed. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Litespeed
    ... I tested SQL Litespeed's backup and restore capabilities against that of the ... The first database, 'BINARY', had a single table with a single BINARY ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server Log restore error
    ... got the same message when I tried to recover the backup log by run the SQL ... > RESTORE LOG is terminating abnormally. ... The SQL script I was running is the same. ... > --Restore the full database with No recovery ...
    (microsoft.public.sqlserver.tools)
  • Re: Backup and Restore
    ... you can use an app by webfox inc. called Backup ... STSADM backs up the entire Site Collection. ... will not need an SQL backup to restore your content. ... site collections you'll have to either back up SQL databases, ...
    (microsoft.public.sharepoint.windowsservices)