I have to do migration from sql 2005 to sql 2008., i know we cannot restored systemds like master,msdb,model., can i detach them from 2005 and attach...
Can I downgrade for sp2 to sp1 by bringing back old resource mdf and ldf files?
How to reduce BootStrap lookups in executino plan?
Can I rename my linked server., i am a newbie i searched online but confusing answers...so experts any opinions...
1.how can i restart my active node...without failing over to passive?....
1.i forgo my sa passowrd..i dont have any other access to sql server...what are my options to get reset the password?...
1.Can sql server use more ram...lets say i set the max ram to 8gb., can it go and use more than 8gb? Thanks in advance...
Separate names with a comma.
