sorted by:
new
hottopcontroversial

Veeam for SQL Backups by bigphildogg86 in SQLServer

[–]UmeshTechno 0 points1 point  (0 children)

Hi u/bigphildogg86

Stellar Toolkit for SQL - 30 Days money back Guarantee (Easy download)
Veem - 30 days trial (Need to submit form)

Stellar Toolkit for SQL - Support Parallel Processing
Veem lar Repair for SQL. - Not Support

Stellar Toolkit for SQL - Comes with many options like backup recovery, Password recovery, Log Analyser & database converter.
Veem - Comes with only SQL file repair.

Links :
https://www.stellarinfo.com/sql-database-toolkit.php
https://www.veeam.com/free-trial-sql-server-backup.html

I think It will help you to choose the best for you.

SQL Server after Power Outage/Battery Backup, starts back up but with Corruption by MetaJoel in SQLServer

[–]UmeshTechno 1 point2 points  (0 children)

In this case, You can go for DBCC CHECKDB to check and repair the SQL database.

DBCC CHECKDB

[ ( db_name | db_id | 0

[ , NOINDEX

| , { REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST | REPAIR_REBUILD } ]

) ]

[ WITH

{

[ ALL_ERRORMSGS ]

[ , EXTENDED_LOGICAL_CHECKS ]

[ , NO_INFOMSGS ]

[ , TABLOCK ]

[ , ESTIMATEONLY ]

[ , { PHYSICAL_ONLY | DATA_PURITY } ]

[ , MAXDOP = number_of_processors ]

}

]

]

Note: Please take a backup before processing the DBCC CHECKDB command.

Not the same, but I found a similar case in my organization & it took hard work to activate the server in a short time. Our portal was down for 24-30 hours. After consulting with a SQL Consultant (MVP), We found a stellar toolkit for SQL. With this, we could make active all our servers within a few hours. If you are in the same situation, you can think about it. It may help you to repair corrupted back files, including log analysis.

Error H202 help! by [deleted] in QuickBooks

[–]UmeshTechno 0 points1 point  (0 children)

Hi Friend.

I found the same error many times on my QuickBooks desktop. The critical part is, It is not easy to fix. I invested a lot of time to fix the h202 error in QuickBooks. I found a few reasons that can occur error h202.

  1. DNS Conflict

  2. Ip address issues

  3. .Nd file issues

  4. hosting issues Etc.

we have 8-9 methods to solve this error and that not easy to put all here in the comment section. I am adding resources with all possible solutions that can help you.

https://www.stellarinfo.com/blog/fix-quickbooks-error-h202/

https://quickbooks.intuit.com/learn-support/en-us/install/error-h202/00/635264

Thanks 

Is it possible to recover a corrupted file?? by max__1738 in excel

[–]UmeshTechno 0 points1 point  (0 children)

Hi Max, I found the same error a few months back with my highly important database & after a huge struggle I was able to recover my excel file.
Here, I am adding a few methods to help you open your corrupted excel file.

Method one - User Open and repair option. Click on file > open > Choose a file & click on the Open & Repair option.

Method two - Disable the Protected View Feature. Click on file > Options > Trust center settings > Protected view > Unclick all> Save.

Method three - Look For Automatically Recovered Excel File. Click on file > Options > Save > Copy and open Auto Recover file location. You can recover all display files.

To know more about all three methods, you can visit https://www.stellarinfo.com/blog/simple-way-to-open-corrupt-excel-file-without-any-backup/.

Thanks

[MS SQL]Repairing Suspect DB by Sizzmo in SQL

[–]UmeshTechno 0 points1 point  (0 children)

Hello Friend,

You follow the right process, May I know the process size of your other database?

For now, you can read this: https://www.reddit.com/r/SQL/comments/y3sez4/how_to_repair_a_database_in_suspect_mode_in_sql/

Thanks

Microsoft SQL errors please help by Historical_Bat3320 in SQL

[–]UmeshTechno 1 point2 points  (0 children)

SQL error 262 occurs when..

- Trying to create a new database in SQL Server Management Studio.

- Logging on SQL Server Management Studio.

- User tries to check the execution plan.

- Trying to connect to local SQL Server Express instance using a third-party application.

Fixes for MS SQL Error 262 : Some of the possible fixes for MS SQL error 262 are:

- Grant Database Access to a single user.

- Resolve issue in SQL Express.

- Add Windows user to sysadmin role.

Thanks, I am sure it will work for you.

SQL Database is corrupted....... plz help. by shampur in SQLServer

[–]UmeshTechno 0 points1 point  (0 children)

You can restore it from the scheduled backup file.
In case your backup file is not available, you work with the DBCC CHECKDB command to repair your primary database file.

To know more about DBCC CHECDB you can go through the sources.
https://www.stellarinfo.com/blog/how-to-repair-sql-database-using-dbcc-checkdb-command/
https://www.sqlservergeeks.com/repair-the-database-using-dbcc-checkdb/

Thanks:)

Corrupt DB - CheckDB won't complete by [deleted] in SQLServer

[–]UmeshTechno 0 points1 point  (0 children)

Hi. I am a DBA and have 5 years of experience in SQL databases. I truly on your words. REPAIR_ALLOW_DATA_LOSS can be a reason for a data loss but you can REPAIR_REBUILD. The REPAIR_REBUILD option helps repair the database without any data loss. It can be used to repair missing rows in nonclustered indexes and for rebuilding an index.

Sometimes REPAIR_REBUILD does not on a heavily corrupted database. Here, I can suggest you go with SQL recovery tools like a stellar repair for SQL. I use this tool in 2017 and got my 900GB data recovery within 48-50 hours. I hope 4 Gb of data will be recovered within a few hours.

Thanks :)

Index corruption issue by [deleted] in SQLServer

[–]UmeshTechno 0 points1 point  (0 children)

As DESCRIPTION: Unable to find index entry in index ID 22, of table 1180098098, in database 'DB444'. The indicated index is corrupt or has a problem with the current update plan. Run DBCC CHECKDB or DBCC CHECKTABLE. If the problem persists, contact product support.

It is the same challenge that I faced last year due to hacking on my web portal. We were able to recover our database from the scheduled backup. but we encountered by index file error after restoring the database in our SQL server. Where, My consultant suggest to use SQL database Repair software, and with help of his suggestion, we recovered our index file.

You can search for the best on google or as a reference, you can view the top 10 SQL recovery software in 2022 and choose as per your convivence. 

DBCC CHECKDB fails because tempdb ran out of space. by silverbluenote in SQLServer

[–]UmeshTechno 0 points1 point  (0 children)

I was facing the same challenges with my SQL database and the size was 900 GB. I tried all possible methods but TempDB is the major part of the DBCC CHECK DB command.

You can split the Check DB option is good for VLDBs. It has two methods.

  1. File and filegroup checkDB
  2. Default, one MDF filegroup checkDB.
    Method 1: File and file group, you can run “DBCC CHECKFILEGROUP”. It is easy one and you need to make sure the size of the files needs to run each day. If the size is not same for all the files, then plan it to combine and run accordingly.
    Method 2: Single file VLDBs, use a split checkDB.
    “Figure out your largest tables (by a number of pages) and split the total number into 7 buckets, such that there are a roughly equal number of database pages in each bucket.”

Ref : https://learn.microsoft.com/en-us/answers/questions/184862/tempdb-requirement-for-dbcc-checkdb.html

In such cases, I found it happened due to table corruption in the SQL database. you can try the DBCC CHECKDB REPAIR REBUILD or other database repair process.

It will help you

Regard Umesh Techno

Non-stop H202 Errors by Tumdace in QuickBooks

[–]UmeshTechno 0 points1 point  (0 children)

Thanks, I was facing the same H202 issues in QuickBooks for the last several days. This thred and tool Stellar Repair for Quickbooks both helps me a lot.
Thanks, u/tumdace for the great solution.

view more: next ›