Hi Andrey,

Thank You...

Hi Andrey,

SQL server 2014 Value = 1 and Value_in_use = 1

SQL server 2016 Value = 0 and Value_in_use = 0

Thank You

Hi Andrey

Thank you,

BACKUP DATABASE [DBName]
TO DISK = N'E:\Old\DBName.bak' WITH NOFORMAT
, NOINIT
, NAME = N'DBName-Full Database Backup'
, SKIP
, NOREWIND
, NOUNLOAD
, STATS = 10
, compression

I run the above query...

No I am not change recovery Model

Hi Andrey,

Thank You

Data File Size : 4360 MB

Log File Size : 3398 MB

when I checked Both SQL server 2014 and 2016 Data File and Log file size was same.

the below...

IP is Ping Correctly and also SSMS are login to access database

DECLARE @Temp TABLE ([File] INT, Main INT, Sub CHAR(2), [Text] VARCHAR(20));

INSERT INTO @Temp ([File], Main, Sub, [Text])

VALUES (1, 1, 'A.', 'hello'),

...

I want to secure the backup file so it can't be restored elsewhere by any One.

I want to protect my backup file.

Please Send Your Mail Id

ok i will give

Yes i Create Index for All Tables

WITH DateYear AS

(

SELECT 0 AS num

UNION ALL

SELECT num + 1 FROM DateYear

...

Thanks

Use this Statement

OPTION (MAXRECURSION 0)