Do you want to clone systems databases (master, msdb, etc) as well as all user databases? Or just one user database?

Cheers,

- Mark

A couple of problems I can see immediately:

The code:

 

IF EXISTS(SELECT CustID FROM TblCustomers 

WHERE EmailAddress = @x_Email)

Set @CustID = CustID 

BEGIN

...assume the previous SELECT...

If you backup to 5 devices you must restore from those same 5 devices. The restore will restore the same number of database files (MDF, NDFs if any, and...

Because of active portions of the log, the process I usually follow is:

1) truncate

2) shrink

3) shrink again

4) shrink... please!

5) SHRINK damn you!

6) ok, this is your last chance... SHRINK!!

(mutter under...

BOL says to shut the server down and restart after doing the sp_addserver. Maybe this means the box rather than the SQL service? Worth a try.

Cheers,

- Mark

Yes they will. STANDBY has the advantage of the database being available for reading, but the disadvantage of preventing any transaction logs or differential backups being applied while anyone...

Might be that the INSERT INTO combined with the OPENQUERY creates a distributed transaction. Loopback servers can be used in distributed queries but not distributed transactions.

See "Loopback Linked Servers"...

By jingoes Frank, I thought you already WERE a DBA.

I can't see you having any problems with a technical interview.

You probably only need to work on answers to the non-technical...

I recommend avoiding Dumps. They'll just make you a cheat, not a DBA.

Cheers,

- Mark

I'm not real big on DbaseIV linked servers, but I have used the following syntax to read the EMPLOYEE.DBF file out of the MS Office directory. You may be...

You can't I'm afraid.

Cheers,

- Mark

Are you returning the collection to another SP, to Query Analyzer, or to your front end code?

Do you want a table returned, or a comma-delimited string of user...

I would assume it's from the END of the full backup, based on:

a) LSNs in the headers of full and differential backups don't overlap.

b) Full backups provide data integrity to...