Viewing 15 posts - 1 through 15 (of 79 total)
Hope i can use this... but still hesitant to use it in production...
USE [dbname]
GO
DBCC SHRINKFILE (N'dbname_Data2' , EMPTYFILE)
GO
October 5, 2020 at 3:14 pm
sorry for adding my reply to this old thread.
am using SQL Server 2019 and created a secondary file to fix the disk full error. Unfortunately, the secondary file is created...
October 5, 2020 at 3:09 pm
Dear All,
In spite of having a listener am getting read-only databases in the secondary during the failover. Not sure where it goes wrong. Any help is highly appreciated. Thank you.
June 5, 2019 at 2:24 pm
Hi Gail,
Am aware that am posting on years old thread. Sorry for that.
Would you please let me know the recent link on the certification and how to...
November 9, 2018 at 3:14 pm
I got the same warning and error. Please let me know the solution if you did solve it.
Many thanks in advance.
January 9, 2018 at 8:40 am
University education need not make Developers or DBAs. They need to teach on how to handle life positively in spite of profit or loss. Basically, education centers should educate the...
November 30, 2017 at 5:14 am
Fact. In most of the countries education is seen as profit earning business only. Respective governments should focus more on the syllabus and make sure children are grown with necessary...
November 29, 2017 at 10:51 pm
Yes. Permission is not a problem.
Thanks
October 13, 2017 at 12:56 am
The error comes in primary cluster. Am able to create\edit management plans in the secondary server of the cluster. However structure in both the server's " October 13, 2017 at 12:11 am
1. Am not able to find the folder "SQL Server Developer Tools" in the path "C:\Program Files (x86)\Common Files\Microsoft Shared\"
2. Is it a new install of...
October 12, 2017 at 11:42 pm
Sorry for posting on three year old thread.
Just curious to know if there's any solution for a similar situation. I have an archive database in which the stored procedures...
October 17, 2016 at 6:49 am
Thank you Sartori. If you can show some proof it will be great. Please share links if you find'em online.
June 28, 2016 at 2:51 am
Thanks for your reply. But my doubt still remains. I want to know if the network fails and comes back, is it not equal to a server restart and all...
June 28, 2016 at 2:36 am
The options could have been more clear. Anyways I got my point after careful analysis. Good information though. 🙂
July 1, 2015 at 11:37 pm
Thanks for your response. I applied the same settings as in other server and was fine.
July 1, 2015 at 5:59 am
Viewing 15 posts - 1 through 15 (of 79 total)