SQL server – Backup too important to restore

I have a backup which in the file explorer is about 160 GB.

If I run

select sum ((size * 8) / 1024) From sys.database_files where type = 0

I get a result of 169493, good.

When I try to restore this database to another server (the former database administrator created a job that automatically restores the database every morning from the last backup, and then runs DBCC CHECKDB). If I try to VERIFYONLY RESTORE, it turns out that I need 288 GB for this to work. Why? The backup is not compressed.

Thank you

Is the Acronis Backup service better than R1Soft?

JoneSolutions (one of the benchmarks in the web hosting industry) recently noticed
has stopped offering Idera R1Soft backup and has changed its … | Read the rest of https://www.webhostingtalk.com/showthread.php?t=1783973&goto=newpost

Automatic backup and protection system for Openload and Verystream videos 100% FREE | NewProxyLists

Active since 2016, Streamdefence.com is a protection service for external videos such as Openload, etc.
In addition to offering many protection and encryption services for your videos, stramdefence is the only service to offer an automatic backup of your videos on Openload.co and Verystream.com.
How it works? Each time you insert an integration into streamdefence, the system creates a copy of your video. If your video is deleted (for DMCA or other), the system will make the backup appear automatically. You can see here an example of video with openload, but also works with Verystream

For customers who use wordpress, we have a plugin that allows you to automate everything. your videos will be protected by posting normally. You can download it here.

The service is 100% free without registration and your videos will not be deleted anymore;)


Recover WhatsApp discussions and backup stickers crushed on Android

There was some sort of lag in WhatsApp so I decided to erase the settings data without knowing that it would erase the chat backup. After that, I reused WhatsApp and did not show an option for local restore, but only a restore from Google Drive. But I have not made any backups on G-Drive in the last 6 months. I just restored the G-Drive messages but I lost most of the important informative discussions. Now a new local backup has been created automatically. Please indicate if there is a way to recover the previous backup of the chat.

Thank you.

SQL Server 2012 – Backup of Log Shipping

By performing a full backup (non-copy only) in primary mode, does this affect the log backup LSN chain and prevent log shipping from working?

No never. The full backup has NO impact on the transaction log backup chain, it will not interrupt the log processing. I strongly suggest that you read Paul Randal's Backup Myths section.

can I perform a full backup and a differential backup at the main level, and then for the log backup, can I use the log backup performed by sending logs to a shared folder for recovery in case of failure the main server and the secondary server?

Yes, you can not, neither a full backup nor a diff backup would prevent the sending of the logs, although your request seems strange to me. If their database is LS and you want to restore a full backup, diff, and log, be sure not to delete the log backups from the shared drive after crossing the threshold in LS.

sparsebundle – Check the backup of the time machine

After this problem, I restored the entire shared folder from my NAS version manager. However, perhaps because of the size of the image (more than 600 GB), the version manager confirms neither failure nor success. Since the restored image is almost the same size, I guess I can use it.

To check the image, I launched an fsck and it is successful. Then I started to use it normally and Time Machine does not seem to indicate that the image is corrupted.

However, I wonder if it is possible that some of the tapes are not recovered correctly and fsck does not recognize them. fsck_hfs is only responsible for analyzing metadata, not data, and time machine works primarily with metadata in terms of drift comparison.

It is true that fsck_hfs can scan the entire drive (-S). Through hdiutil, -verbose and -debug, it will display information about reading / writing tapes, but there is no documentation on how to read it, or fsck_hfs fails if a group is not find.

I need a way to check my back up machine backup.

backup – Can not add a shared drive as a Time Machine drive

I have a Mac Mini on my network with an external hard drive mounted on it. I use this external drive for Time Machine for some computers.

Everything was fine until today, when I had a new Mac Mini. I've migrated all my documents to the new machine, mounted my backup drive and tried to add it as a Time Machine backup drive in my Macbook Pro. I receive the following error:

Time Machine can not connect to the backup disk.

The operation could not be completed. (Error OSStatus 13.)

I have tried several troubleshooting tips. Restarting both machines, rebooting the external box, even reformatting the backup disk (nothing important has been lost … I hope).

Like a possible hint at a root problem, Finder -> Go -> Network -> (Computer) -> Backups also generates an error:

The operation can not be completed because the original item for "Backups" can not be found.

Both machines use macOS 10.15.

SQL Server – Should I query from a snapshot or use a backup for reporting purposes

I have a very large selection query for report purposes that can take up to 1 to 2 hours.

There are some problems with this query.

  1. It takes too much system resources and this server can not support the load, the database is also shared on the same server with 30 other dbs.

  2. The request is very large and read / write performance suffers. Sometimes the tables are locked so I can not update.

The database is used in an application and for reporting purposes. We have another server in a different location where we can host the database.

The application is working correctly as is on this server, the problem comes with the reports. My solution is

solution 1:

  1. Create the same database on the other server for reporting purposes.
  2. Run timed jobs to put a backup file in a shared location
  3. Back up the database from the backup file that is stored in the shared location.

One of the DBAs tells me that it's too much work unless

solution 2:

  1. We move the application database to the other server.
  2. Create the copy database and host the two databases on the same server.
  3. Run a timed job for backups
  4. And then save the database of reports.

I do not see how it is too hard. I do database backups all the time but I have never done backup of a file in a shared location. But it seems to me that it's the same process.

If solution 2 is in fact a simpler solution, why is this the case?

Limitations of the backup and recovery module

What are the limitations of the Backup and Restore module?

More specifically, I am curious to know what is the largest database it can handle, the time it can execute before failing, etc.?

backup – Catalina update fails, no bootable disk, can not access files

I'll start by saying that my problem is incredibly similar to that of Mac being stuck in the reboot cycle after the macOS Catalina update failed, but being a new user, I could not comment there nor unfortunately answers.

A member of my family has reported that Mac is stuck in the restart loop, there is no recent backups to restore and can not lose the files stored on the drive (yeah … I know …).
Trying to reinstall Mojave on the same drive via recovery mode causes the exact same loop with the same error message (insufficient space available).

Ideally, I would have booted the Mac from another drive, cleaned / backed up some files to free up space and proceeded to normal installation BUT, once I climb the Mac hard drive in trouble, I see two partitions:

1) "Backup (original drive name)" – 480 GB wide but no visible files
2) "Macintosh HD" – seems to contain only Mac installation files

Basically, I can not find the original files. I guess during the installation process, the OSX installer created a backup partition (1) and would have restored the files once the installation was complete, but I did not know how to access to these files.
Everyone knows at least one way to access the files in what appears to be a backup partition created by the setup program?

Sorry for the almost duplicate question and thank you all for reading.