Viewing 15 posts - 1 through 15 (of 35 total)
I would like to understand how to create auto job to take the full backup, transaction backup + truncating the log files(without making the database to simple recovery mode...
March 5, 2024 at 5:22 pm
Why do you make backups with Veeam and with SQL Server? If Veeam B&R is configured correctly it truncats the logs for you. But I'd prefer SQL Server backups. With...
March 4, 2024 at 7:26 pm
Maybe a screenshot would make things clearer.
February 24, 2024 at 6:27 am
I have absolutly no idea what you are talking about. Running jobs in sql server agent does not require rdp sessions so far. Just a SSMS and the corresponding permissions....
February 23, 2024 at 3:51 pm
Well a file share isn't shared storage. Just for the record. Obviously you want us to authorize you to remove it. Go ahead remove it and tell us what happend....
February 23, 2024 at 2:44 pm
Another DBA mistakenly created a file share witness for one of our ao clusters. To make matters worse, it's pointed at a server we decommissioned. The cluster doesn't seem...
February 23, 2024 at 4:36 am
It's not that difficult. On the starting page of the dialog choose as server typ "SQL Server". Create a login on the remote sql server. On the Security Tab choose...
February 22, 2024 at 7:56 pm
Go ahead. A google search will bring you the results you are looking for.
February 20, 2024 at 6:21 pm
I can't recommend Veeam for SQL Server backups.
February 13, 2024 at 8:44 pm
Our issue is that NSLOOKUP for AG Listener Name (ZZZDBAG) returns one IP address, sometimes two, and sometimes nothing, which is unusual. Is it supposed to return only one...
February 13, 2024 at 8:41 pm
google is your friend. There are heaps of sites about alerting and how to set it up.
October 13, 2023 at 6:38 pm
deubel_m wrote:Hi Andreas, how large is the sysjobhistory? Can you manually rebuild the index?
Same question. What problem is being solved by rebuilding the indexes?
The problem is not solved, if...
August 1, 2023 at 3:11 am
Hi Andreas,
how large is the sysjobhistory? Can you manually rebuild the index?
July 31, 2023 at 5:54 pm
@jeffrey williams
417 VLFs showing
File Sizes between some KB and 2-7 GB
Autogrowth / Maxsize: By 10 percent, Unlimited
You should change that immediatly.
After you shrunk the logfile set an appropriate initial...
May 12, 2023 at 8:17 am
Of course it will work. Put your database in simple mode, shrink your log file and go on. That's my daily work, works always and that's the way...
May 12, 2023 at 8:15 am
Viewing 15 posts - 1 through 15 (of 35 total)