Viewing 15 posts - 1,291 through 1,305 (of 9,244 total)
Jon.Morisi (4/11/2016)
Move Database Files Without Taking the Database Offline
No good if the table is huge and your storage subsystem is slow. Introduces fragmentation too.
Move the files in a planned downtime...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2016 at 7:31 am
please post the results of this query
select db_name(database_id), differential_base_lsn
from sys.master_files
where database_id IN (db_id('PrimaryDB'), db_id('SecondaryDB'))
and type_desc = 'ROWS'
group by db_name(database_id), differential_base_lsn
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2016 at 7:25 am
VastSQL (4/11/2016)
For SQL Server CU and SP do we need to install in both nodes? Installing it on one node is fine right.
Apply the patches to all nodes that are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2016 at 7:16 am
its sounds very much like the database user already exists and is orphaned.
Please post the results of the following
USE [yourdb]
select sid AS LoginSID from master.sys.server_principals
where name = 'theuser'
select sid AS...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2016 at 7:14 am
Jeff Moden (4/1/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2016 at 11:19 pm
river1 (4/8/2016)
Dear all,My Datacenter team wants to use RDK disks instead od SSD on our DB server.
is this a virtual machine?
RDMs are raw device mappings, these are LUNs presented to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2016 at 12:51 pm
MickyD (4/8/2016)
I am right in thinking that this could be due to UDP 1434 has not been allowed thru the firewalls ?
This would sound the most likely, check to ensure...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2016 at 12:46 pm
steve.roberts 86619 (4/6/2016)
Basically got a server and one of the drives is running out of space.
I can add in new log/db files on another drive ( which has lots of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2016 at 12:41 pm
indianscorpion29 (4/9/2016)
No, this is not clustered. It is a standalone
In that case if you want to add an Ssrs instance with the same instance name as an existing sql server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2016 at 8:25 am
The machine performing the scan with sqlcmd or sqlping must have network connectivity to all network segments to discover all SQL servers
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2016 at 8:18 am
indianscorpion29 (4/4/2016)
We have a production instance which has the SQL database engine installed. (Sql server 2012 with SP2 enterprise edition).
I have a requirement to install SSRS on this instance...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2016 at 4:20 pm
You've got a spill to tempdb thats not playing nicely in the park.
Do you know who the user is running the query and the actual query they're running.
If not you'll...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2016 at 4:13 pm
would have been helpful to get some info from sys.dm_tran_locks
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2016 at 2:30 pm
vincenzo_capelli (4/6/2016)
I have to plan Storage Area Network maitenance into the D.Recovery site.
With this activity the Sql server configured as secondary replica should be stopped.
What's the best practice for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2016 at 2:22 pm
what does the cluster validation report show?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2016 at 1:57 pm
Viewing 15 posts - 1,291 through 1,305 (of 9,244 total)