Viewing 15 posts - 5,356 through 5,370 (of 9,253 total)
you'll be adding the node back to the current instance not creating a new one!
July 11, 2012 at 4:39 am
try just uninstalling sql server first
July 11, 2012 at 4:00 am
MBR limits partitions to 2TB, where as GPT doesn't, it's a lot larger than that.
The main restriction with MBR is the fact it will only support 4 partitions max, where...
July 11, 2012 at 3:44 am
I would uninstall\remove the node that's causing the issue and re install it
July 11, 2012 at 1:02 am
amitsingh308 (7/11/2012)
will you please explain it
When you drop objects from the database the files do not automatically reduce in physical size
July 11, 2012 at 1:00 am
SQLQuest29 (7/10/2012)
1. BytesPerCluster for SQLServer should be 65,535 bytes (= 64K) as sql server performs I/O based on an extent (8 8KB pages = 64KB).
Optimal stripe sizes for SQL server...
July 10, 2012 at 5:35 pm
Nicholas Cain (7/10/2012)
Have you looked for errors on the log shipping monitor
There is no monitor server, the return value for this in sp help log shipping primary database was null.
jitendra.padhiyar...
July 10, 2012 at 4:58 pm
Is this an OS service pack you're installing or the SQL server service pack?
July 10, 2012 at 4:46 pm
Firstly, I'm assuming this is a typo!!
jitendra.padhiyar (7/10/2012)Backup_directory=D\backup_ls
jitendra.padhiyar (7/10/2012)Backup_retention_period=30
30 minutes is a little aggressive for the file pruning. How often does the backup job, copy job and restore job run?
Full...
July 10, 2012 at 1:04 pm
ensure you are not taking log backups outside of your log shipping plan, only the log shipping backup job should be taking log backups of the database. Also ensure the...
July 10, 2012 at 9:51 am
sufiyan.sarguroh (7/10/2012)
Here is the error in the log :
The log shipping secondary database INFVA02839\INSTANCE1.AdventureWorks has restore threshold of 120...
July 10, 2012 at 8:28 am
what is the vritual network name for the clustered instance you are trying to connect to?
(i.e. the one provisoned in the clustered application group in Failover cluster manager)
A client acces...
July 10, 2012 at 7:37 am
don't take these threshold values too literally, they can and will change for each and every index.
Ensure you target your indexes based on a wider view of the index...
July 10, 2012 at 7:08 am
you already have a clustered instance installed and you want to know the IP address used is that correct?
July 10, 2012 at 5:06 am
Viewing 15 posts - 5,356 through 5,370 (of 9,253 total)