Viewing 15 posts - 181 through 195 (of 242 total)
the answer is in your own question, "we don't want to impact the fail over of the production database if something goes wrong with the fail over of the monitoring...
November 15, 2017 at 7:14 am
stop the cluster service on both nodes, then start sql server from sql configuration manager and see if you can start the sql, post the sql error log if you...
November 15, 2017 at 7:07 am
(any execpt primary) .. thats why i said play with the code
to make it more clear to understand..
-- restore full file group primary
--MUST RESTORE...
November 14, 2017 at 1:12 pm
check/fix permissions on the new drive
November 14, 2017 at 1:09 pm
off course you can, play with the code.
CREATE DATABASE [test] ON PRIMARY
( NAME = N'test', FILENAME = N'y:\tmp\test.mdf' , SIZE = 5MB , FILEGROWTH...
November 14, 2017 at 1:03 pm
i suspect some records might be with different page code, it usually happens when you change you database collation while data is in tables. I suggest try specifying page code...
August 25, 2017 at 11:45 am
make sure sql server name is not longer then 15 chars.. check SCMS documentation.
August 21, 2017 at 8:39 am
check tcp/ip is enabled on both servers.
talk to your network admin, and open 1433 between both servers
August 17, 2017 at 1:24 pm
do you have permission on cluster, delete the resource or role .. or have sysadmin do it for you.
August 17, 2017 at 9:03 am
my guess is you are missing login in the sql server..
August 16, 2017 at 11:29 am
remove the database from BAG from both or all nodes and then add again, you can not move a group to a server where there is no database
August 16, 2017 at 11:20 am
As I understand the error, the certificate is either missing or different , can you match thumbprint from error with thumbprint in sys.cetfiicates
August 15, 2017 at 9:44 am
you may want to consider Sql Server Management Data Warehouse, you will get more then you are looking for and its ease and free. https://docs.microsoft.com/en-us/sql/relational-databases/data-collection/configure-the-management-data-warehouse-sql-server-management-studio
August 15, 2017 at 9:33 am
modify this..
-- choose database or currently used database will be selected
DECLARE @db_name VARCHAR(100)
SELECT @db_name = DB_NAME()
-- Get Backup History for required database
...
August 9, 2017 at 2:38 pm
Viewing 15 posts - 181 through 195 (of 242 total)