CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 5 of 5
  1. November 15th, 2005, 07:00 PM #1
    Sabin_33's Avatar
    Sabin_33
    Sabin_33 is offline Member
    Join Date
    Dec 2004
    Posts
    423

    SQL Server 2000 BACKup

    I'm using SQL Server 2000 and VB6.
    I am only using Access and MSDE Query as my tools, I have nothing else .

    I was curious about creating Backups and Restoring Data in SQL SERVER using SQL.

    I've looked around but the topic is apparently real broad. Mostly everybody is using enterprise manager.

    Any ideas?
    Reply With Quote Reply With Quote
  2. November 16th, 2005, 03:11 AM #2
    d-u
    d-u is offline Member
    Join Date
    Sep 2004
    Posts
    292

    Re: SQL Server 2000 BACKup

    You may want to look into this... BTW, it's for VB6.0...
    Intelligent people talks because they have something to say,
    Fools talk because they have to say something....
    Reply With Quote Reply With Quote
  3. November 16th, 2005, 11:37 AM #3
    Sabin_33's Avatar
    Sabin_33
    Sabin_33 is offline Member
    Join Date
    Dec 2004
    Posts
    423

    Re: SQL Server 2000 BACKup

    Thanks d-u. I found a lot of helpful information on that
    Reply With Quote Reply With Quote
  4. November 16th, 2005, 12:08 PM #4
    Sabin_33's Avatar
    Sabin_33
    Sabin_33 is offline Member
    Join Date
    Dec 2004
    Posts
    423

    Re: SQL Server 2000 BACKup

    What about maintenace.

    Anything in SQL without Enterprise manager I can do?
    Reply With Quote Reply With Quote
  6. November 16th, 2005, 01:44 PM #5
    exterminator's Avatar
    exterminator
    exterminator is offline Elite Member Power Poster
    Join Date
    Feb 2005
    Location
    "The Capital"
    Posts
    5,306

    Re: SQL Server 2000 BACKup

    You could look into the bulk copy utility with SQL server/Sybase - here - bcp (on msdn). Hope this helps. Regards.

    Go through these threads as well:
    1. bcp command
    2. SQL Server 2k Insert Trigger - Output to file
    Last edited by exterminator; November 16th, 2005 at 01:47 PM.
    Can you help me with my homework assignment?, Before you post!, Use code tags, How to post!, Codeguru technical FAQs, C++ FAQ Lite, Stroustrup: C++ Style and Technique FAQ, Guru of the Week, Comeau C and C++ FAQs, Comeau C++ Templates FAQs, CUJ @ DDJ, Spam threshold

    My Blogs : Learning C++ is fun | Abnegator's reflections
    Open Threads : C++ Aha! Moments | Nature of work in C++?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured