miaka102 (5/26/2014)

---

@free_mascot. Thank you for your reply as for your questions:

1.Howmuch downtime is acceptable?

2.Howmany Databases on the SQL instance?

3. What is the storage you are using? Is it SAN?

4. Configuration...

create a connection using the SQL user that the linked server is using in Excel. It won't work being logged into excel with your domain account because the domain account...

without knowing the questions that free_mascot asked, you really have four choices;

log shipping

mirroring

replication

or a active\passive cluster

Or another idea is going SQL 2012 and using AlwaysOn.

Good Luck

crs2007,

pagefiles are on the C:\ by default during install, you can however move it to another drive by itself. I add another drive just for the pagefile and move it...

This should be able to help;

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

indexes are sent over to the secondary database auto from the primary in AlwaysOn, replication it takes a little longer

I use these scripts for my SQL users. If you read my post yesterday, Domain users do not need to have the sids matching. Just add the domain user(s) on...

Use the listener. Can you put the error you get when you try the Listener?

I have linked servers setup in my AO SQL Servers.

Ya, I was using that table, was just making sure...

Thanks Jeremy, that would explain why I can't find the SIDS for domain users, LOL:-P

Here is some reference material from Microsoft. This will help you out as well.

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

I did some digging on this and found this article. Look under Database Boundary and you should find your answer. It basically says that it creates its own system tables...

Janda Nel (5/20/2014)

---

the thing is,they only need to view the job and the history of the job and not make any changes to the job.Like edit the schedule or add...

I had a issue with a vendor not being able to see or modify sql agent jobs and this is what I did and this solved the issues with them...

nimalatissa (5/19/2014)

---

I spoke to may manager about creating SSIS packages for handling this situation. His answer was why all other 50+ servers are working fine and not this one. He...