No announcements
-
3 VotesSeparate DB and file share servers
Hello, We currently use one server for SQL database and a file share. I wanted to know if it is best practice to have separate Database and file share servers and does Microsoft ...Unanswered | 3 Replies | 84 Views | Created by Brad1981 - Tuesday, August 15, 2017 2:19 PM | Last reply by Chetan Vishwakarma - Wednesday, August 16, 2017 10:53 AM
-
0 Votes
SQL Queries to do the following list
Hi Team, Can you please help me to fetch the 1. List of all the views and its row count along with its size occupied ( ...Unanswered | 5 Replies | 64 Views | Created by Hemadribabu - Wednesday, August 16, 2017 6:21 AM | Last reply by Teige Gao - Wednesday, August 16, 2017 8:19 AM -
1 Votes
Users effecting Transaction Log backups.
So we have a database that is on a shared instance of SQL, and they are telling us that our transaction log backups are "best effort" due to the fact that we have db owner permissions and ...Proposed | 1 Replies | 74 Views | Created by James Ten Eyck - Monday, August 14, 2017 2:21 PM | Last reply by Shanky_621 - Monday, August 14, 2017 3:38 PM -
0 Votes
Multi Query (Central Management Server)
I have multi query which runs against the particular environment such as Non-Prod,Production etc., The results needs to stored in a particular server where ...Unanswered | 2 Replies | 95 Views | Created by kccrga - Tuesday, August 08, 2017 1:08 AM | Last reply by kccrga - Friday, August 11, 2017 3:55 AM -
0 Votes
DPM Backup failed due to SQL VSS writer
Hello, We are facing DPM backup failure due to SQL VSS writer. We are backing up file backup of application drive of SQL server using DPM. Everyday we get file backup failure when ...Unanswered | 4 Replies | 76 Views | Created by vjmehta - Thursday, August 10, 2017 12:24 PM | Last reply by Hilary Cotter - Thursday, August 10, 2017 2:30 PM -
0 Votes
Server TCP provider has stopped listening on port [ 1433 ] due to a failure. Error: 0x2726
Hi, Recently on one of our MSSQL server we have faced below issue Log ...Proposed | 2 Replies | 175 Views | Created by Ashu Lakh - Thursday, July 13, 2017 4:31 AM | Last reply by Ashu Lakh - Wednesday, August 09, 2017 4:23 AM -
0 Votes
Get destination IP address for successful login
Hi, I have an SQL Server 2012 server to which I have migrated databases coming from other older SQL Server instances. The server is ...Answered | 6 Replies | 195 Views | Created by Eduardo Mayoral - Thursday, August 03, 2017 7:20 AM | Last reply by Lin Leng - Friday, August 04, 2017 8:09 AM -
0 Votes
UI Layout of SQL Server Management Studio on a 4k monitor
Microsoft SQL Server Team: Have you tested Management Studio on a 4k monitor? Management studio has massive layout issues - like your developers ...Unanswered | 1 Replies | 112 Views | Created by D. Griebel - Thursday, July 27, 2017 10:18 PM | Last reply by Olaf Helper - Friday, July 28, 2017 5:54 AM -
0 Votes
SQL Server Agent job schedule to run other dependent jobs
Hi There , I have two sql agent jobs and I want them to run sequentially . 2nd job can only start after first job completes . Is there any ...Unanswered | 3 Replies | 132 Views | Created by Arpit2605 - Wednesday, July 26, 2017 6:55 AM | Last reply by AnandKannanIyer - Thursday, July 27, 2017 2:35 AM -
0 Votes
MS SQL Server consumes but not release RAM
I am using MS SQL Server 2008 R2. After the execution of scheduled backup procedure (maintenance plan) SQL Server process not releases the RAM. I 've read in ...Unanswered | 5 Replies | 136 Views | Created by AvraamBenefit - Tuesday, July 25, 2017 8:03 AM | Last reply by philfactor - Tuesday, July 25, 2017 12:22 PM -
1 Votes
Database mail works as user but not agent
Hello, I am trying to set up a job to send an email by executing a call to sp_send_dbmail. If I execute the query manually, the email is successfully sent. However, if I try to create a ...Unanswered | 3 Replies | 202 Views | Created by --Jon-- - Wednesday, July 19, 2017 3:50 PM | Last reply by Vishe - Sunday, July 23, 2017 10:16 AM -
0 Votes
sys.master_files missing database file info, DB available and sys.database_files shows the right information
Hi, In one of my production server i am missing database file information in sys.master_files catalog for 5 databases, the DB itself is available and ...Unanswered | 6 Replies | 170 Views | Created by Vinoth NM - Friday, July 21, 2017 9:00 AM | Last reply by Satish Kumar Gajula - Saturday, July 22, 2017 5:38 AM -
0 Votes
Regarding SQL Server 2016 License
Dear sir, Is available Server+CAL license model for Microssoft SQL Server 2016 standard Release Candidate 3(RC3) ? Thanks & ...Proposed | 3 Replies | 132 Views | Created by Mijanur Rahman Payel - Wednesday, July 19, 2017 11:41 AM | Last reply by Lin Leng - Thursday, July 20, 2017 4:31 AM -
0 Votes
SQL management 17.1 Database Properties failed
Hi , SQL management 17.1 Studio database Properties open failed legacy cardinality estimation is not valid ...Proposed | 6 Replies | 338 Views | Created by ÖmerÇarnaçar - Saturday, July 08, 2017 10:53 AM | Last reply by Lin Leng - Wednesday, July 19, 2017 5:25 AM -
1 Votes
How to check what processes or tasks that SQLSVR.EXE is running?
Dear SQL Server expert, our SQL SERVER 2012 DB Physical server is always high in memory utilization and always reach 96% or even 100% sometimes, which cause a ...Proposed | 3 Replies | 148 Views | Created by Henry2050 - Tuesday, July 18, 2017 8:42 AM | Last reply by Tom Phillips - Tuesday, July 18, 2017 11:53 AM -
0 Votes
Secondary data file viewer
I've got a MDF smaller than the NDF file. How can view ndf contents them migrate it to the MDB?Proposed | 2 Replies | 136 Views | Created by Robruk - Tuesday, July 18, 2017 9:54 AM | Last reply by Hilary Cotter - Tuesday, July 18, 2017 11:19 AM -
0 Votes
On Change Prevent is throwing error
Hi Policy was fine on 2008 R2, on 2016 SP1 CU2 it is failing with error below. I have found other blogs where CU3 was installed and it made no difference. Has anyone solved ...Proposed | 2 Replies | 193 Views | Created by MikeC250 - Monday, July 03, 2017 4:20 AM | Last reply by Charles L Gagnon MSFT - Monday, July 17, 2017 5:48 PM -
0 Votes
Sql Server Management Studio Unable to Browse Domain Accounts
When accessing SQL Server remotely on a domain client using the SQL Server Management Studio (SSMS), we've noticed that suddenly we cannot browse for users on the domain when attempting to add a new ...Answered | 2 Replies | 6231 Views | Created by Geary1123 - Saturday, December 08, 2012 2:00 AM | Last reply by bronxbomber2k7 - Thursday, July 13, 2017 1:52 PM -
0 Votes
SQL Azure
HI Team, I am an SQL DBA, Can some one suggest me the best way and the URL to master the SQL Azure DB please. hemadriDiscussion | 2 Replies | 170 Views | Created by Hemadribabu - Monday, July 10, 2017 12:09 PM | Last reply by KevinBHill - Thursday, July 13, 2017 11:58 AM -
15 Votes
SQL Server Configuration Manager – Cannot connect to WMI provider – Invalid class [0x80041010]
look at this post am getting the same ...Answered | 21 Replies | 60446 Views | Created by sql393 - Monday, May 07, 2012 8:24 PM | Last reply by Danny W. Pimienta - Wednesday, July 12, 2017 1:22 PM - Items 1 to 20 of 1980 Next ›
No announcements
