Viewing 15 posts - 4,966 through 4,980 (of 9,244 total)
One further question,
When you set the details on the restore tab did you edit the restore options and enter different paths for the target\secondary data and log files?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 22, 2012 at 2:15 pm
Get back to basics, firstly the agent service account on the primary doesn't need any access to the copy location on the secondary server. It doesn't know about it and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 22, 2012 at 10:50 am
Consult with your vm admin, if memory ballooning becomes a problem you may have to uninstall the balloon driver from the vmware tools but simply having the admin reserve resources...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 22, 2012 at 2:36 am
You'll need to use passthrough authentication. The database engine service account must be able to access the share unchallenged. It's similar to the problems faced in SQL Server log shipping...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 22, 2012 at 2:24 am
you can get a quick and dirty dump using this too
select 'create login ' + QUOTENAME(name) + ' with password = ' +
sys.fn_varbintohexstr(password_hash) + ' hashed, ' +
'sid =...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 21, 2012 at 1:08 pm
can you post a screenshot of the point in the wizard where the error appears?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 21, 2012 at 12:26 pm
ksr39 (9/21/2012)
Thank you for the reply, I have configured the logshipping on this database and from starting the log's are not getting restored to the destination database from the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 21, 2012 at 2:04 am
siraken (9/20/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 21, 2012 at 1:53 am
thotvedt (9/20/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 20, 2012 at 4:38 pm
Try restarting the mirror endpoint next time instead of the sql server service
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 20, 2012 at 4:35 pm
To thoroughly test the storage for I\O patterns use SQLIO not sqliosim
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 20, 2012 at 1:11 pm
ok, so what checks are in place to validate files that have been or not been restored.
If you're doing this completely manual then it is very easy to get out...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 20, 2012 at 6:47 am
aaa-322853 (9/20/2012)
We have implemented custom log shipping between the primary and secondary database. The secondary database in on a SQL Server 2005 cluster with the data/log/undo files all on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 20, 2012 at 4:32 am
SQLSACT (9/20/2012)
however, is it just me or does it become very complex when you start combining FCI ?Thanks
yes extremely, why do you think i wrote the article 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 20, 2012 at 3:53 am
it's the check to make sure the sql server instance is online and responding
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 20, 2012 at 3:23 am
Viewing 15 posts - 4,966 through 4,980 (of 9,244 total)