Yes, new file will be in the same filegroup. Driver is that, how I now one big file is not good for best practices. Our database grows and this is...

This is my fault. I forgot about one other step, which release additional steps 🙂

Thanks everyone for replies.

We can't set DB to single user mode. Because application must work and transactions must be commit. We thought about restore point in time variant and it...

Thanks for reply. But I don't care about size. My problem is state before COB. Before COB backup must not contain any transactions, because by our business policy, if we...

It happens rarely, but after last time we have problems. And now I want to know why it happens.

There are errors like:

Cluster resource 'dbalwson' of type 'SQL...

Thanks for reply. How can I check lost quorum? Now it's ok, because there isn't any problem in secondary node. But I'm afraid if there will be problem again, it...

Thanks both. I will backup up manually databases, system databases and save scripts to create logins, jobs, linked servers.

I found how can I do backup of all agent jobs, logins and other objects:

1) Start SQL Server Management Studio.
2) Expand the SQL Server Agent folder, and...

I find a new problem and think this is a reason. We have a program which connect to database with SQL user and take backup everyday. Every backup with this...

I run query I run query restore verifyonly from disk='F:\BACKUP\ABAPROD-DOC_F0135_20180901221217_AFTERCOBFULL.bak'; and it output in SQL Server logs this message:'; and it output in SQL Server logs this message:
[code...

With sa user there is an error in error logs:

"Cannot open backup device "\\xxxxxxxx\xxxx.bak". Operating System Error 5 (failed to retrieve text for this error. Reason: 15105)....

Is there another way to restore database? Or how can I check corruption?
When I restore in SSMS 2008, it gives me error which I said before.
But when I...

Sorry for my mistake. Both servers is SQL 2008 R2. And I checked, you are right. SSMS is not matter, I take backup vis SSMS 2017 and restore it on...

Yes, it will be good to do it by scripts. Because I'm new, I'm afraid of code and afraid to forget to check some options. And now for me GUI...

In DEV and TEST many time I restore by sa user, but sometimes with Windows account. There isn't any problems during restoration. It's easy and secure for me, to restore...