Viewing 15 posts - 1,681 through 1,695 (of 9,244 total)
tnpich (10/7/2015)
fn_diagramobjects
sp_alterdiagram
sp_creatediagram
How can I get rid of these type of objects without filtering on SAO.name...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 7, 2015 at 8:29 am
kiril.lazarov.77 (10/6/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 7, 2015 at 4:57 am
humbar-a (10/7/2015)
I know, the .mdf file is necesarry and contains the information to start the database.
Yes that is correct
humbar-a (10/7/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 7, 2015 at 4:54 am
gingerdazza (10/6/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 7, 2015 at 4:51 am
gingerdazza (10/7/2015)
< 5 miles apart (the wisdom of such proximity is a separate conversation) 😀
That cannot be considered a true disaster recovery datacentre, 500 miles would be more preferable
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 7, 2015 at 4:49 am
vijayakumarn (10/7/2015)
Hi,I wanted to apply SQL server 2014 service pack1 and CU1 & CU2 on a two node cluster environment without server downtime. Please suggest.
Thanks
You'll first need to apply service...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 7, 2015 at 4:46 am
Benki Chendu (10/6/2015)
Perry Whittle (10/6/2015)
have you consulted your network admins?what do I need to ask them?
I am able to ping the servers from each other
DNS settings are first to check,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 6, 2015 at 10:48 am
have you consulted your network admins?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 6, 2015 at 7:27 am
the t-log file is the problem, the error clearly states this!
Please post results of the following;
PowerShell query
Get-Volume | ?{$_.drivetype -EQ "Fixed"} | ft DriveLetter,FileSystemLabel,HealthStatus,SizeRemaining,Size
TSQL query
SELECTname
, size / 128 AS SizeMBs
,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 6, 2015 at 7:26 am
I'm sorry its not clear what you're asking?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 6, 2015 at 5:35 am
mahi123 (10/6/2015)
Message
Executed as user: NT AUTHORITY\SYSTEM. The transaction log for database 'tempdb' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 6, 2015 at 5:33 am
SQL Galaxy (10/6/2015)
1. We are not using shared storage for current setup of always On availability group due to budgets constraints.. can be able to configure without SAN shard storage?
Yes,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 6, 2015 at 4:35 am
You'll need to add the computer account to the share and ntfs permissions lists
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 6, 2015 at 12:34 am
Firstly, read my stairway to Alwayson starting at this link
http://www.sqlservercentral.com/articles/Failover+Clustered+Instance+(FCI)/107536/[/url]
SQL Galaxy (10/5/2015)
Node 2 -IP Address 10.xx.xxx.12
while create cluster wizard in access Point for administering the cluster...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 6, 2015 at 12:32 am
How does this handle databases with multiple files?
It's concerning that it automatically drops the target database first if it exists.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2015 at 11:56 pm
Viewing 15 posts - 1,681 through 1,695 (of 9,244 total)