Viewing 15 posts - 6,826 through 6,840 (of 9,241 total)
Markus (8/11/2011)
Using SQL install evict the passive node.
Why do you think this is necessary?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2011 at 11:23 am
Roy Ernest (8/15/2011)
Are you talking about LiteSpeed from Idera?
Don't you mean Quest? 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2011 at 11:16 am
if you have a tool such as Redgate SQLBackup or Quest Litespeed these tools can generate the schema and data insert scripts for you.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2011 at 11:15 am
jprovines (8/15/2011)
backup_source_directory\\lap8db03\TransactionLogBackupbackup_destination_directory\\lap8ea03\TransactionLogShippingTemp
file_retention_period2880
initially everything seems ok, this value
file_retention_period2880
will apply to this
backup_destination_directory\\lap8ea03\TransactionLogShippingTemp
and not this
backup_source_directory\\lap8db03\TransactionLogBackup
The secondary server should never delete files from the source backup direrctory as there could be more than one...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2011 at 10:44 am
Hi
please execute the following against your Log shipping primary server and post the results back
use master
exec sp_help_log_shipping_primary_database @database = 'yourdbname'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2011 at 6:53 am
what you should be doing is to build yourself a dataset that would mimic your live data and use this database for development and possibly even testing. This allows dev...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2011 at 6:39 am
All
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2011 at 6:27 am
please supply more info on the server setups such as windows os version, number of cluster nodes and any NIC assignments
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2011 at 4:00 am
it's probably easier to stop the log shipping and remove the secondary database. Sort out the disk space and file locations and then re initialise the secondary database
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2011 at 8:15 am
what events do you see in the application event log when trying to start the agent service normally
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2011 at 7:44 am
mazzz
i'm not clear, are you adding a node to an existing clustered instance or creating a new clustered instance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2011 at 6:38 am
chris.mcgowan (8/12/2011)
To make the secondary log shipping instance 'online' and accesible you need to restore a transaction log with recovery.
you do not need to specifically restore a transaction log,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2011 at 6:23 am
jprovines
please execute the following against the primary server
use master
exec sp_help_log_shipping_primary_database @database = 'yourdb'
and this against the secondary
use master
exec sp_help_log_shipping_secondary_database @secondary_database = 'yourdb'
Post the results for both these!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2011 at 3:34 am
Thank you all for your feedback. I created this article as to me it seems the DBA is always an afterthought in most organisations.
"oh he\she only looks after the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 12, 2011 at 10:05 am
ss-457805 (8/12/2011)
great articles Perry. Have added to my favourites :-). Keep up the good work.
thank you, i appreciate your feedback
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 12, 2011 at 3:35 am
Viewing 15 posts - 6,826 through 6,840 (of 9,241 total)