Questions tagged [automation]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
7
votes
3answers
14k views

Restore All Databases Script

I am migrating SQL Server DBs to a new instance. I have been told that it is possible to dynamically build a RESTORE script from available backups in the system catalog. Does anyone know of a sample ...
5
votes
3answers
55k views

script to show all the permissions for a table

inside my database I have a procedure called spGen2_tblIE_SchedProcess_Update. when I run this script select * from sys.objects where name = 'spGen2_tblIE_SchedProcess_Update' Inside the same ...
3
votes
2answers
964 views

updating statistics using STATS_STREAM or WITH FULLSCAN?

the syntax for creating statistics is: -- Syntax for SQL Server and Azure SQL Database UPDATE STATISTICS table_or_indexed_view_name [ { { index_or_statistics__name ...
0
votes
1answer
3k views

SQL Mail Failing To Send

SQL Sever 2016 with the latest updates. Running on WS2012R2. Following error message is received: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail ...
4
votes
2answers
10k views

How to find Oracle's installed version and release from a program?

I need to determine from a program what version of Oracle is installed in each of the Oracle Homes on a server. As there may not be any databases created in the Home yet, I need to be able to do this ...
2
votes
1answer
156 views

Trace flag is running, but not message when deadlock happens

Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior More information on the trace flags are here DBCC TRACESTATUS this above, is the ...
2
votes
1answer
360 views

Having the backup file, how to work out the total disk space required to do the restore?

I have a nice query that gives me the date of last full backup, size and location, even when I backup to multiple backup files. what I don't have is an estimate of the total backup size (for each of ...
1
vote
2answers
4k views

is it possible to alter the primary key of a table (from non clustered to clustered) in the subscriber only and not break the replication?

I have a table that has an clustered unique index and a non clustered primary key with the same structure as the index. IF OBJECT_ID('[dbo].[tblBAccountHolder]') IS NOT NULL DROP TABLE [dbo].[...
0
votes
2answers
35 views

How do I find out whenever a value changes in a certain column?

Need help if anyone can offer! I currently have my select statement returning the TOP 1000 * results from a table. They are CC numbers that are currently active. I'd like to see how I can go about ...
19
votes
2answers
10k views

Is there a cool way of performing CU updates for SQL Server on hundreds of machines?

My company has grown from 50 SQL Servers to over 200 overnight in a merger acquisition. HELP! My questions are: How can I perform CU updates on this many servers and still have a life and keep my ...
4
votes
2answers
2k views

how to script out the user defined table types?

I can Get name and definition of all table types using either of the following scripts: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED IF OBJECT_ID('TEMPDB..#RADHE') IS NOT NULL DROP TABLE #...
2
votes
0answers
930 views

How do I create an automated SQL Server restore script for multiple backups? [duplicate]

I basically have 6 daily SQL Server backups (.bak) that need a restore everyday. I want to automate this process by having the SQL Agent run the script daily. I have the following restore script ...
0
votes
1answer
32 views

what databases are already set up in the log-shipping, and which ones are not?

I am setting up log-shipping from server1 to server2. there are many databases on server1 and I want to automate the process. I have already done a few databases manually, while I am working on the ...
0
votes
1answer
21 views

Does mongo *really* need a dedicated volume, if I need to back it up?

TLDR; What's the easiest way to automate a mongodb backup of a 20-gig DB? We run mongo on the same KVM (VPS) as the web app; the server runs Debian. We/I don't need/want to backup the entire fs on a ...
0
votes
1answer
93 views

MariaDB Master / Slave failover / failback automation

Good day all, I'm hoping someone might be able to point me in the right direction. I'm working on a new dual data center project, and I'm trying to come up with a plan for failover (for patching and ...