what do you mean by contact details?

If you looking for all the sql server in a domain then from...

As your sql already running and to make the change effective in your sql , you have to change the sql services running account to the correct domain account if...

1)use order by ReminderNo asc/desc to see the list accordingly.

2) use top n in your select query to get top n number of records and use order by asc/desc to...

select * from sys.dm_os_sys_memory

When you create your maintenance plan, you have the option to view the t-sql script of the maintenance plan(the task which you configured for maintenance).

To do this-- select edit of...

like John mentioned, you need to look into your query which you passing into variable. There might be some object/s in query on which the user do not...

i had this picture when I visited Madam tussads London.

I like to use this picture as my avatar because it inspire me for honesty and learning new every day....

is your sql server windows authentication or mixed mode authentication?

If mixed mode then you can login with some windows account which is configured with sa permission and then reset...

if you asking about general overview on log file growth then I would recommend you to go through this great article from Gail :-

http://www.sqlservercentral.com/articles/64582/

If your question about managing in your...

glad to hear your effort worked.

yes it will not refelct immediately as soon it reflect on your primary server.

As i mentioned the steps in my previous post, the backup file first get placed in...

what Gail is referring is to run this query in master database:-

select name, state,state_desc from sys.databases

and report about...

Have a read of dbcc ind and dbcc page.

You will get most of your answer.

When setting up LS there were 2 boxes called "Network Path to Back Up Folder" and "Destination folder for copied files". The first is straight forward, the second seems to...

as you can read here http://msdn.microsoft.com/en-us/library/ms191495.aspx, copy_only doesnt break your backup chain. So this option you can use...