george sibbald (7/19/2011)

---

the correct answer here is - you don't want to start from here.

Best practice would be to place the system databases where you want them as part of...

Don't forget that DBA means different things in different companies. Some companies have DBA's that are strictly production support DBA's (e.g. monitoring systems, backups, etc...), database developers and architects.

Others...

I would also recommend that you setup a server side trace to capture all database calls that take more than xx seconds. You can start with 5 seconds and...

The first DBA is wrong - you cannot even enable AWE on a 32-bit machine without setting the lock pages in memory right for a service account. Unless you...

And - there are no shortcuts. You will have to wait for it to complete the rollback.

upstart (7/15/2011)

---

We have all our services set to Manual, so in theory, if the server is up, the services should be running as well.

So that's why my code basically Pings...

Check the log_reuse_wait_desc column in sys.databases for that database. If it shows up as REPLICATION, then you have an issue with replication not completing so those transactions cannot be...

Shah_hs (7/14/2011)

---

First step is to add the instance on ServerB to ServerA.

Do you mean i need to run setup to install fresh instance on Server A? Since Server A...

I am a bit confused by this query - what is being counted here? I would bet anything that there is no reason to even join to all of...

No - you do not need to take down the production system. But, you might need to stop the transaction log backups if you run them often enough that...

GilaMonster (7/13/2011)

---

jpSQLDude (7/13/2011)

---

So here is what I can do: in Data Center A, I can take SharePoint down, so the app that is using SQL is off. Then I can...

Shah_hs (7/12/2011)

---

One thing i forgot to mention is that; at present Server A has only one instance installed. So assuming first i need to install second instance on Server A,...

ruffindmc (7/12/2011)

---

Thank you for your reply.

Both locations have SQL Server 2008 database. My location uses the BI tools SSRS, SSIS, SSAS.

Microsoft .NET framework.

What I need to do is create reports...

opc.three (7/12/2011)

---

Jeffrey Williams-493691 (7/12/2011)

---

I would recommend SSIS also - and I don't see Service Broker as the right solution. I would think service broker is more geared toward event...

I am not sure I understand the configuration you have - or what it is you want to accomplish.

There are several ways you can get data from another system, each...