+ Post New Thread
Results 1 to 8 of 8
Windows Thread, MS SQL 2005 - Dump SQL in Technical; Linux user in windowsland here Want to do the equivalent of mysqldump to MSSQL, in order to back up the ...
  1. #1


    tom_newton's Avatar
    Join Date
    Sep 2006
    Location
    Leeds
    Posts
    4,473
    Thank Post
    866
    Thanked 848 Times in 670 Posts
    Rep Power
    196

    Thumbs down MS SQL 2005 - Dump SQL

    Linux user in windowsland here

    Want to do the equivalent of mysqldump to MSSQL, in order to back up the sql (create table statements, inserts, etc.)

    What's the usual way to do this, or should i be backing up in some other fashion?

    Ta.

  2. #2
    Jona's Avatar
    Join Date
    May 2007
    Location
    Cranleigh
    Posts
    469
    Thank Post
    14
    Thanked 50 Times in 48 Posts
    Rep Power
    23
    Here we do it with a "Job" which is configured in Server Management Studio

    If you right click a database and select Task > Backup You can create a SSI file which will do a backup to a .sql file and you can then set this to run automatically via a job.

    I havn't ever investigated if there is a way to do it from the commandline (a-la my-sql but I have just found this: http://sqldump.sourceforge.net/).

    Hope that helps

    Cheers
    Jona

  3. #3
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,765
    Thank Post
    898
    Thanked 416 Times in 350 Posts
    Blog Entries
    12
    Rep Power
    87
    Or you can do it manually using myphpadmin.

  4. #4
    Jona's Avatar
    Join Date
    May 2007
    Location
    Cranleigh
    Posts
    469
    Thank Post
    14
    Thanked 50 Times in 48 Posts
    Rep Power
    23
    Quote Originally Posted by ittech View Post
    Or you can do it manually using myphpadmin.
    Isn't that for MySQL rather than MSSQL ??

  5. #5


    tom_newton's Avatar
    Join Date
    Sep 2006
    Location
    Leeds
    Posts
    4,473
    Thank Post
    866
    Thanked 848 Times in 670 Posts
    Rep Power
    196
    Cheers Jona. I'll pass this to my colleague who's doing the backup

  6. #6
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,765
    Thank Post
    898
    Thanked 416 Times in 350 Posts
    Blog Entries
    12
    Rep Power
    87
    Quote Originally Posted by Jona View Post
    Isn't that for MySQL rather than MSSQL ??
    Yep I totally misread the original post

  7. #7

    ZeroHour's Avatar
    Join Date
    Dec 2005
    Location
    Edinburgh, Scotland
    Posts
    5,669
    Thank Post
    904
    Thanked 1,318 Times in 800 Posts
    Blog Entries
    1
    Rep Power
    445
    The SQL command we use is:
    Code:
    BACKUP DATABASE {database} to DISK='\\{SERVER}\{SHARED}\{something.bak}' with init
    The file created is not text based but with that file you can then run MSSQL's "RESTORE" command and it will rebuild a database. 2005's management tools allow you to restore files like these using a wizard without commands.
    We use the SQL Agent to run a Job which basically just runs that command at set intervals.

  8. #8

    Join Date
    Dec 2005
    Location
    Essex
    Posts
    85
    Thank Post
    7
    Thanked 5 Times in 5 Posts
    Rep Power
    18
    Hah! as if! I knocked up a quick script in kixtart last week that backs up a mssql server live. If anyone is interested lemme know

    I'm not at a machine I can access it from at the moment

    EDIT:/ btw its a kixtart script that I run as a scheduled task that dumps a certain database to a file, overwriting the existing backup if it already exists.
    Last edited by JamesC; 23rd January 2008 at 05:25 PM.

SHARE:
+ Post New Thread

Similar Threads

  1. Dead TFT monitors - repair or dump?
    By CESIL in forum Hardware
    Replies: 9
    Last Post: 11th November 2009, 07:36 PM
  2. SQL 2005
    By jcollings in forum MIS Systems
    Replies: 12
    Last Post: 22nd October 2007, 03:00 PM
  3. Oracle database dump
    By pooley in forum MIS Systems
    Replies: 0
    Last Post: 14th June 2007, 10:54 AM
  4. 4 reasons to dump Linux
    By Geoff in forum *nix
    Replies: 9
    Last Post: 23rd January 2007, 01:20 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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