How To Perform a Page Level Restore in SQL Server? | MS SQL SERVER

Join this channel to get access to perks:

Join the Telegram Group for the scripts and assistance:

You Can Also Download the scripts from below folder
We strongly believe there is always chance of betterment, so suggestions are most welcome.

Happy learning, and All the Best in your professional journey!

The journey of improvement is ongoing and never be an end.

Connect With me,

#azuresql #azure #sqldba #sqlserverdba #sql #sqlserver #sqlserverdeveloper #performance #performancetuning #performanceoptimization #mssql #mssqlserver #mssqlserverdba

Thank you!
MS SQL DBA Tech Support

[MSSQLDBATechSupport]

create database test

use test
Go
CREATE TABLE Testtable (
ID int IDENTITY(1, 1) PRIMARY KEY,
Name nvarchar(100) NOT NULL
);
INSERT into Testtable VALUES ('Harsha kalki')

DBCC IND('Test', 'Testtable', -1)
DBCC IND('Test', 'Testtable', -2)

BACKUP DATABASE [test] TO DISK = N'C:\test.bak' WITH NOFORMAT,
NOINIT, NAME = N'test-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,
STATS = 10
GO


DBCC TRACEON(3604)
GO

DBCC PAGE('Test', 1, 352, 3)
--352
-- Understanding the Print Levels:
--0: Only page header information is displayed.
--1: Page header plus per-row information (limited details).
--2: Page header plus full row information.
--3: Page header, full row information, and page data (detailed information).

select 352*8192--2883584


use test
Go
select * from Testtable

[sathyakathir]

Hi Harsha
Ur videos are really helpful. Recently i came across ur automate database refresh activity but unable to find the script in Google drive mentioned in tht video description. I searched in current link which is in this video, i am able to access the link. Can i get the header of the document to find easily.