SQLSERVER_database_state_desc.bat
echo DbName : %1 echo schema : %2 sqlcmd -v DbName="%1" schema="%2" -i \\pfile.ft.grp\Batch_win\SQLSERVER_database_state_desc.sql -b
SQLSERVER_database_state_desc.sql
SELECT state_desc FROM sys.databases where name = '$(schema)'; GO
SQLSERVER_database_online.bat
echo DbName : %1 echo schema : %2 sqlcmd -v DbName="%1" schema="%2" -i \\pfile.ft.grp\Batch_win\SQLSERVER_database_online.sql -b
SQLSERVER_database_online.sql
USE $(DbName); GO -- Shrink the truncated log file to 1 MB. ALTER DATABASE $(schema) SET ONLINE ; GO
SQLSERVER_database_offline.bat
echo DbName : %1 echo schema : %2 sqlcmd -v DbName="%1" schema="%2" -i \\pfile.ft.grp\Batch_win\SQLSERVER_database_offline.sql -b
SQLSERVER_database_offline.sql
USE $(DbName); GO -- Shrink the truncated log file to 1 MB. ALTER DATABASE $(schema) SET OFFLINE ; GO