No announcements
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Unanswered0VotesSQL Server 2008 R2 version
Hi, I installed sql server R2 Managment studio, a new inastance of sql server appear : 1. this instance is not working. 2. the version is ... -
Unanswered0VotesError when restoring SQL backup.
Hi all, I have the next error when restoring a .bacpac (SQL backup from Azure) to On-Prem SQL Server: The ALTER TABLE statement conflicted with the FOREIGN KEY ... -
Answered3VotesSQL 2008 R2 Right Sizing for Memory
Severall of our SQL 2008 R2 servers are using up 95% of the available RAM plus all of the dedicated PageFile drive(s), which is pretty normal from what I see. zAdding more RAM and Pagefile does not ... -
Unanswered0VotesVS 2010 Importing Table into Database Project Error
Our team has been stumped by using the VS 2010 Schema Compare tool and adding an existing table and its constraints to the VS 2010 Database Project. One team member can do this no ... -
Unanswered0VotesHow to know SQL Server Idle Time
Hi Everyone, I am Phani, I am beginner to SQL Server. I would like to know the idle time of SQL server (If there are no hits from past 30 mins, then consider it ... -
Unanswered0VotesSQL Server restore created copies of everything
When we did a SQL Server restore, it created copies of everything in directories. Was there a mistake we made with the backup or restore that would cause this? Thanks! -
Proposed0VotesMicrosoft SQL server 2005 Companct
I have a Dell Window 8 desktop computer I purchased Microsoft office 365 home premium en us. In my control panel under programs and features I have Microsoft SQL service 2005 compact edition ... -
Unanswered1VotesSPN for trusted domain
Hi Guys, Sorry if this is in the incorrect forum, wasn't sure where to post it. We have two domains, our office and then our production site. There is a trust and ... -
Answered0VotesSSMS Maintenance Plans for SQL Server 2005 Database Backup Fails.
Hi SQL Experts, I am SharePoint Admin and Also I am now handling the Sql backups and Restore. I am some sort of Accidental DBA. I don't have depth Knowledge of SQL But i Can Know ... -
Answered1VotesTorn Page in sql server
I detect torn_page_detection in sys.databases so I ran below query SELECT * FROM ... -
Proposed0VotesSQL Server 2008 R2 Failed to acquire connection "Local Server Connection"
Hi, at we have been using the Maintenance Plan in SQL Server 2008 R2 to do backups and other tasks. I am not sure what exactly happened but under every instance on this server we are getting the below ... -
Answered0VotesSQL Server 2008, Host Machine Shutdown Process
1. I have an AWS (Amazon Web Services) EC2 Machine (say CubeSRV1) Instance that has a Microsoft SQL Server Analysis Services running on it, which hosts a cube database on it. 2. I ... -
Answered0VotesBug in Management studio 2012?
Hi all, I was trying to set data compression to "None" on a table and got an syntax error. Setting data compression on the table works ok, ... -
Unanswered0VotesPerormance problem when two application running in Parallel
Hi Experts , i need some help on Performance problems I have a symantec LOG Backup which runs 7am,10am,1pm,4pm backups to different Server ( as per company rule ... -
Answered0VotesMemory Configuration suggestion
Do i need to do any memory related settings for below server Windows 2008 R2 Datacenter Edition , 97.7 GB RAM,64-Bit ... -
Answered0VotesSQL Agent Job History Best practices
A server has agent jobs set for different intervals (Daily, Weekly) plus five replication jobs interfacing with a dozen or so subscriptions. Obviously the replication jobs ... -
Answered0VotesHow to prevent programmer using SA in SQL?
Hi all, In past 10 years, our programmer and DBA is the same one. That's means, our programmers are all using SA account for DB maintenance task. Now, for the ... -
Discussion1VotesTransaction Log not shrinking
Hello Everyone: I am a DBA. And, having issues with Transaction Log not shrinking. My user db that has issues, is with Full recovery model and I have full, dif and log backups ... -
Answered0VotesScript SQL Agent History properties - remove agent history older than
I need to script the sql agent properties for 'Remove agent history' and 'Older than x ---' I know how to do this from SSMS but need to script so I can easily apply to many ... -
Answered0VotesIncreasing MemToLeave to 1GB or more
I read Jonathan Kehayias' article: http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/07/07/understanding-the-vas-reservation-aka-memtoleave-in-sql-server.aspx . I have a SQL Server ... - Items 1 to 20 of 887 Next ›


