How to backup SQL 2000 Server database without having same backup file name?

After i did a backup database in Enterprise Manager, lets say the backup file name is “customer”.
Then i backup the same database again, and it replaced the old one (customer). How can i make the backup file name to become “16032007-Customer” (for 1st one) and “17032007-Customer”, according to date?

Is there a query that you can run in SQL that will tell you which database (if any) has a bad path to its data

My backup software keeps telling me that I have a bad path to one of the databases on one of my servers, but I can’t see it when I check it manually. I’m sure that I am just missing it, but I have no idea how to tell where it is. Is there [...]

MySQL – How to create a secure backup database file?

Hi,
I’m using MySQL Community Server 5.1.55 and my OS is Windows.
I want to backup all my databases into one dump file.
Currently I’m using mysqldump.exe with this command:
mysqldump.exe myDB –single-transaction -u myuser -pmypass -r “C:\dumpDB\myDB.sql”
This command will successfully create a dump database file named myDB.sql.
But my concern is, we can easily open this myDB.sql with notepad [...]

Vps backup solution needed – how can I make sure my website database is backed up remotely on a schedule?

How to do a vps backup remotely for free? Me and my partner launched an recruiting website together – we have good ties in the retail and hospitability industries and in six months from the official launch we managed to have our client base built nicely. For this we had a website developed – both [...]

how to take database backup from mysql server?

4 months data is present in mysql server, i take the whole database backup everyweek.so ,instead of taking complete database backup how to take only that particular weeks data backup from mysql server.

How do I backup a mysql database and save this backup on another computer on the same network?

Which database and backup software is best suite for me?

I am working for a small company around 20 people. They have asked me to suggest which database system would be best for them to upgrade their HR management module. Currently they are using Excel. Also any comments a good database backup software is good and maybe easy to use?
Thanks.

How to backup a database to a remote server?

How do I backup SQL server database to a network drive?

I have tried to use trace flag 1807, but it did not work. Any idea?
Thanks for anyone tried to help on this issue. I have resolved it, and it was due to my SQL server service was using local system account. Therefore I could not access network drive. Once I corrected by using domain account, [...]

How to make SQL Backup and Restore Database inside a Visual Basic Application?

I am a software engineer. I want my software (Designed in Visual Basic 6.0)to make backup and restore SQL Database file hosted on a server. The backup should be made by SQL Server itself. I just want to know how to do send command to SQL to do this.

Next Page »