Viewing 15 posts - 106 through 120 (of 242 total)
excessive paging resolution is simple, add memory or reduce load.
June 19, 2018 at 1:26 pm
check if you can reach other primary node from secondary, check endpoint config on all nodes. , check firewall/ports
June 12, 2018 at 8:58 am
modify the code as per your requirement
declare @cmd varchar(max)
declare @cmd_suspend varchar(max)
declare @cmd_resume varchar(max)
declare c1 cursor read_only for
select 'ALTER DATABASE ['+DB_name(database_id)+']...
May 29, 2018 at 7:00 am
why only page compression, where is compression best practice ?
May 23, 2018 at 9:43 am
must add route between subnets and/or ip addresses , talk to you network admin, he/she will understand.
May 23, 2018 at 9:39 am
it should work, I see no reason for it not to work.
based on scenario you described you need to assign both ips to the clustername , you can have...
May 23, 2018 at 9:21 am
if it is virtual , then may be add virtual nic... with 10.10.25.x
however same steps are required as above just on new nics.
May 22, 2018 at 12:17 pm
add additional IP to each node with 10.10.25.x.
add additional IP to cluster with 10.10.25.x.
then you can add 10.10.25.x. to listener.
keep your existing IP addresses as well.
gud luck
May 22, 2018 at 12:01 pm
run proc-explorer (https://docs.microsoft.com/en-us/sysinternals/downloads/process-utilities ) or task manager (maybe) to monitor what application is doing backup.. (you may look at timestamp of the backups to find when should you run...
May 22, 2018 at 11:42 am
you can achieve this if you design system using one table per database, it is crazy thou, good luck 🙂
you can also bcp out each table.
May 22, 2018 at 11:36 am
well this was a copy of a prod database, that i used to recover some data, the database was restored with stopat timestamp and recoverd
May 14, 2018 at 1:02 pm
yes and it did work, however I am not able to find what caused it
May 14, 2018 at 9:48 am
this is quite old, but you can try that , hope it helps , if you decide to go ahead from 2012 to 2017 be ready, you might be declined...
May 10, 2018 at 2:10 pm
Perfect example of disaster, inability of DBA not to implement correct backup strategy and/or not having control over database backups, This is what happens if you give control of backup...
May 10, 2018 at 1:16 pm
Viewing 15 posts - 106 through 120 (of 242 total)