• Backup and replicate SQL Server database

    We have a SQL Server database that contains our most recent data. We need to replicate the content into several other servers. But for some reason, we can't use the replicate / sync function to sync to other SQL Server instances. What would be the best way to do this? Thank you!

    ITKE372,060 pointsBadges:
  • Clustered index on view


    debadarshsn5 pointsBadges:
  • Handle MySQL backups with Git

    For our MySQL backup, we came up with a pretty good idea but we're not entirely sure. To backup it up, we thought of putting the dump file into a Git repository, and the commit on each dump so we have the most recent copy / we can roll back to a previous backup. But we're not sure of the flaws...

    ITKE372,060 pointsBadges:
  • How to do MySQL backups on a budget

    Our MySQL backup strategy is to replicate our database to a second server and then run mysqldump on that server to get rid of any downtime from table locking. It's working great but the cost is huge (Over $150 per month on that second server). Anyone know of another way to do MySQL backups cheaper?...

    ITKE372,060 pointsBadges:
  • Setting up a database server in-house

    Goal: add a database server for silo storage environment to meet client requirements. Send queried reports from shared SQL server to new database server to be accessed from website dashboards. What is the best server set up to accomplish this?

    SacredGrounds5 pointsBadges:
  • Best way to backup our production database

    For the past several weeks, we've been looking at CouchDB for a CMS application. What's the best way for us for backing up our production database? Should we possibly clone the database (so we can use it in testing / development). What about just copying the files on a disk? Thanks for the help!

    ITKE372,060 pointsBadges:
  • How to insert row number using SQL

    When importing data from Excel into MS Access, how do you insert a row number using SQL?

    JimStAubin201515 pointsBadges:
  • Performance issue with MySQL database backup

    My friend and I have been trying to create a regular backup for a production database (large one, in fact). The database has both InnoDB and MyISAM tables. We have been using mysqldump but it keeps taking longer and longer each time. Sometimes, the server is even unresponsive when the dump is...

    ITKE372,060 pointsBadges:
  • Backup SQLite database to SD card on Android

    I'm trying to add a feature to one of my Android applications that would back up a SQLite database to my SD card. Is there a way to do this? Thank you very much!

    ITKE372,060 pointsBadges:
  • Add New Record in database form

    The form in my database will not allow me to add a record - the record functions are grayed out. I was able to add a new record. Then I was not. Probably user error, but not sure what to do.

    jsuddath5 pointsBadges:
  • How to restore single table my MySQL database backup

    We currently have a mysqldump that backups our MySQL database (which has a bunch of tables with roughly 440 MBs). We've been trying to restore one of the tables from the mysqldump. Would that be possible? Thanks so much!

    ITKE372,060 pointsBadges:
  • How to backup SQLite database to SD card

    Does anyone know if it's possible to backup our database to a SD card automatically in my Android app? After that's done, is there a way to restore it too?

    ITKE372,060 pointsBadges:
  • How can I backup a SQLite database to my SD card?

    I'm trying to add a feature in my Android application that would automatically back up a SQLite database to my SD card. Is there a way to do this? Thank you very much.

    ITKE372,060 pointsBadges:
  • SQL Script for monitoring backup progress of database

    I noticed that whenever I do a backup of a database using SQL Server Management Studio, I usually get this image of how the process is going / how much longer it will take. But if I do the backup with a script, is there some way I can monitor the whole process?

    ITKE372,060 pointsBadges:
  • Import and Export data from AS/400 using ODBC

    I imported data from AS/400 database file into an Excel sheet, using ODBC. I selected Microsoft query in order to retrieve data. How can I export data into AS/400 database file?

    Geek51180 pointsBadges:
  • How to automate SQL Server database backup

    I've been generating SQL Scripts on a daily basis so we can have a backup our SQL Azure database. But we're working to do this on an automated level. Is there a way to do this?

    ITKE372,060 pointsBadges:
  • Database design for the application with cloud capability

    Does it require/available any special DB design for the application with cloud capability? We need to design database for our new new project application. Any one please suggest if using DB Design especially for cloud capability.

    Muthuramalingam45 pointsBadges:
  • MySQL: Joining select counts from same table

    Please I want to join the statements below to get a single output Select count(*) TotalAccounts,Affiliate from realdb.tbl_logs group by affiliate Select count(*) TotalGen,Affiliate from realdb.tbl_logs where lastdate =curdate() group by affiliate Select count(*) TotalNotGen,Affiliate from...

    MaameBamfua5 pointsBadges:
  • How to backup a MySQL database daily

    As of today, I have a 20 GB MySQL database that I backup daily using mysqldump. But there's one problem with it: When I don't take down the web server, it takes forever to backup (only takes 5-10 minutes when I take it down). Would there be a better way to do a backup for this?

    ITKE372,060 pointsBadges:
  • Backing up H2 database engine when it’s running

    Hi experts, I have a question for all of you! I'm building a web application with a H2 database engine. But I'm having issues backing up the data when the database is running. Is it stored in the file system? Would I be able to backup the outputted files? Thanks so much.

    ITKE372,060 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.