CirquedeSQLeil (4/29/2010)

---

MS CRM is one such application that does this. It permits end users to create new organizations (it can also be scheduled to do it automatically) - which...

There is a difference between Disaster Recovery and Business Continuity. You need to define which your client wants to do.

Iron Mountain Records Management has very good white papers on both...

Please tell me what this application is...

haakon 29117 (4/29/2010)

---

1 - If we stop the sqlservice with the following command: net stop /y mssqlserver , would all the information in the log files be written to the...

dallas13 (4/29/2010)

---

I was able to see the improvements after this. It worked for me.

But every time after failover this value again gets set to 10 sec

so you need to change...

OKAY, THAT'S IT!!! ..... I wish I'd know...

You'd have to look at the tape-related software for that answer.

I don't think the Copy-Only Backups get stored in the tables, though. Do they?

If you don't need to see the messages at the time the proc is run, Insert them into some sort of log table. If you do need to see the...

Run PerfMon and a server-side Profiler trace on...

Bhuvnesh (4/28/2010)

---

Not an ideal Backup strategy, Include differentail back up also and change the Tlog backup frequency to One hour. Additionally read the articles related...

Are there global policy restrictions on launching applications from entry through a VPN tunnel?

Could the VPN tunnel be such a memory hog that the system doesn't have the resources to...

If you've already got the users set up in the Target server, don't worry about deleting and creating. As suggested earlier, just use sp_change_users_login and that will fix the database.

However,...

Rectify it? Why? Is it actually causing you a problem?

If so, please describe the problems it's causing. If you're just concerned because you've seen it increase memory utilization and you...

NJ-DBA (4/29/2010)

---

The SQL Server Service and Agent Service should NOT be set to automatic- if so, on startup, those services will attempt to start on both nodes.

The Cluster Service should...