Re: Backup SQL Server

Tech-Archive recommends: Speed Up your PC by fixing your registry

Jos Roijakkers (j.roijakkers@xxxxxxxxxx) writes:
I use MS SQL Server Express 2005 (the 'unpaid' version). I managed to
create a backup of my database using an option onder 'Server Objects'.
My questions:

1. Is it possible to schedule this backup or is this only a feature of the
full version of MS SQL Server?

SQL Express does not come with SQL Server Agent. But isn't there some sort
of scheduler built-in in Windows? You spark off a BACKUP command from
OSQL that you schuedule.

2. How can I restore a database from a backup?

You use the RESTORE command, which is documented in Books Online. The
simple operation is:

RESTORE DATABASE db FROM DISK = 'c:\backup\yourbackup.bak'

It gets more complicated if you want to restore the database under a
different name.

There is also a dialogue for restoring databases in SQL Server Management
Studio Express. (At least I assume there is.)


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... with volume Shadow Copy error 800423f4. ... You back up data from a volume that contains a Microsoft SQL Server ... The recovery model of the SQL Server database is configured to use an ... It just ensures backup will continue without reporting the error. ...
    (microsoft.public.windows.server.sbs)
  • Re: Start SQLServerAgent job Synchronously
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > call and the caller resumes processing as soon as the call is made. ... > I have a set of SQLServerAgent jobs, each of which runs a BACKUP DATABASE ...
    (microsoft.public.sqlserver.server)
  • Re: Start SQLServerAgent job Synchronously
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > call and the caller resumes processing as soon as the call is made. ... > I have a set of SQLServerAgent jobs, each of which runs a BACKUP DATABASE ...
    (microsoft.public.sqlserver.programming)
  • Re: "Best Practices" way to distribute MSDE
    ... > Restore a users's selected backup. ... for dayly house-keeping I do usually provide scripted job for database ... that file copy operation (not SQL Server backup!) can be performed.. ... my personala advice is to perform dayly house-keeping actions ...
    (microsoft.public.sqlserver.msde)
  • Re: NT Backup Causes Server to Hang
    ... Thanks for using the SBS newsgroup. ... You back up data from a volume that contains a Microsoft SQL Server ... The recovery model of the SQL Server database is configured to use an ... It just ensures backup will continue without reporting the error. ...
    (microsoft.public.windows.server.sbs)