BLOCKSIZE makes a big difference when backing up to...

At that size I think you need to be looking at snapshot backups. To me, completing that large a backup in a little over a day is actually pretty...

How many backup files are you creating with these backups?

What...

I suspect that this is actual data from your company's databases.  There does not appear to be any personal information in this, but in many organizations publishing corporate data in...

I'm curious as to what measurable benefit you realized from performing reindexing / reorg on your indexes?

Hi,

My .mdf file is accidentally deleted at client's place and without bothering the system is also being used for more than a week. So system file recovery was not...

• This reply was modified 1 year, 1 month ago by  Michael L John.

What are the possible solutions for "ASYNC_NETWORK_IO" wait. When I tried to execute the query its returning results in 4-5 secs. But from application it taking ages.. eventually we...

How many files?

Have you attempted to adjust the MAXTRANSFERSIZE and BLOCKSIZE parameters?  For Azure blob storage, these would be indicated.  MAXTRANSFERSIZE=4194304 ,BLOCKSIZE = 65536

Haw large are the backup files compared...

I'm guessing you have a table with...

Why do you need your CMS to failover?  Unless the entire server is unavailable, then you can always connect to the server where your CMS is located.

You can automate the...

Thank you for you reply.

Reason behind is every night whole VM backup taken and backup completion time 2.5 Hours ,

during backup time AG got failover automatically to node2 due...

• This reply was modified 1 year, 1 month ago by  Michael L John.

The secondary's can only be read only.  That would likely not be able to to be changed.  I know changing the owner does not propagate.  I have had to do that. ...

It sounds like you need to look at mirrored backups.

https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/media-sets-media-families-and-backup-sets-sql-server?view=sql-server-ver16

On a personal note, I just don't understand companies that post a webinar and, to register, they REQUIRE you have to provide your phone number and, frequently, a...

• This reply was modified 1 year, 2 months ago by  Michael L John.

All,

I'm new to Powershell so this could be a simple error.

I'm using a SQL agent job to backup a database to a UNC path and then rename it.

The step...