-> I had to restore a database of size 26 TB in my Development server. This database had 2 filegroups namely PRIMARY and BLOB. Primary Filegroup has tables of size 3 TB and BLOB filegroup has tables of size 23 TB.

-> My requirement for this restore was to just restore PRIMARY filegroup and not BLOB filegroup.

-> Below TSQL can be used to restore PRIMARY Filegroup only from the full database backup.

USE [master]
RESTORE DATABASE [JB_DB] FILEGROUP='PRIMARY'
FROM DISK = N'C:\DB\JB_DB_01of06.bak',
DISK = N'C:\DB\JB_DB_02of06.bak',
DISK = N'C:\DB\JB_DB_03of06.bak',
DISK = N'C:\DB\JB_DB_04of06.bak',
DISK = N'C:\DB\JB_DB_05of06.bak',
DISK = N'C:\DB\JB_DB_06of06.bak'
WITH PARTIAL, RECOVERY, FILE = 1, NOUNLOAD, STATS = 1, REPLACE
GO

Thank You,
Vivek Janakiraman

Disclaimer:
The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.

-> There are two SQL Server Agent jobs scheduled. Job1 has 6 steps and Job2 as 1 step.

-> Job1 details below,

-> Job2 details below,

-> Step4 of Job1 executes below TSQL that checks if Job2 has completed or not and wait for Job2 to complete.

DECLARE @JOB_NAME SYSNAME = N'JOBNAME';
DECLARE @JOB_NAME1 SYSNAME = N'JOBNAME';

Job_Status:
IF NOT EXISTS(
select 1
from msdb.dbo.sysjobs_view job
inner join msdb.dbo.sysjobactivity activity on job.job_id = activity.job_id
where
activity.run_Requested_date is not null
and activity.stop_execution_date is null
and job.name IN (@JOB_NAME,@JOB_NAME1)
)
BEGIN
PRINT 'Job not running'
END
ELSE
BEGIN
PRINT 'Job is running';
waitfor delay '00:01:00'
goto Job_Status;
END

Thank You,
Vivek Janakiraman

Disclaimer:
The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.