If you are planning to save the SSIS packages in MSDB, I don't think it is possible to seperate the permissions. Where as you can save them into a...
Are you planning to use database mirriring or log shipping? If you are planning to use mirroring, make sure you have the right edition of sql server....
Can you please answer the following first... 1. Are you adding sql 2008 r2 existing cluster? if so what is OS edition? 2. Are you doing this on...
Yes, it is possible... Run the sql installation setup from the passive node and select the advance option for failover clustering... After SQL...
Have you or anyone you know of implemented this?
Make sure your MSDB is not in FULL recovery mode. If it is is in FULL recovery mode, change it SIMPLE before shrink it.
There is no CTP yet... MS may announce in SQLPASS if there will be any CTP in early 2011.
These databases can be moved like any other user dbs. Just detach, copy to new location and then attach, I don't think you need to stop RS but you...
You can do backup and restore with WITH MOVE option Before backup Stop the SQL Agent and stop all replication agents and restore and start all the...
Yes, it is the service account running under local account issue... If you have the option to use domain account which has the access to subscriber...
How can I say what servie accounts is for a sql server 2k or 2005 in windows xp or 2003 or vista? Questio is not clear... How can I find out what is...
It is open ended question... So read the following articles... http://www.sql-server-performance.com/tips/query_execution_plan_analysis_p1.aspx...
Answer is it depends what purpose you are setting... In general... You need a server/machine with windows OS. You need SQL Server installation media....
No, it will not fail.. Log shipping fails when there is a log sequence breaks like when you chnage the recover model from FULL to SIMPLE and back to...
System log and cluster log...
Run the profiler to what code the application is execution... what login application is using? If it is using other than 'sa', you should have...
I don't think so... Why would the network problem cause leads to corrupt db unless you are using .mdf and .ldf file as network files.
Here is an example for this type of scenario I can think of but not tested.... When a query executed by user, and the optimizer chooses to use the...
You can't do this with SQL Server, you need to use your front end application code.
First make sure what login is using the app? Make sure the login is not DISABLED or DENIED... You can use SSMS... Expand the logins folder/Double...
Separate names with a comma.
