SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• Migrating Database Engine, SSIS, SSRS off of a server to have SSAS be on its own server

  I have a requirement to make an existing server only run SSAS and migrate the Database Engine(and t…

  ericwenger1

  5 replies

  8 years ago

  By: FridayNightGiant

• IN-Memory tables

  Hello All!I would like to know what is the the pros & cons of In-Memory tables in SQL Server 20…

  89netanel

  7 replies

  8 years ago

  By: Alan Burstein

• Fastest Refresh of a Database

  What is faster, doing a backup of a database, then sending the file over the network and restoring …

  steveg5000

  8 replies

  8 years ago

  By: Nadrek

• I want get html report from log shipping

  I want to get HTML report from log shipping, here is my script... please modify it  ##setup da…

  manu.manohar033

  7 replies

  8 years ago

  By: Sue_H

• use T-SQL to change Logging level of SQL Job

  Dear Forum Members, I have a SQL Job that runs an SSIS package. This job is configurated to use Bas…

  river1

  1 replies

  8 years ago

  By: river1

• Database discovery tool

  Is there an enterprise tool to perform assessment of a huge database stack with SQL Server, Oracle,…

  Benki Chendu

  4 replies

  8 years ago

  By: HappyGeek

• copy all database instance to another sql server dbatools

  Dear all,I tried to move several databases from one instance to anotherI used the dbatools Copy-Dba…

  joujousagem2006 1602

  3 replies

  8 years ago

  By: RandomStream

• "Exception has been thrown by the target of an invocation" Error

  Help pls new here, i keep getting this: at System.RuntimeMethodHandle.InvokeMethod(Object target, O…

  kelch4n_35

  3 replies

  8 years ago

  By: Sue_H

• SSISDB ( data compression)

  Dear all, As part of maintaining my SSISDB I am thinking in compress some tables (data compression)…

  river1

  2 replies

  8 years ago

  By: river1

• SSISDB (Compress Data)

  Dear all, I have my SSISDB with same big tables. I have now the correct setup in terms of version s…

  river1

  1 replies

  8 years ago

  By: river1

• Restarting SQLServerAgent

  Since I have jobs and stored procedures that need to write to network locations, I run both SQL Ser…

  Eliyahu

  4 replies

  8 years ago

  By: Eliyahu

• Backup failures

  Backups are failing with below errors.Any suggession please.Thank you !! MessageExecuted as user: X…

  adisql

  3 replies

  8 years ago

  By: adisql

• Multiple AG groups in one Windows failover cluster?

  In an organisation I found the following setup: Six VMs SQL1 to SQL6 in the same domain, each …

  Blue Mancunian

  8 replies

  8 years ago

  By: Perry Whittle

• Transactional replication - which articles caused the failure

  Hi I have a Push Transactional replication process. I use the GUI to add multiple stored procs as a…

  Casper101

  2 replies

  8 years ago

  By: Sue_H

• Enable-SqlAlwaysOn cmdlet used to enable AlwaysOn for a SQL Server service is failing

  Hi there I am developing some PS scripts to set up an AlwaysOn availability group. I am trying…

  doodlingdba

  1 replies

  8 years, 1 months ago

  By: doodlingdba