No announcements
-
1 VotesImpact on DB to shrink a 130GB log file?
Here is my setup: OS: Windows Server 2008 R2 Enterprise 6 x Cores 8GB RAM SQL: Windows SQL 2008 setup in a 2 ...Unanswered | 8 Replies | 72 Views | Created by Rickpo1212 - 23 hours 22 minutes ago | Last reply by Shanky_621 - 12 hours 3 minutes ago
-
0 Votes
How to enable remote connections in SQL Server 2008
I'm trying to enable remote connections in SQL Server 2008 R2 as described in the following article. I see the error message at the top of the ...Proposed | 4 Replies | 82 Views | Created by Bontrager - Sunday, February 22, 2015 6:45 PM | Last reply by bhanu_nz - 15 hours 16 minutes ago -
0 Votes
Send-MailMessage CommandNotFoundException
Hi, I have no issues running the Send-MailMessage on the Windows powershell on the server. However on the SQL powershell or through SQL Agent I get this message: The version is ...Answered | 7 Replies | 989 Views | Created by ptt2014 - Wednesday, April 23, 2014 4:40 PM | Last reply by BostonSean - Wednesday, February 25, 2015 7:01 PM -
0 Votes
SQL 2012 SP1 Task Name Missing from Maintenance Plan History
I have put lots of these in older versions of sql and task name always shows up. This is my first 2012 SP1 install. Here is a normal one from ...Answered | 2 Replies | 1194 Views | Created by benco5000 - Sunday, July 14, 2013 3:47 PM | Last reply by m1arino - Wednesday, February 25, 2015 7:44 AM -
0 Votes
SSMS 2014 > Registered Servers > Evaluate Policies Error
Hi When I try to select Evaluate Policies on a registered server, I get the following ...Unanswered | 4 Replies | 132 Views | Created by Sam Garth - Wednesday, February 11, 2015 4:26 PM | Last reply by Sam Garth - Tuesday, February 24, 2015 5:25 PM -
0 Votes
Which one has less overhead Availability groups or Replication?
I am planning to implement FCI+AG for DR. FCI at Primary data center, Standalone node at DR.(AG is perfect fit for this situation) As per our business requirement ...Answered | 3 Replies | 67 Views | Created by GRaju.dba - Monday, February 23, 2015 7:18 PM | Last reply by Ashwin Menon - Tuesday, February 24, 2015 4:12 PM -
0 Votes
Policy Based Management - multiple policies - email notifications
I'm just starting to use PBM and it seems like there's only one error number (34052) that can be trapped for scheduled policies in order to send automatic email alerts. How do you include which policy ...Unanswered | 2 Replies | 64 Views | Created by chuckh1958 - Friday, February 20, 2015 2:55 PM | Last reply by chuckh1958 - Monday, February 23, 2015 1:33 PM -
0 Votes
Maintenance Plans vs Scripts
There is a lot of discussion about using Maintenance plans vs Script for creating backups. Which one is best. Mr ShawDiscussion | 1 Replies | 60 Views | Created by Mr Shaw - Monday, February 23, 2015 10:51 AM | Last reply by Shanky_621 - Monday, February 23, 2015 11:12 AM -
0 Votes
Powershell and deploy SP
Is there anyway I can use powershell to deploy a SP to Multiple dabases in same server. I have to depoly the same SP to 50+ database and the list of ...Unanswered | 1 Replies | 77 Views | Created by SSAS_5000 - Thursday, February 19, 2015 11:08 PM | Last reply by princekumar8 - Monday, February 23, 2015 8:20 AM -
0 Votes
MSX - TSX Agent Enlist failing
I've combed online for a resolution to this issue without success. Trying to enlist some instances, but they are failing. - Firewalls are completely wide open between MSX and ...Answered | 2 Replies | 58 Views | Created by LakeErieVike - Friday, February 20, 2015 5:23 PM | Last reply by LakeErieVike - Friday, February 20, 2015 9:53 PM -
0 Votes
Cannot Design a table within management studio 2014
Hello, everything worked fine until recently. Not a new install. Database server in production. Now after I select a table and right click then choose ...Unanswered | 2 Replies | 80 Views | Created by Wiley007 - Wednesday, February 18, 2015 5:45 PM | Last reply by Wiley007 - Thursday, February 19, 2015 2:39 PM -
0 Votes
High CPU usage(92%) in Microsoft Sql Server 2008 R2
Hi, Server is having 12GB of RAM , But configured upto 4GB of RAM usage for Sql Server . But CPU usage is going max of 92%, because of which all other tasks stop ...Answered | 3 Replies | 102 Views | Created by appsoft1 - Thursday, February 19, 2015 5:27 AM | Last reply by Ashwin Menon - Thursday, February 19, 2015 12:05 PM -
0 Votes
The Management Data Warehouse version "00.00.0000.00" is not supported by the current data collector. Please upgrade the Management Data Warehouse by running the Management Data Warehouse Configuration Wizard.
I have setup SQL Server 2008r2 management data warehouse, and running collection set on another instance. I got following job error ...Unanswered | 2 Replies | 99 Views | Created by PAULqaz - Tuesday, February 17, 2015 8:18 PM | Last reply by PAULqaz - Wednesday, February 18, 2015 3:34 PM -
0 Votes
SQL Server backup Size decreasing gradually in last 30 days
Hi All, We have a client, where SharePoint runs in SQL. Here daily SQL backup has been configured in the Production for all SQL database. The DB size is gradually ...Answered | 5 Replies | 128 Views | Created by Raghu Raja - Monday, February 16, 2015 11:07 AM | Last reply by Olaf Helper - Monday, February 16, 2015 3:46 PM -
1 Votes
Is it possible to rename MSSQL Instance Name
Hi everyone, I have two sql instances installed in two node failover cluster mode, i want to rename one of my sql instance, is it possible to change instance ...Answered | 1 Replies | 109 Views | Created by Aditya Rathour - Saturday, February 14, 2015 12:59 PM | Last reply by Alberto Morillo - Saturday, February 14, 2015 2:00 PM -
0 Votes
suppress Encoding dialog after pressing "New Query" in SQL Server Management Studio
New->Query with Current Connection) a dialog box pops up. In its title bar is the word "Encoding". The body contains two things: the name of the tab its about to add ...Answered | 2 Replies | 7760 Views | Created by jklowden - Friday, January 14, 2011 9:29 PM | Last reply by Me.Saqib - Thursday, February 12, 2015 4:29 PM -
0 Votes
SQL Server 2014 Always ON - Secondary Replica Application Intent Apply READ_WRITE
Hi Microsoft SQL TechNet, Example Scenario : SQL 2014 ALWAYS ON PRIMARY Instance A, database ...Answered | 1 Replies | 102 Views | Created by douglas foong - Tuesday, February 10, 2015 9:30 AM | Last reply by Lydia Zhang - Wednesday, February 11, 2015 5:59 AM -
0 Votes
Error when running Maintenance plan
Hi, I get this error when I double click on our Maintenance Plan in Management Studio. Any Ideas?Answered | 7 Replies | 159 Views | Created by duncanwarrender - Wednesday, February 04, 2015 12:34 PM | Last reply by Michelle Li - Tuesday, February 10, 2015 2:03 PM -
0 Votes
Wait Type PAGEIOLATCH_SH and PAGEIOLATCH_EX
Hello, I am looking at the performance issue on one of the SQL Server which is for Zenworks. There are 4 application server which reads and writes to ...Answered | 7 Replies | 138 Views | Created by Mohan Chhapadia - Thursday, February 05, 2015 11:07 AM | Last reply by davidbaxterbrowne - Thursday, February 05, 2015 3:33 PM -
0 Votes
Where does SQL server log warnings and critical errors?
I am asking for the following reason: 1. While I know T-SQL in general, I am no SQL Server admin. 2. Recently we had a SQL Server "crash" on ...Answered | 3 Replies | 89 Views | Created by sking_coins - Wednesday, February 04, 2015 9:28 PM | Last reply by Niting123 - Thursday, February 05, 2015 11:20 AM - Items 1 to 20 of 1350 Next ›
No announcements
