Mysql Dailybakup of all databases with same name one by one using script on windows

MySQL backup of all database is done by mysqldump with –all-database,but using this method we can only backup all db to one sqldump file,here we use one script to backup all database with same name,   @ECHO OFF SET BACKUPS_DIR=E:\mysqldailybackup SET MYSQL_DIR=D:\Program Files\MySQL\MySQL Server 5.0\bin SET USER=”root” SET PASSWORD=”root” SET PORT=”3306″ REM ============================ SET OLDDIR=%CD% [...]

Continue reading about Mysql Dailybakup of all databases with same name one by one using script on windows »

One of my server using Microsoft SQl Express R2 ,i need to schedule the backup of all databases,follow the step 1.Create a bat file mssqlbackup.bat copy the following code @ECHO OFF SETLOCAL set folder=%date:~-4%-%date:~4,2%-%date:~7,2% echo %folder% SQLCMD -E -S (servername) -Q “BACKUP DATABASE (database name) TO DISK=’D:\Daily_Backup\MSSQL_BACKUP\(database name)%folder%.bak’ WITH NOFORMAT, INIT, NAME =N’ full backup’, [...]

Continue reading about Schedule Microsoft SQL Server Express R2 Databases Using SQLCMD with current date and time »

While connecting to SQL Server 2008 using SQL profiler one of machine got error Cannot retrieve trace definition for SQL Server version 10.50.1600     After Searching i got a working solution for this error This  is due to the wrong SQLPath in Registry ,to rectify this open registry and change the value of SQLpath [...]

Continue reading about Cannot retrieve trace definition for SQL Server version 10.50.1600 SQL Server 2008 Profiler not connecting »

After a sudden shutdown of my Team foundation server 2010 , i cant able to list the default collection projects After examine i found one of my database “Tfs_configuration” show as “Suspect”,i restart and try but problem still exist after searching i solve the problem by the following simple query one by one   alter database tfs_configuration [...]

Continue reading about After accident shutdown database showing suspect in sql 2008 tfs_configuration(suspect) »

After installing Microsoft SQL Server 2008 ,i can’t able to connect through management studio ,i am not enable sa login only enable widows authentication,i got authentication error ,i solve the problem by a simple method 1.Login the machine as Administrator 2.Stop the SQL service from command Line, net stop mssqlserver 3.Start the SQL service as [...]

Continue reading about microsoft sql server 2008 forgot sa password cannot connect to server error 18456 »

One Of machine showing the abouve error while connecting to mysql server Resolve the error by typing the folowing command mysqladmin -u<username> -p<password> flush-hosts Change username and password with Your mysql root username/password

Continue reading about error no 1129 host is blocked because of many connection errors unblock with mysqladmin flush-hosts »