<div>
Thanks both of you.. Can I estimate the backup time which is going to take with checksum.. ? any idea
</div>


Thanks both of you.. Can I estimate the backup time which is going to take with checksum.. ? any idea

<div>
It really depends on the number of data pages but I wouldn't expect a big difference unless the database is really huge.
</div>


It really depends on the number of data pages but I wouldn't expect a big difference unless the database is really huge.

<div>
It is 700-800 gb around.. thanks
</div>


<div>
With that size I would turn on the compression for the database backups. It will reduce around 60%-70% of the backup size and time.
</div>


With that size I would turn on the compression for the database backups. It will reduce around 60%-70% of the backup size and time.

<div>
<div class="content wysiwyg-content">
im go to take adhoc sql full backup, before application upgrade<br />
eg:<br />
<br />
BACKUP DATABASE testdb <br />
TO DISK = 'C:\testdb.BAK'<br />
WITH STATS, DESCRIPTION = 'Full backup for AdventureWorks'<br />
GO<br />
<br />
how do you I know, my backup is not corrupted, and will work after restore, incase if required<br />
<br />
Sorry I dont have environment to test.. it..<br />
<br />
Do i need to do consistency check or readability check before take backup, if yes, how can i do that in Tsql?
</div>
</div>


im go to take adhoc sql full backup, before application upgrade
eg:

BACKUP DATABASE testdb 
TO DISK = 'C:\testdb.BAK'
WITH STATS, DESCRIPTION = 'Full backup for AdventureWorks'
GO

how do you I know, my backup is not corrupted, and will work after restore, incase if required

Sorry I dont have environment to test.. it..

Do i need to do consistency check or readability check before take backup, if yes, how can i do that in Tsql?

sql server backup how to verify, your backup is correct and not corrupted

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Golang, also called Go, is an open source programming language that is a statically-typed language with syntax loosely derived from C, adding automatic memory management, type safety, some dynamic-typing capabilities, additional built-in types such as variable-length arrays and key-value maps, and a large standard library. Go is a general-purpose systems programming language that aims to be efficient both for development and execution with a focus on fast compilation and increased maintainability of large projects. Go was originally targeted at systems programming tasks such as building server/web applications, high throughput middleware and databases.

Golang

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.