Re: Backup confusion

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

Thans Arnie and Erland

Samuel

"Erland Sommarskog" <esquel@xxxxxxxxxxxxx> wrote in message
news:Xns9806B60897966Yazorman@xxxxxxxxxxxx
Samuel Shulman (samuel.shulman@xxxxxxxxxxxx) writes:
I create a new backup device that works every x time and I want to modify
this backup and I can't find it anywhere using the Enterprise Manager

I also don't really understand what is the difference between backup
device and backup a database (to a file) I assume that in both cases the
backup of the database will go to a file

Backup devices are essentially leftovers from the days when you normally
backup the database to tape. You can still use them as an alias for a
certain disk location.

--
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: Im using sys.master_files.
    ... This I carried out within the Microsoft SQL Server Management Studio when creating or editing a Maintenance Plan. ... Previously I received the error when trying to undertake a differentail backup without a full backup existing. ... However with the differential backup having a changed extension it happily takes the backup! ... current database backup does not exist. ...
    (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.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)