HLDev Script

select d.name, p.* from sys.databases d join sys.sysprocesses p
on d.database_id = p.dbid
where d.name = 'Inprous'


RESTORE DATABASE [InproAsia.lud] FROM  DISK = N'G:\DBDump\InproAsia_backup_2015_07_06_013003_6850601.bak' WITH  FILE = 1, 
MOVE N'InproHKG' TO N'F:\DBData\InproAsia.lud.mdf', 
MOVE N'InproHKG_log' TO N'E:\Trans\InproAsia.lud_1.ldf',  NOUNLOAD,  REPLACE,  STATS = 10
GO

RESTORE DATABASE [InproAsia] FROM  DISK = N'G:\DBDump\InproAsia_backup_2015_07_06_013003_6850601.bak' WITH  FILE = 1, 
MOVE N'InproHKG' TO N'F:\DBData\InproAsia1.mdf', 
MOVE N'InproHKG_log' TO N'E:\Trans\InproAsia1.ldf',  NOUNLOAD,  REPLACE,  STATS = 10
GO

RESTORE DATABASE [InproEU.lud] FROM  DISK = N'G:\DBDump\InproEU_backup_2015_07_06_013003_6850601.bak' WITH  FILE = 1, 
MOVE N'INPRO' TO N'F:\DBData\InproEU.lud.mdf', 
MOVE N'INPRO_log' TO N'E:\Trans\InproEU.lud_1.ldf',  NOUNLOAD,  REPLACE,  STATS = 10
GO

RESTORE DATABASE [InproEU] FROM  DISK = N'G:\DBDump\InproEU_backup_2015_07_06_013003_6850601.bak' WITH  FILE = 1, 
MOVE N'INPRO_log' TO N'E:\Trans\InproEU_log.ldf',  NOUNLOAD,  REPLACE,  STATS = 10
GO

RESTORE DATABASE [InproUS.lud] FROM  DISK = N'G:\DBDump\InproUS_backup_2015_07_06_013003_7006602.bak' WITH  FILE = 1, 
MOVE N'INPRO' TO N'F:\DBData\InproUS.lud.mdf', 
MOVE N'INPRO_log' TO N'E:\Trans\InproUS.lud_1.ldf',  NOUNLOAD,  REPLACE,  STATS = 10
GO

RESTORE DATABASE [InproUS] FROM  DISK = N'G:\DBDump\InproUS_backup_2015_07_06_013003_7006602.bak' WITH  FILE = 1, 
MOVE N'INPRO_log' TO N'E:\Trans\InproUS_log.ldf',  NOUNLOAD,  REPLACE,  STATS = 10
GO


SELECT TOP 3 * FROM INPROASIA..CASEEVENT WHERE EVENTNO = -14 ORDER BY EVENTDATE DESC
SELECT TOP 3 * FROM INPROEU..CASEEVENT WHERE EVENTNO = -14 ORDER BY EVENTDATE DESC
SELECT TOP 3 * FROM INPROUS..CASEEVENT WHERE EVENTNO = -14 ORDER BY EVENTDATE DESC

SELECT TOP 3 * FROM [INPROASIA.LUD]..CASEEVENT WHERE EVENTNO = -14 ORDER BY EVENTDATE DESC
SELECT TOP 3 * FROM [INPROEU.LUD]..CASEEVENT WHERE EVENTNO = -14 ORDER BY EVENTDATE DESC
SELECT TOP 3 * FROM [INPROUS.LUD]..CASEEVENT WHERE EVENTNO = -14 ORDER BY EVENTDATE DESC


-- SELECT name, database_id FROM SYS.databases WHERE name NOT IN ('master','tempdb','model','msdb','RSDB','RSDBTempDB')

--------------------------------------------------------------------------------------------------------------------------------

USE MASTER
GO

-- Declare the variables to store the values returned by FETCH.
DECLARE @DATABASE Nvarchar(100), @DBID INT, @FILENAME NVARCHAR(200), @SCRIPT NVARCHAR(MAX);

DECLARE DBCursor CURSOR FOR

SELECT D.NAME, D.database_id, F.NAME FROM SYS.databases D JOIN sys.master_files F ON D.database_id = F.database_id
WHERE F.TYPE_DESC = 'LOG' AND D.name IN ( 'INPROASIA', 'INPROEU', 'INPROUS', 'INPROASIA.LUD', 'INPROEU.LUD', 'INPROUS.LUD')
--NOT IN ('master','tempdb','model','msdb','RSDB','RSDBTempDB','ReportServer$TOKYO2','ReportServer$TOKYO2TempDB')
ORDER BY 1;

OPEN DBCursor;

FETCH NEXT FROM DBCursor
INTO @DATABASE, @DBID, @FILENAME;

-- Check @@FETCH_STATUS to see if there are any more rows to fetch.
WHILE @@FETCH_STATUS = 0
BEGIN

   -- Concatenate and display the current values in the variables.
    SET @Database = '['+@Database+']'
    -- 1.
    SET @SCRIPT ='ALTER DATABASE ' +@Database+ ' SET RECOVERY SIMPLE'
    PRINT @SCRIPT
    EXECUTE sp_executesql @SCRIPT, N'@Database nvarchar(100)',    @Database
   
    -- 2.
    --SELECT @FILENAME = name FROM sys.master_files WHERE database_id = db_id(@DATABASE) AND type = 1
   
    -- PRINT '.....................' +  @FILENAME + '.....................'
    SET @SCRIPT =    'USE ' +@DATABASE+ ';'+
                    'DBCC SHRINKFILE ('+@FILENAME+', 1)'
    PRINT @SCRIPT
    EXECUTE sp_executesql @SCRIPT, N'@Database nvarchar(100)',    @Database
      
   -- This is executed as long as the previous fetch succeeds.
   FETCH NEXT FROM DBCursor
   INTO @DATABASE, @DBID, @FILENAME;
END

CLOSE DBCursor;
DEALLOCATE DBCursor;
GO

--------------------------------------------------------------------------------------------------------------------------------

--USE [Inproasia]
--GO
--    -- Truncate the log by changing the database recovery model to SIMPLE.
--    ALTER DATABASE [Inproasia]
--    SET RECOVERY SIMPLE;
--    GO
--    -- Shrink the truncated log file to 1 MB.
--    DBCC SHRINKFILE (InproHKG_Log, 0);
--    GO

--USE [Inproeu]
--GO
--    -- Truncate the log by changing the database recovery model to SIMPLE.
--    ALTER DATABASE [InproEU]
--    SET RECOVERY SIMPLE;
--    GO
--    -- Shrink the truncated log file to 1 MB.
--    DBCC SHRINKFILE (Inpro_Log, 1);
--    GO

--USE [InproUS] 
--GO
--    -- Truncate the log by changing the database recovery model to SIMPLE.
--    ALTER DATABASE [Inprous]
--    SET RECOVERY SIMPLE;
--    GO
--    -- Shrink the truncated log file to 1 MB.
--    DBCC SHRINKFILE (Inpro_Log, 1);
--    GO

--USE [Inproasia.lud]
--GO
--    -- Truncate the log by changing the database recovery model to SIMPLE.
--    ALTER DATABASE [Inproasia.lud]
--    SET RECOVERY SIMPLE;
--    GO
--    -- Shrink the truncated log file to 1 MB.
--    DBCC SHRINKFILE (InproHKG_Log, 1);
--    GO

--USE [Inproeu.lud]
--GO
--    -- Truncate the log by changing the database recovery model to SIMPLE.
--    ALTER DATABASE [InproEU.lud]
--    SET RECOVERY SIMPLE;
--    GO
--    -- Shrink the truncated log file to 1 MB.
--    DBCC SHRINKFILE (Inpro_Log, 1);
--    GO

--USE [InproUS.lud] 
--GO
--    -- Truncate the log by changing the database recovery model to SIMPLE.
--    ALTER DATABASE [Inprous.lud]
--    SET RECOVERY SIMPLE;
--    GO
--    -- Shrink the truncated log file to 1 MB.
--    DBCC SHRINKFILE (Inpro_Log, 1);
--    GO

--USE master
--GO

--------------------------------------------------------------------------------------------------------------------------------

---- Truncate the log by changing the database recovery model to SIMPLE.
--ALTER DATABASE Inproasia
--SET RECOVERY SIMPLE;
--GO
---- Shrink the truncated log file to 1 MB.
--DBCC SHRINKFILE (InproHKG_Log, 1);
--GO
---- Reset the database recovery model.

--ALTER DATABASE Inproasia

--SET RECOVERY FULL;

bat - hide or unhide folder

attrib C:\folder | findstr "^....H" >nul && (
  : unhide 
  attrib C:\folder -s -h -r
) || (
  : hide
  attrib C:\folder +s +h +r
)