Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Create SQL Login to View only one database on server

  Hi All, I have one task to create a login, and user need to view only One Database, there are 20 ot…

  yogi123

  5 replies

  5 years, 2 months ago

  By: Sue_H

• xp_delete_file does not remove older backup files

  Hi All, My issue is the following: O.S. Microsoft Server 2012 R2 SQL Server 2014 with mixed autenti…

  mauro.branca

  11 replies

  5 years, 2 months ago

  By: as_1234

• Logshipping

  i configured logshipping b/w two servers , when i checked the file location of secondary database ,…

  ramyours2003

  1 replies

  5 years, 2 months ago

  By: Steve Jones - SSC Editor

• Primary Data Files

  Good day experts, I added a second mdf file to my database but the second file is not writing any d…

  tmmutsetse

  6 replies

  5 years, 3 months ago

  By: tmmutsetse

• error while setting up linked error

  Hi I get the error Client and Server cannot communicate...they do not posses a common algorithm how…

  atulyan.aries

  1 replies

  5 years, 3 months ago

  By: Mr. Brian Gale

• creation of sql authentication login with a specific requirment

  Hi All, As an admin we create sql authentication logins for application users. For those logins, we…

  vsamantha35

  3 replies

  5 years, 3 months ago

  By: Ant-Green

• CDC locking tables?

  Hi We enabled CDC for a few tables in a Dynamics AX database and immediately some AX batch jobs got…

  jtke

  5 replies

  5 years, 3 months ago

  By: jtke

• Sum of all Memory Clerks and Total Server Memory (KB)

  I am trying to understand the memory management of SQL Server. I have a Windows Server 2019 on virt…

  RaufDBA

  1 replies

  5 years, 3 months ago

  By: RaufDBA

• OPENQUERY giving wrong result on linked server

  I have setup linked servers on my SQL Server and choose Oracle as a linked server. SOMETIMES, When …

  RaufDBA

  14 replies

  5 years, 3 months ago

  By: Lynn Pettis

• Avamar Backup--Is it good?

  Dear Experts, is it good to use Avamar backup for SQL Server, currently we are using Ola's scripts.…

  VastSQL

  10 replies

  5 years, 3 months ago

  By: DeWayne_McCallie

• Nutanix - 'misaligned log IOs which required falling back to synchronous IO’

  Hi I have restored a SQL database onto a nutanix VM, the disks are formatted to 64k. When restoring…

  sqlguy7777

  5 replies

  5 years, 3 months ago

  By: angelinemarren

• File entry not removed from sys.database_files after Alter Database Remove file (AlwaysOn)

  HI Guys, We have used "alter database DBname remove file filename" to remove some extra files that …

  jesijesijesi

  4 replies

  5 years, 3 months ago

  By: vamshichiranjeevi.g

• Any way to guesstimate internet needs for remote DBA?

  I am starting a new remote SQL DBA position. Normally I have high speed unlimited internet. But I…

  nancy.lytle

  18 replies

  5 years, 4 months ago

  By: inigowilson

• Restore from Prod to Dev

  I am looking a way to restore production data to our dev and QA environments for user database.  In…

  Admingod

  14 replies

  5 years, 4 months ago

  By: Admingod

• Microsoft SQL Server Management Studio - Creating a backup file

  I am manually creating a SQL backup file and the backup failed for server: domain\NamedDB. (Microso…

  jason25

  1 replies

  5 years, 4 months ago

  By: Mr. Brian Gale