Viewing 15 posts - 6,601 through 6,615 (of 9,241 total)
as already said when shelling out specify the path like so
exec xp_cmdshell '"C:\Program Files\Microsoft SQL Server\90\COM\tablediff.exe" blah'
Alternatively go onto the server and add the path for the TABLEDIFF.EXE to the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 17, 2011 at 2:22 am
sqlbuddy123 (9/16/2011)
backup_retention_period - 4320 -- what units are these ?
The length of time in minutes.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 17, 2011 at 12:44 am
kvr1985 (9/16/2011)
mirror server not synchronizing.please find the snapshot in attachment.
Has it ever synchronised?
Can you supply more info on the steps you took to set up the mirror session?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 16, 2011 at 4:36 pm
VanishingW (9/16/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 16, 2011 at 8:07 am
I'm assuming the filer is setup to use FCP and not iSCSI, double check the initiator groups as that has to be the root of the issue. Does the second...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 16, 2011 at 1:18 am
pamalatha (9/15/2011)
Thanks a lot Crazy.
😀 my name is Perry
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 15, 2011 at 12:35 pm
dbychen (9/14/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 15, 2011 at 5:41 am
pamalatha (9/14/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 15, 2011 at 5:39 am
yes, prevent failback will do it exactly what it says. Set the policy to immediate or scheduled and the cluster group will comply, probably not what you want on a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 14, 2011 at 9:23 am
Virtual network names, like computernames must be unique in the domain.
One clustered instance to one network name.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 14, 2011 at 9:21 am
Please execute the following against your primary server and post the results
exec sp_help_log_shipping_primary_database @database = 'YourLogShippedPrimaryDatabase'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 14, 2011 at 4:30 am
Possible owners are defined at the resource level and dictate which nodes in the Windows cluster are able to service this resource
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 14, 2011 at 4:12 am
sqlbuddy123 (9/13/2011)
Right, Mirrored DB is not accessible at all times.Thank You,
Best Regards,
SQLBuddy
Unless you're using Enterprise edition...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 14, 2011 at 3:42 am
kapfundestanley (9/13/2011)
So you mean on top of the daily back-ups i am taking, i need to take Daily transaction logs as well?
Yes, in full recovery model you need to take...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 13, 2011 at 5:29 am
Log shipping stored procedures are detailed here
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 13, 2011 at 1:47 am
Viewing 15 posts - 6,601 through 6,615 (of 9,241 total)