TechQA.

Question

Should I stop replication logreader and distribution jobs during database maintenance (reindexing, updating stats, and checkdb)?

score 15 · Answer 1 · 2024-03-23T15:59:10.257000

0

Answer

15

Views

Should I stop replication logreader and distribution jobs during database maintenance (reindexing, updating stats, and checkdb)?

15 views Asked by dba_gal At 23 March 2024 at 15:59

score 942 · Answer 2 · 2023-09-06T05:46:08.107000

A database snapshot cannot be created because it failed to start. The storage usage for the managed instance cannot exceed (1048576) MBs

942 views Asked by radheyzunjur At 06 September 2023 at 05:46

score 116 · Answer 3 · 2023-06-27T11:15:38.540000

DBCC - cc_bulkinvoice - A BulkInvoice's total transaction amount should be equal to the sum of all its items' amounts

116 views Asked by 00000000000 At 27 June 2023 at 11:15

score 711 · Answer 4 · 2023-03-14T04:18:27.943000

Attempt to fetch logical page (6:948264) in database 7 failed. It belongs to allocation unit 72057596882452480 not to 72057595956822016

711 views Asked by Shah Alam At 14 March 2023 at 04:18

score 595 · Answer 5 · 2022-04-06T19:42:12.907000

SSAS corrupt string store data file for one of the table columns error

595 views Asked by fd2812 At 06 April 2022 at 19:42

score 190 · Answer 6 · 2021-09-21T16:03:03.373000

DBCC CLONEDATABASE exception 12605 : Failed to create snapshot database

190 views Asked by Nicolas Souquet At 21 September 2021 at 16:03

score 51 · Answer 7 · 2021-09-09T11:55:02.580000

Creating table with different columns depending on condition (which is SQL version)

51 views Asked by I.P. At 09 September 2021 at 11:55

score 1267 · Answer 8 · 2021-07-30T22:05:30.247000

If DBCC printed error messages, contact your system administrator: operand type clash on index rebuild

1.2k views Asked by rednelo At 30 July 2021 at 22:05

score 770 · Answer 9 · 2021-07-09T12:28:25.067000

Weird behavior of DBCC CHECKIDENT with RESEED in a rolled-back transaction

770 views Asked by Palo Mraz At 09 July 2021 at 12:28

score 68 · Answer 10 · 2021-04-10T10:45:14.097000

Are there any .NET API to read SQL Server data pages?

68 views Asked by Just a learner At 10 April 2021 at 10:45

score 215 · Answer 11 · 2020-11-27T12:17:45.720000

DBCC SHOWCONTIG returns 2 rows against certain tables

215 views Asked by kanishka basak At 27 November 2020 at 12:17

score 294 · Answer 12 · 2020-10-23T10:26:22.707000

DBCC CHECKDB did not return a result set in Java ( MS SQL )

294 views Asked by Nguyễn Thanh Tùng At 23 October 2020 at 10:26

score 795 · Answer 13 · 2020-09-23T11:04:58.553000

SQL Server :: FULL backup not recorded in msdb.dbo.backupset and log file unusually large

795 views Asked by Francesco Mantovani At 23 September 2020 at 11:04

score 223 · Answer 14 · 2020-08-18T13:00:09.503000

Capture content from Messages Tab SSMS

223 views Asked by Learner At 18 August 2020 at 13:00

score 843 · Answer 15 · 2020-06-19T07:15:26.113000

Sql Database giving error message while running DBCC CHECKDB()

843 views Asked by Mayank At 19 June 2020 at 07:15

score 1824 · Answer 16 · 2020-06-02T08:57:12.877000

Attempt to fetch logical page in database 5 failed

1.8k views Asked by Sumit Kumar Majhi At 02 June 2020 at 08:57

score 693 · Answer 17 · 2020-03-13T14:45:13.317000

What is SQL Server's DBCC SHRINKFILE T-SQL command equivalent for UI option "‘Reorganize pages before releasing unused space"

693 views Asked by LonelyRogue At 13 March 2020 at 14:45

score 2188 · Answer 18 · 2020-03-04T09:33:02.877000

Is there a way to run sys.dm_db_log_space_usage for all databases?

2.1k views Asked by MonkeyNutts At 04 March 2020 at 09:33

score 582 · Answer 19 · 2019-08-09T09:15:36.780000

Is DBCC command a stored procedure or a function?

582 views Asked by LonelyRogue At 09 August 2019 at 09:15

score 1164 · Answer 20 · 2019-08-07T18:45:34.873000

Can't Run DBCC CHECKDB on master DB - Azure Files

1.1k views Asked by BBaggins At 07 August 2019 at 18:45

TechQA.

List Question

Should I stop replication logreader and distribution jobs during database maintenance (reindexing, updating stats, and checkdb)?

A database snapshot cannot be created because it failed to start. The storage usage for the managed instance cannot exceed (1048576) MBs

DBCC - cc_bulkinvoice - A BulkInvoice's total transaction amount should be equal to the sum of all its items' amounts

Attempt to fetch logical page (6:948264) in database 7 failed. It belongs to allocation unit 72057596882452480 not to 72057595956822016

SSAS corrupt string store data file for one of the table columns error

DBCC CLONEDATABASE exception 12605 : Failed to create snapshot database

Creating table with different columns depending on condition (which is SQL version)

If DBCC printed error messages, contact your system administrator: operand type clash on index rebuild

Weird behavior of DBCC CHECKIDENT with RESEED in a rolled-back transaction

Are there any .NET API to read SQL Server data pages?

DBCC SHOWCONTIG returns 2 rows against certain tables

DBCC CHECKDB did not return a result set in Java ( MS SQL )

SQL Server :: FULL backup not recorded in msdb.dbo.backupset and log file unusually large

Capture content from Messages Tab SSMS

Sql Database giving error message while running DBCC CHECKDB()

Attempt to fetch logical page in database 5 failed

What is SQL Server's DBCC SHRINKFILE T-SQL command equivalent for UI option "‘Reorganize pages before releasing unused space"

Is there a way to run sys.dm_db_log_space_usage for all databases?

Is DBCC command a stored procedure or a function?

Can't Run DBCC CHECKDB on master DB - Azure Files

Popular Questions

Trending Questions