Viewing 15 posts - 1 through 15 (of 43 total)
Hi Deubel, could you elaborate further on what sort of script i need to run?
So does this means I do not need to backups any of my system database...
October 1, 2024 at 7:08 am
Thanks for all the reply.
Just 1 more thing to clarify, if I were to upgrade my database from SQL 2012 to SQL 2019 & I want to retain all...
September 24, 2024 at 9:32 am
September 24, 2024 at 9:31 am
The most important question is: How much downtime do you get?
September 6, 2024 at 4:46 pm
What is there to be confused about?
You have two servers, and two accounts. One is a sysadmin on one server, the other is not.
Sysadmin is the highest level of...
August 21, 2024 at 5:21 am
I hope the text below helps you understand.
SQL Server provides server-level roles to help you manage the permissions on a server. These roles are security principals that group other...
August 19, 2024 at 7:52 pm
Due to security i could not export data from the particular DB. I imported the very same flat files into my personal DB , with no issue. YOU could...
July 28, 2024 at 6:03 pm
Due to security i could not export data from the particular DB. I imported the very same flat files into my personal DB , with no issue. YOU could...
July 28, 2024 at 5:59 pm
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
Viewing 15 posts - 1 through 15 (of 43 total)