SQL Server 2017 - Administration

• Topics

  Started by

  Posts

  Last post

• Upgrade (2008 R2 to 2017)

  Hi Everyone, I'd like to canvas some opinion around the migration of a set of databases from 2008 R…

  tommcmaster

  2 replies

  6 years ago

  By: tommcmaster

• Connections during AG Failover

  Hello everyone, I am playing with Availability Groups for the first time (a bit late to the party) …

  J-M.L

  5 replies

  6 years ago

  By: J-M.L

• Weird network issue

  Hi, I have an ssis package, that when I run it from the virtual server (the package is deployed on …

  astrid 69000

  4 replies

  6 years ago

  By: astrid 69000

• Lincensing qn

  All, Somewhat new to SQL server licensing. Do we have to license the sql server database used in la…

  Ram

  3 replies

  6 years ago

  By: Ram

• Migrating 2008 (w/Filestream data) to 2017

  I am migrating databases from SQL Server 2008 to 2017. I have used backup and restore for some of t…

  iGBobH

  2 replies

  6 years ago

  By: iGBobH

• migrate package siis from 2008 to 2107

  good evening I need to migrate packages ssis 2008 to 2017 I am looking for a method to export my pa…

  abdalah.mehdoini

  4 replies

  6 years ago

  By: elenad80

• restore database dialog

  I have a few servers where in my restore database dialog/wizard for some reason the default path to…

  mlorek

  6 replies

  6 years ago

  By: MVDBA (Mike Vessey)

• Whose account the job runs under?

  I have a sql agent job that is called by a cmd file remotely using an admin account for example I w…

  sqlfriend

  6 replies

  6 years ago

  By: sqlfriend

• Using Storage DeDupe for AlwaysOn Availability Groups

  I have a Sr. Sysadmin here who wants to turn on storage dedupe for the three nodes that will be hos…

  lmarkum

  5 replies

  6 years ago

  By: Jeff Moden

• Data Migration Assistant Tool - overwrite existing database/file option

  Hi, We have use the DMAT to migrate our database from existing production 2008 R2 SE to a new test …

  steven.foo

  2 replies

  6 years ago

  By: frederico_fonseca

• Data Migration Assistant Tool

  Hi We are in the process of trying to migrate from MSSQL 2008 to 2017 SE. We are looking into data …

  steven.foo

  5 replies

  6 years ago

  By: steven.foo

• Backup sql server master service key

  I read from below link that : The service master key should be backed up and stored in a secure, of…

  sqlfriend

  1 replies

  6 years ago

  By: sqlfriend

• Integration Services - server name is blank

  We just installed the sql 2017 SE with the SSDT tool, SSMS 18.4. SSIS is selected during the instal…

  steven.foo

  4 replies

  6 years ago

  By: steven.foo

• Unable to Join Databases to AG

  I have a stand alone SQL 2008 R2 SQL Server that I'm migrating to a 3 node AG. At various times dur…

  lmarkum

  2 replies

  6 years ago

  By: Jeffrey Williams

• SQL 2017 Listener with Read-Scale (Clusterless environment) AG not working

  Hello, I have a Read-Scale AG set up.  I have it failing over back and forth just fine.  I am tryin…

  JP10

  9 replies

  6 years ago

  By: JP10