Yes it is possible.

*****************************************************************************************

Cross Domain Log Shipping

If computers that are running SQL Server are placed in a multi-domain environment, Microsoft recommends that you set up two-way trusts between all...

This doesn't operate at the job step level though, MultiServer administration is at the job level. So you set the target server for the job and not the individual...

As far as I'm aware there isn't any built-in way of running multiple job steps against different servers.

Depending on what the jobs steps are doing there are ways to emulate...

Yeah I'm surprised myself. What version of the Windows Server is it running on?

Just to confirm you're looking at the dependencies for the SQL Server cluster resource? If that's the case and there are no disks present as dependencies then you...

You can physically delete if you really need to from the OS folder location under \MSSQL\Log. You can also set the number of logs to retain

http://msdn.microsoft.com/en-us/library/ms177285.aspx

The reason you're not able to 'see' the drive through SSMS is that it needs to be added as a dependency to the SQL Server clustered resource. Are...

In SSMS if you connect to the SSAS instance and right-click on server and go to 'Properties' in here are a number of Memory metrics.

The initial one to look at...

Can you telnet to the database server from the app server on the port the SQL Server instant is listening on? It's also worth bearing in mind that this...

Hi Sam,

Are you able to recreate the logins on the TEST server so the SIDs are the same as the PROD? This would then remove the need to...

Ah, just picked up on this. If you're restoring to a brand new database, i.e. not currently there. You shouldn't be constrained by the database the restore is...

the ALTER DATABASE....SINGLE_USER method as suggested earlier is a good suggestion. Remember to add the WITH ROLLBACK IMMEDIATE otherwise it will wait for the connection to be closed before...

If you're using VARCHAR(MAX) data types and storing XML data you might not get much benefit from data compression as only IN_ROW_DATA pages can be compressed. If you haven't...

Hi,

Yes you need to grant permissions to the proc. Such as this:

GRANT EXECUTE on xp_logininfo to [Database_User]

Depending on how you feel about assigning permissions for users directly against objects,...

Are you able to post the error message?