CLS @ECHO OFF ECHO REALIZA O BACKUP DE BASE DE DADOS SQL SERVER sqlcmd -U sa -P S@geBr.2014 -S .\Sage -d FOX_00002 -Q “backup database FOX_00002 to disk=’C:\FOX_SQL_QA\Backup\FOX_00002.bak'” sqlcmd -U sa -P S@geBr.2014 -S .\Sage -d FOXDADOS -Q “backup database FOXDADOS to disk=’C:\FOX_SQL_QA\Backup\FOXDADOS.bak'” ECHO RESTAURA A BASE DE DADOS SQL SERVER SqlCmd -E -S .\SAGE –Q “RESTORE DATABASE [FOX_00002] FROM DISK=’C:\FOX_SQL_QA\BACKUP\FOX_00002.bak'” sqlcmd -U <usuario> -P <senha> -S <servidor>\<instancia> -d <nome do banco> -Q “backup database <nome do banco> to disk=’C:\Backup\<nome do banco>.bak'” SqlCmd -E -S Server_Name –Q “RESTORE DATABASE [Name_of_Database] FROM DISK=’X:PathToBackupFile[File_Name].bak'”
andrejufreire