I know the data may be as you expect;when someone breaks in (or tries to) they don't usually remove everything, just copy it (like a credit card).

Does this database contain personal...

Just in case you can get to the server

The SQL server logs are in

<Drive letter>\MSSQL\Log\ErrorLog1 to ErrorLog6.  The current log is just called ErrorLog.  All can be opened with...

Can you use 'Remote Desktop Connection' to connect to the server to view SQL logs?  Can you go directly to the server itself (I realise this may not be physically...

Just another point..........if your database is set to 'full' recovery and you don't backup the transaction log........ you will come in one morning to find that the transaction log has...

Have you created an 'ALL' value in {?ClientID}.  We use the following procedure in Crystal

1.         Open Field Explorer.

2.         Right click on Parameter Fields then...

Can you manually backup the transaction log to another area/drive on the network (if not the server)?

We have had this once before but it was when the transaction log was...

I bet the carrier pigeon turned left instead of right.  Or perhaps it was upset and emotional.  What we need is more training for carrier pigeons (and DBAs!).

Sorry.  This was the result of running sp_depends 'table name'.

I got mine but it appeared 12 hours later than normal.  Perhaps it got tired crossing the Atlantic?

I have run the above script and find that 'cfrmisadm' is the owner.  The curious thing is that this morning, when I logged into EM, that the owner has changed...

Yes we do do a full backup.  The whole process is to backup the live system to a device, copy that device to the new location, restore the database under...

We are connecting to the right server and database so I'll try looking in master db.  This a 3rd party database where we have repeated trouble with the logins and...

"You might need to trace EM and see what it is pulling. I suspect there might be a big somewhere or it is pulling from another location, like the...

We do need point-in time recovery in the new database.  The original database is heavily used and the transaction log file large despite backups throughout the day.  When we backup...

There are no active users (all ecid are 0).  We have tried to delete other transaction logs on the same server (it only holds the government snapshots) and get the...