Viewing 15 posts - 2,536 through 2,550 (of 9,241 total)
UconnDBA (1/5/2015)
Basing that on all our other database backups, in 2012 and 2008r2, compressing to a file less than 30% of the database size. I did try running the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2015 at 6:10 am
to be clear, latches occur on physical disk pages and inmemory pages
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2015 at 6:05 am
sej2008 (1/4/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2015 at 5:47 am
with a decent pipe between sites i've copied over the network overnight, that was from UK to Arizona.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2015 at 2:26 pm
multiple IP addresses on different subnets but not VNNs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2015 at 1:36 pm
you add the primary, the est should be taken care of
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2015 at 10:30 am
Failover cluster manager in Windows 2008 and 2012 is pretty much exactly the same bar a few small tweaks.
Do you even have a clustered instance of SQL server running?
Start by...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2015 at 9:56 am
dbaduck (1/5/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2015 at 8:10 am
check for any type of LOB columns, as these do not compress well, if at all.
This should help identify any large columns
select object_name(c.object_id) as tablename,
c.name as columnname
from sys.all_columns c inner...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2015 at 8:03 am
sej2008 (1/2/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 2, 2015 at 12:09 pm
create a role for your clustered sql server instance and into the role put the required shared disks for the sql instance and a shared disk for the DTC.
Right click...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 2, 2015 at 3:24 am
pradeep.k 50453 (1/1/2015)
We are configured the logshipping around 80 gb database.log file growth up to 60 gb .want to shrink the ldf files.what is the best way to shrink file...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 1, 2015 at 6:24 am
ideally reboot as soon as the patches are applied, holding off til the end of the day has never been too much of an issue for me though
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 31, 2014 at 12:19 pm
why have you configured the instance to use 1434, best practice would be to set a static high range port for the instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 31, 2014 at 12:17 pm
put the clustered DTC resources into the SQL server instances cluster role
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 31, 2014 at 12:15 pm
Viewing 15 posts - 2,536 through 2,550 (of 9,241 total)