SQLSERVER – info

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

Category: SQLSERVER