No announcements
-
0 VotesHow can i schedule the database backup to different location (Another Server)
HI Team, I want to take the database backup everyday but which needs to stored in another server. How can I do that ? Please ...Unanswered | 19 Replies | 227 Views | Created by RamTopen - Thursday, December 26, 2019 2:44 PM | Last reply by jeffw8713 - 8 hours 49 minutes ago
-
0 Votes
problem Report rdlc with sql localdb
System.ComponentModel.Win32Exception (0x80004005): The system cannot find the file specified at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException ...Unanswered | 1 Replies | 66 Views | Created by salim zekkoure - 12 hours 55 minutes ago | Last reply by Erland Sommarskog - 11 hours 49 minutes ago -
0 Votes
script for changing filegroup in partition schema
Here is the sample partition function and schema. I have included my requirement to change the file group "Need to Change FG" After merging the partition function and ...Unanswered | 1 Replies | 75 Views | Created by Venugopal Saride - 21 hours 42 minutes ago | Last reply by Dan Guzman - 13 hours 5 minutes ago -
0 Votes
Query on SQL Server 2017 Always-On
Hi All, DC1: (servers are in ...Unanswered | 2 Replies | 93 Views | Created by PraveenKumar_1999 - Friday, December 27, 2019 2:22 PM | Last reply by PraveenKumar_1999 - 16 hours 44 minutes ago -
0 Votes
How to find cpu & max mem setting on sql azure single database
sp_configure (managed instance only in azure), gives the info for max mem setting, I have a 'single database' in azure, how to find its max mem ... -
0 Votes
Create Database in Azure Blob Storage Error
SQL Server Version: 2019 (15.0.2070.41) OS Version: Ubuntu: 16.04 Followed instructions to create: - Azure Storage ...Unanswered | 2 Replies | 122 Views | Created by eschenfe - Thursday, December 26, 2019 5:35 PM | Last reply by eschenfe - Friday, December 27, 2019 3:41 PM -
1 Votes
Backup plan of sql server database
Hi, I have few databases and i want to backup them on daily basis. I want to make it schedule everyday at midnight 12 AM. I am planning to take ...Unanswered | 6 Replies | 159 Views | Created by RamTopen - Thursday, December 26, 2019 2:18 PM | Last reply by RamTopen - Friday, December 27, 2019 3:18 PM -
0 Votes
Diskspd and application database design decisions
I am curious to learn what design decision in SQL Server database design, that one should take after you understand disk subsystem capabilities using DiskSpd. Any pointers to ...Proposed | 3 Replies | 182 Views | Created by OneBlueBird - Wednesday, December 25, 2019 7:53 AM | Last reply by Cris Zhan - Friday, December 27, 2019 7:36 AM -
1 Votes
SQL server/Report server - ( services ) NT Service\MSSQLSERVER vs Network Service
hi, we have two servers , one run on NT Service\MSSQLSERVER & another one is Network Service . can you explain this ...Unanswered | 3 Replies | 103 Views | Created by KIRUBAKARAN J A - Thursday, December 26, 2019 11:54 AM | Last reply by Dawn Yang - Friday, December 27, 2019 6:05 AM -
0 Votes
Exception Type: System.OutOfMemoryException on DatabaseMail service
Hi, We have a Windows Server 2016 machine in Azure running SQL Server 2016. The server sends around 80 emails a day using DatabaseMail. These are all basically text or HTML emails ...Unanswered | 2 Replies | 239 Views | Created by Simon Darlow tRS - Monday, December 23, 2019 11:19 PM | Last reply by Simon Darlow tRS - Friday, December 27, 2019 2:26 AM -
0 Votes
checkdb
Hello, I have a SQL Server 2012 which is around 11TB. The checkdb takes around 80 hours. Can I restore the backup of this SQL Server 2012 instance on a SQL ...Unanswered | 5 Replies | 214 Views | Created by biltz - Wednesday, December 25, 2019 5:27 AM | Last reply by Cris Zhan - Friday, December 27, 2019 1:56 AM -
1 Votes
A network-related or instance-specific error occurred
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name ...Unanswered | 2 Replies | 110 Views | Created by Mayank Chaudhary789 - Thursday, December 26, 2019 5:15 PM | Last reply by Vaibhav-Chaudhari - Thursday, December 26, 2019 6:44 PM -
0 Votes
service acct ends up looking like nt authority\anonymous logon when it reaches the sql server
Hi we run 2017 std. I didn't know whether to post this in the ssis forum or here. The bottom line is that my test service acct has permissions to read on my sql server after we added it to the ...Answered | 13 Replies | 664 Views | Created by db042190 - Thursday, December 19, 2019 6:53 PM | Last reply by Tom Phillips - Thursday, December 26, 2019 5:29 PM -
1 Votes
INT math is slow in SQL server, but only under VMware - really weird!
20y, but I am really puzzled. Test is simple, no parallelism, no IO, limited memory use (L2,L3 caching is irrelevant) Results -- 31403 ms, one ...Unanswered | 32 Replies | 1784 Views | Created by tzimie - Monday, December 9, 2019 2:04 PM | Last reply by tzimie - Thursday, December 26, 2019 9:02 AM -
0 Votes
SSL Errors Connecting SQL Server 2014 database
I am getting the following error randomly while connecting to the sqL server 2014 database, any suggestion on how we can overcome the ...Unanswered | 3 Replies | 425 Views | Created by ManojRG - Sunday, December 22, 2019 1:41 AM | Last reply by Amelia Gu - Thursday, December 26, 2019 2:55 AM -
2 Votes
database performance degradation
On 20/11 starting from 8:00 A.M the application got "Timeout expired" error messages. We noticed database performance degradation. The DB was up, ...Unanswered | 19 Replies | 1304 Views | Created by juniorkiran - Tuesday, December 10, 2019 9:14 AM | Last reply by Erland Sommarskog - Wednesday, December 25, 2019 3:18 PM -
1 Votes
What can I do with a SQL Server 7 MDF/LDF file pair?
A new client has reached out to me because an application that they had written for them many years ago, running on SQL Server 7, circa 1998, has recently died. They have the MDF and LDF ...Unanswered | 5 Replies | 565 Views | Created by Jeffrey S Rosenberg - Friday, December 20, 2019 8:16 PM | Last reply by Cris Zhan - Wednesday, December 25, 2019 9:50 AM -
3 Votes
Why is Number of Connections always 1?
I have a web site that queries every 10 seconds for data via a restful call. Because I am logging after anywhere from 20 to 80 minutes I see this error/exception ...Proposed | 6 Replies | 352 Views | Created by andrewcw - Monday, December 23, 2019 3:48 PM | Last reply by Cathy Ji - Wednesday, December 25, 2019 8:04 AM -
0 Votes
Oracle Linked Server Issue
I am having a Linked Server from SQL Server 2012 to Oracle 11G. TNSPing and Test Connection to the Linked Server is working fine. But when using the Linked Server to run a stored procedure or when ...Unanswered | 12 Replies | 322 Views | Created by Abhi_SQL - Tuesday, December 24, 2019 4:31 AM | Last reply by Cathy Ji - Wednesday, December 25, 2019 8:00 AM -
0 Votes
Problem with XML parser memory leak
We're using xml parameters to send a collection of data to stored procedure. Typical (little simplified) use case would look like: DECLARE @Values varchar(max) = ...Proposed | 2 Replies | 173 Views | Created by Vukov Bosko - Tuesday, December 24, 2019 9:02 AM | Last reply by Amelia Gu - Wednesday, December 25, 2019 2:51 AM - Items 1 to 20 of 35086 Next ›
No announcements
