Viewing 15 posts - 5,356 through 5,370 (of 9,244 total)
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2012 at 4:58 pm
Is this an OS service pack you're installing or the SQL server service pack?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2012 at 5:06 am
thanks for letting us know. Something i've done before is to extract the system db backups to a running instance as user databases, detach them and rename the files then...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2012 at 5:03 am
jitendra.padhiyar (7/9/2012)
According to my knowledge, they will not be deleted on secondry server, it will be deleted on Primary server.
Au contrair mon pere 😉
sufiyan.sarguroh (7/10/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2012 at 4:54 am
adb2303 (7/10/2012)
Can kerberos be used against a Client Access Point in a SQL Server cluster? I registered SPN's for the SQL Server service account using setspn, but the authentication...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2012 at 4:46 am
Ok, no problem
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 9, 2012 at 1:14 am
You may not need to rebuild, does the instance start in single user mode?
If so just proceed with the restores if the backups are recent.
If the instance does not...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 9, 2012 at 1:10 am
Viewing 15 posts - 5,356 through 5,370 (of 9,244 total)