Yes, you can use temporary tables as an alternate depending on your goal.

Rajan John-243593 (3/12/2010)

---

How good is the idea of running SQL Profiler remotely from a user machine in a different domain from the domain of the production servers? My fellow DBA...

You can eliminate this step also, only thing you need to do is ask your network team to open a port one way to...

Here is the quick check list for migration.

Have Server guys Disable IIS on Application Servers

Set All user dbs to RESTRICTED_USER

Verify no user connections

Disable SQL Agent

Script out DB_Mail profiles

Script out SQL...

mathias-ruehn (3/12/2010)

---

first node is shutdown...

any other suggestions?

can i do a check of the io?

Server 2008 r2 cluster check is with no error...

everything seems to be ok.

almost the other dbs have...

You can also use activity monitor if you know when exactly user is running SQL, Profiler is your best bet.

Don't think about points, this place is for knowledge sharing.

Are you doing this in production? Did you test this in Integration?

I am finding so many problems where the new service accounts don't have the same permissions as the old so, for example, the backups cannot be copied off the...

Levels, depends on the points you score.

I am with Elliot and Lutz on this, Standard protocol is to build a SSIS package and test that in Dev environment and give package to DBA's in Prod, DBA's...

As dbychen said, Looks like SCOM is the you need for monitoring. By the way how many instances you have and how many of them on cluster?

We are glad that you could recover everything, Culprit is Sharepoint, You have to be real careful sharepoint.

Do you have back up if old distribution database?

Kwisatz78 (3/12/2010)

---

Hi all

Currently we have a snapshot replication setup which takes a fresh snapshot every night. The other day one of the devs was doing a release and ended...