• 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?

    ITKE366,220 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:
  • Backup schema in SQL Server 2005

    Would there be a way to backup just the schema in a SQL Server 2005 database? I don't need records, just the structure. Thank you!

    ITKE366,220 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?

    ITKE366,220 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?

    ITKE366,220 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.

    ITKE366,220 pointsBadges:
  • How to backup MySQL database automatically on Windows Server

    I've been searching everywhere to find an answer to my question but still can't find anything. Would anyone happen to know if it's possible to backup a MySQL database automatically during certain times of the day to a specific server / email attachment? Should we use the Windows Task Scheduler?...

    ITKE366,220 pointsBadges:
  • How to backup MySQL users and their privileges

    Is there a way to actually backup our MySQL users and their privileges? Would mysqldump work? Here's what I have so far: mysqldump -d -u root -p MyTable > Schema.sql Thanks so much!

    ITKE366,220 pointsBadges:
  • Store data in database in Hindi

    How can I store data in DB in hindi using django-model?

    sudhakar045 pointsBadges:
  • Query/400 not displaying column descriptions for DDL defined table

    We recently updated a file and converted it from DDS to DDL during the process. During testing no one mentioned the column descriptions were no longer displayed when using Query/400. Is there a way to make Query/400 display column descriptions for DDL defined tables?

    DancingInTheMoonlight145 pointsBadges:
  • What would be the best testing ppt to present for a fresher?

    I just wanted to know the best topic related to testing to be presented before the employees of a company.

    sibabrata5 pointsBadges:
  • Backup error when restoring SQL Server database

    A few days ago, I backed up my database that I created on another machine (which was running SQL Server 2012 Express) and I need to restore it on my machine. However, I keep getting this error when I'm trying to do it: Backup mediaset is not complete. Files: D:\question.bak. Family count:2. Missing...

    ITKE366,220 pointsBadges:
  • How should I start my data analysis?

    I have a database which has machine data (tables like: machine cycles, machine phases and many more ) and I am suppose to analysis this data. Meaning, with the data present in different tables, I have to filter out or rather define standard machine cycles, standard machine phase etc. Hence, can you...

    rakeshmurthy5 pointsBadges:
  • Conversion of Microsoft Excel formula to Access

    How do I convert the below given formula of MS Excel to MS Access for the following data: ID Level Session Gender Regular/Plus Shift Programme Section 13 INTERMEDIATE 2013-2015 MALE REGULAR MORNING FSC ENG FSC B-4 14 INTERMEDIATE 2013-2015 MALE REGULAR MORNING FSC ENG FSC B-3 15 INTERMEDIATE...

    MUHAMMADYOUSAF10 pointsBadges:
  • Table that has multiple records for one field

    I have made a database for a school that has Students info, teachers info, parents info, and some other tables. My problem is that I want a table that has subjects that are shared by all students that I print out a report that has students info, teachers info and that table for performance with...

    VinBagz20 pointsBadges:
  • Force replace when backing up SQL database

    We're trying to back up our database using this code: sqlcmd -S servername -Q "BACKUP DATABASE [DBName] TO DISK = 'C:\backup.bak'" It's been working but there's one little issue: When the backup file already exists, the data gets appended to the file. We need it to replace the file. Is there a way...

    ITKE366,220 pointsBadges:
  • MySQL backup option for Windows Server

    What would be the best MySQL backup option for Windows Server? I need to only backup my data. Also, the backup needs to be done somewhere outside the the server and I would prefer a free option too. Thank you!

    ITKE366,220 pointsBadges:
  • Backup stored procedures in MySQL

    With MySQL, I've been using mysqldump to back it up daily. But how do I store stored procedures? Is it backed up with everything else?

    ITKE366,220 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.

Following