abhishek.c1984 (7/22/2009)

---

... "some active connections.........."

So before going ahead, i need to close the active connections and then proceed further.......So, in such cases is it possible to make forced backup and...

with Sp_lock it will provide you the spid that has the lock.

To get to see the last statement that spid is executing,

select est.text

FROM sys.dm_exec_sessions ES

left join sys.dm_exec_requests ER

on...

Which driver are you using ?

Are you (or the driver by default) using implicit transactions ?

A backup/restore operation cannot be incapsulated with a transaction.

If a restore fails, the db...

be sure to implement FK-indexes for the columns KeyWorkerId and CoWorkerId.

maybe you can even skip the isAgency column.

Implement a constraint to check on the combination coworkerid and agencyname

if coworkerid not is null, agencyname must be null

and the other way...

Things like dbmirroring, dbMail, or Service broker may cause msdb to grow.

e.g.

SELECT @@servername as Q_001_MSDB, COUNT(*) as nRows from msdb.sys.transmission_queue ;

I have only done some tests with DBmirroring.

I don't have actual experience with many mirrored databases of the same insatnce.

I just wanted to let you know MS customer advisory team...

I was just checking my mail and had a couple of minutes spare for SSC :hehe:.

Most of the times mail and SSC come together.

Have a nice (remaining)weekend.

Indeed, but the uncleanly "detached" files will only be a part of the problems.

Everything performed a instance level , logins, jobs, end points, instance level triggers, ... will have to...

You need to check on the rename server procedure !

SQLServer knows its own name, so you need to remove the old and add the new one.

http://msdn.microsoft.com/en-us/library/ms143799.aspx

stand alone instance

sp_dropserver

GO

sp_addserver ,...

Which one did you pick ?

- the ddl trigger ?

- least privileged ?

- both ?

16% free. but it represents 16GB.

How big is your biggest table (ix included if they reside in that datafile) ?

Why ? if you rebuild that table, you may need...

Please post in the correct forum !

Search SSC for mirroring and it will come op with the script you need !

IMO best is to use SQLServer events for this !

e.g.

http://msdn.microsoft.com/en-us/library/ms191502%28SQL.90%29.aspx

...

hmm ... so the windows...

Cathy DePaolo (7/17/2009)

---

ALZDBA, I paid more attention to the virtual...