Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• I forgot sq password sql server 2012

  Hi I forgot sa password for sql server 2012 How do i get it ? Any windows login isnot on the server…

  MotivateMan1394

  1 replies

  11 years ago

  By: Joie Andrew

• It is possible to setup cluster in Windows server 2008 R2 Standard edition.... Because for me in Server manager --> Add feature --> check box for fail over cluseter, feature is not comming. Please help me on this.

  It is possible to setup cluster in Windows server 2008 R2 Standard edition.... Because for me in Se…

  rajeshjaiswalraj

  1 replies

  11 years ago

  By: Joie Andrew

• SSIS package fails when run in a JOB regardless if I run the job with the SQL Agent Service Account or a proxy

  System(s) Principal Server SQL Server 2014 Enterprise 64 bit 32Gb Ram 4 CPU(s) Secondary server sam…

  Reg_Mayfield

  4 replies

  11 years ago

  By: Reg_Mayfield

• Can SQL Server 2012 Management Studio and SQL Server 2014 Management Studio coexist on the same work station?

  Can SQL Server 2012 Management Studio and SQL Server 2014 Management Studio coexist on the same wor…

  mharding 65939

  5 replies

  11 years ago

  By: Anonymous

• Failover Clustering MS SQL Server Standard 2014

  Is there a limit to the number of 2 node instances you can install on a server using SQL Server Sta…

  sstepter

  7 replies

  11 years ago

  By: Jacob Wilkins

• What is the difference between DMV, DBCC and DMF

  What is the difference between DMV, DBCC and DMF

  rajeshjaiswalraj

  7 replies

  11 years ago

  By: Grant Fritchey

• Log shipping between SQL 2008 and 2014

  Hi, I'm setting up a new SQL server which will be running on SQL 2014, I want to log ship the datab…

  marcus 55319

  2 replies

  11 years ago

  By: marcus 55319

• open tran not showing in dbcc opentran

  is there any difference.. begin tran select *From table begin tran update table set id=some_value i…

  dastagiri16

  7 replies

  11 years ago

  By: Jacob Wilkins

• Virtual log files

  Hi, is there a better way to deal with the virtual log files?...I see several approaches in dealing…

  Agnii

  11 replies

  11 years ago

  By: Agnii

• SSMS's intelliSense

  I had SSMS installed for about 2 months. IntelliSense has been working until 1 week ago and it some…

  long.ng2000

  14 replies

  11 years, 1 months ago

  By: Alan Burstein

• Downgrading from 2014 to 2012; Upgrading Back to 2014 later

  We need to install SQL Server 2012 since the current ERP software that we utilize is not yet compli…

  steveburgess

  5 replies

  11 years, 1 months ago

  By: andrew gothard

• Would increasing RAM improve DB restore times

  Hi there - I understand that the disk I/O is the main performance bottleneck however if I increased…

  arrjay

  5 replies

  11 years, 1 months ago

  By: subramanian-357640

• SSIS log details

  Hi, Is there any way using T-SQL to find current running package name while SSIS logging is not ena…

  UmaShankar Patel

  1 replies

  11 years, 1 months ago

  By: subramanian-357640

• the original database is fine, but restoring database has consistency errors

  Hello, We have a client in another country, I have asked them to send me the full backup in a usb, …

  i1888

  10 replies

  11 years, 1 months ago

  By: Lynn Pettis

• Backup files not created

  Hi All, I run the following: EXECUTE dbo.DatabaseBackup @Databases = 'F1SB', @Directory = 'F:\SqlB…

  Igor Micev

  14 replies

  11 years, 1 months ago

  By: Igor Micev