RE: Backup

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Evan Nelson (EvanNelson_at_discussions.microsoft.com)
Date: 12/06/04 

Date: Mon, 6 Dec 2004 12:15:04 -0800

You want to choose the "backup database" option. "Generate an sql script"
doesn't backup anything. It just creates a script that you can run to
recreate your database. If you don't care about the data, I suppose the
script might be enough for you.

"Preeta" wrote:

> I need to backup a database including the stored procedures.When i right
> click on the database,it gives me the option to backup database.There is also
> another option to generate an sql script.Which one am i supposed to choose?

Relevant Pages

  • Re: Backing Up Stored Procedures
    ... SQL Script. ... Here you can script them all or just selected ones. ... > We do not need some of the default stored procedures. ... >>Backup the database which contains the stored procedures. ...
    (microsoft.public.sqlserver.security)
  • RE: skip db offline run job backup
    ... NOFORMAT, NOINIT, NAME = N'NOME FILE DB BACKUP', SKIP, REWIND, NOUNLOAD, ... Check out http://ola.hallengren.com/, a very handy script. ... offline I blocks the execution of the job, how can I change the query to the ...
    (microsoft.public.sqlserver.server)
  • Feedback on backup script
    ... The one problem I have is that the script keeps stopping at lines 633,635 and or 637 with the error "Path Not Found" I have emailed the original author for help but haven't heard back yet. ... I was just wondering if the problem could be that the account running the script doesn't have correct permissions to a share/directory/file that it's trying to backup? ... ' always one less than the actual number of folders. ... ' Show the user free space info on all available disk drives ...
    (microsoft.public.scripting.vbscript)
  • Re: Enterprise Manager Newbie Question
    ... a SQL backup is not a simple copy of the database files. ... Is it possible to write a script that one could run from a workstation and ...
    (microsoft.public.sqlserver.tools)
  • Re: xcopy and vbscript
    ... It takes about 5-6 minutes to backup approximately ... A copy of the script is below for reference. ... ObjShell.Popup strMessage, 5, "Backup Complete", OK_Button ... Dim sSrc, sDest ' as string ...
    (microsoft.public.scripting.vbscript)