Presumably you are recreating the database + objects from scripts. Check your scripts for the duplicate object (probably a table, so look for CREATE TABLE statements). See if...

Make sure that Doubletake can actually work with SQL Server. We have recently been doing a similar thing with Leostream. While Leostream apparently works with SQL Server (no...

What exactly are you wanting to secure and to what extent? Security can be as little as restricting who can connect to your SQL Server (create only those logins...

O yeah, I had forgotten about that one.

Use this syntax:

WITH

MOVE 'logical data file name' TO 'physical data file location',

MOVE 'logical log file name' TO 'physical log file location',

NORECOVERY

Use as many MOVE statements as you have data...

Since you are going to restore the database again anyway, you could try:

RESTORE DATABASE dbname WITH RECOVERY

That should bring the database online. Then you can delete it & try...

K. Brian Kelley (11/22/2007)

---

Nothing at all. However, if you can script out the logins and recreate them with identical SIDs, that saves you a...

Most places I have come across run reindexing/checks on a weekly basis.

As far as reindexing goes, it depends on how much data gets put in and what the...

Whisper9999 (11/30/2007)

---

Matt Miller (11/30/2007)

---

Best way to get the service name is to look at the properties of the service in the Control Panel/Administirative Functions, services. Highlight the service in...

For the most part it shouldn't be an issue - accessing the SQL Server is generally done via the machine name. However, there are a few things that rely...

What's not easy about using profiler?

If you have access to the stored procedure code, you wouldn't need to capture it every time, just the parameters being passed with the procedure...

It's a yes from me as well. Particularly if the SAN is to be used as a shared repository for other stuff as well - you don't want everything...

This doesn't look like an error to me. What log is this from?

What's happening from the database end? Is anything actually establishing a connection? Or is it...

This may be a silly question, but are you selecting 'named instance' when installing? Assuming the existing instance is the default instance of course. Because even if you...

As above, you will need a CPU license for the reasons given. You will need one license per CPU (socket, not core) installed in the server, regardless of whether...