Re: SQL Database backup

I don't know about any resources, if you don't have Enterprise Manager you
can get the Enterprise version for about £50, (although that was before
SQL2005 came out). When using Enterprise manager it is simple though, just
right click on the database you want to backup, select all tasks and click
backup database, you can specify a location and schedule there.


"JoeF" <JoeF@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5FFA6E33-4C08-42D9-A04D-89FF4EDEF7ED@xxxxxxxxxxxxxxxx
No...I don't know how to create a job using Enterprise Manager. I was
looking
at an OSQL script that wasn't working on anything but the C drive.

Thanks...I'll take a look at Enterprise...any references I can research?

-JoeF

"JosephByrns" wrote:

Are you creating the backup jobs using Enterprise manager? If so, when
you
create a backup job you can specify any folder/drive you want for the
backup
location (including network locations if you want).


"JoeF" <JoeF@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9293A4FB-F487-4EAC-8D5C-6751A52BEBDD@xxxxxxxxxxxxxxxx
How can I successfully back up a database on the server to a different
drive
and folder? I've read something about an 'osql' command, but I'm not
sure
if
this works if thedatabase isn't locatedon the C: drive. Any help is
appreciated. Thanks.

-JoeF





.

Relevant Pages

  • Re: Backup confusion
    ... You can view Devices in Enterprise Manager by looking under {Management], ... You may wish to seek out more information about BACKUP DEVICEs in Books On ... Most good judgment comes from experience. ... device and backup a database I assume that in both cases the ...
    (microsoft.public.sqlserver.tools)
  • Re: sql server 2000 backup and restore
    ... These are the jobs thatare run on our server. ... running under Enterprise Manager. ... Step 3 (Full Backup of MHC) ... >> restore script to this website next week. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Database backup
    ... do - online Enterprise Manager backup to disk, ... Is this what most people use to backup their SQL databases? ... came with SBS Premium (the same one you used to install SQL). ... SQL installer on your XP desktop, selecting Enterprise Manager as the ...
    (microsoft.public.windows.server.sbs)
  • Re: Having difficulty setting Back Up to back up file wihout datetime stamp SQL 2K
    ... I don't have a problem creating the T-SQL commands, ... Enterprise Manager to do more than create dbs is where I get lost. ... recent backup HAS to succeed before it'll delete the older one. ...
    (comp.databases.ms-sqlserver)
  • Tape Drive Problem.
    ... driver SEAGATE 9SP40-000. ... I try to make the backup but instead of using de Enterprise Manager using ... I also installed the SQL Server after the Tape Drive. ...
    (microsoft.public.sqlserver.server)