DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006

    SQL Server Database Backup

    I want the data base back up location to be in server(Where the SQL Server is installed) only, not in the client. And i can not predefine it, rather i want the user to select the location from the client( as the feature is available with Enterprise Manager in SQL Server -> Select backup destination). Is that possible at all using SQL DMO or somthing else that will open up remote computer's physical drives?

  2. #2
    Join Date
    Dec 2003
    San Diego
    Create a Backup Device,
    Ent. Mgr > {server_name} > Management > Backup...

    All a backup device is, is a named location on the local sql server.

    When you start a Backup Database task, go to the Destination section of the backup dialogue, click Add... and select Backup Device. A listbox will appear showing available backup devices. You can also create a new device from here by selecting the <New Backup Device> option.

    Good luck,
    Michael Sanchez
    Managing Technical Editor
    Forum Moderator

Similar Threads

  1. SQL Server Developer in Calgary Canada
    By Dan Staggs in forum Careers
    Replies: 0
    Last Post: 08-07-2002, 11:04 AM
  2. Replies: 3
    Last Post: 09-28-2001, 12:08 PM
  3. Database using VB
    By Manish Hurkat in forum VB Classic
    Replies: 1
    Last Post: 10-17-2000, 01:02 PM
  4. SQL server administrative knowledge
    By Becky in forum Database
    Replies: 1
    Last Post: 07-11-2000, 03:27 PM
  5. Replies: 0
    Last Post: 06-27-2000, 06:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.