SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• Error: 15006 'username' not a valid name because ...

  Dear I'm new to SQL and trying  to learn the basic in a practical way. The error: TITLE: Micro…

  hara_mo

  6 replies

  7 years ago

  By: Chris Wooding

• Availability Group Database - Resize of LOG file causes Transaction Log use to grow significantly

  SQL Server 2016 - 13.0.4541.0Availability group setup with 2 replicasMost databases reside within t…

  tking 39890

  6 replies

  7 years ago

  By: tking 39890

• Partition design questions for DW fact

  I can understand the benefits of partitions for a large fact table -  let's say partitioned by…

  leehbi

  2 replies

  7 years ago

  By: leehbi

• failed to access remote registry on server ensure that the remote registry is running and have remote administration enabled

  While doing validate configuration with 2 nodes, under failover cluster manager ... getting below w…

  databases.specialist

  1 replies

  7 years ago

  By: Kimberlin

• Installation trauma

  I'm doing a new sql 2016 enterprise install on a windows 2016 server.   One error was gen…

  fizzleme

  1 replies

  7 years ago

  By: Kimberlin

• Always on Availability Groups 1 node belonging to 2 always on groups if possible?

  Hello, just like the subject says, is it possible to have 1 node belong to 2 different always on av…

  Siten0308

  1 replies

  7 years ago

  By: Kimberlin

• Changing @@SERVERNAME

  I have a 2-node AlwaysOn cluster on GCP. Because they were built via imaging, they're both named IM…

  robin.pryor

  1 replies

  7 years ago

  By: Andrey

• Looking to downgrade our SQL Server editions from Enterprise to Standard Edition

  We're looking to downgrade our SQL Server editions from Enterprise to Standard. Contacted our vend…

  bobba

  9 replies

  7 years ago

  By: Andrey

• AG Failover alert

  I have created an alert using the script below to see if I get an email if there is a failover but …

  LearningDBA

  11 replies

  7 years ago

  By: Sue_H

• Distributed Replay

  ive got a trace of some end of month activity (that is time sensitive and i cant just recapture) th…

  LAW1143

  6 replies

  7 years ago

  By: Chad Crawford

• Availability Group databases not syncing

  Here is our setup:PrimaryRead-Only secondary, synchronous modeDR secondary, not read-only, asynchro…

  Michael L John

  2 replies

  7 years ago

  By: Michael L John

• SET PARTNER TIMEOUT mirroring

  HELLO EVERYONE Who has an idea what exactly is this command for? ALTER DATABASE [abd_prod] SET PART…

  abdalah.mehdoini

  3 replies

  7 years ago

  By: Michael L John

• No matching network interface found for resource 'Cluster IP Address' IP address 'xx.xxx.245.140' (return code was '5035'). If your cluster nodes span different subnets, this may be normal.

  Error and Warnings are ....Cluster resource 'Cluster IP Address' of type 'IP Address' in clustered …

  databases.specialist

  1 replies

  7 years ago

  By: robnsilver

• trying to give user owner permission to database, but says another database is missing object?

  Hello, I am trying to run a simple changeowner statement: USE [database18]GOEXEC dbo.sp_changedbown…

  Siten0308

  2 replies

  7 years ago

  By: HandyD

• get rid off NOT FOR REPLICATION property

  Hello, I dropped a local publication and a subscription, however I still see a table in publication…

  inHouseDBA

  2 replies

  7 years ago

  By: Bart Lewandowski