Sorry for not closing this discussion earlier , i was waiting to see if there was any more input.

Here's the update since I posted the topic.

Agile is great , but...

But setting the recovery interval would make sure it runs frequently enough to make sure the recovery doesn't exceed the time limit specified.

Also, i wasn't able to find anything...

using checkpoint periodically could help ease the pain

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

This is a long shot , but have you tried restarting the sql server services.

Have you run out of disk space ?

You can run a shrink file using the DBCC shrinkfile command,

DBCC SHRINKFILE

(

{ file_name | file_id }...

select * from issues i

left outer join attachments a

on i.id = a .id

this is similar to what you what , if your looking for spoon feeding , you need...

PaulB-TheOneAndOnly (7/1/2011)

Not sure if I would tackle a replication schema...

Are there any deployments happening to the server just before the mapping is lost.

It could be possible that some code meant to be in defensive coding format has been poorly...

I know of an issue where restoring the backup the file growth value gets set to some random value and usually its a percent.

I think there was a hot fix...

Migration of data to oracle via SSIS is probably the best approach but you can also setup replication to Oracle.

if your passing a sql login name and password as the connection string to the web.config then its not integrated security . If your application is using a service account...

Congrats ... next stop MCITP ?

sorry the below statement had me going in the wrong direction

There are 56 records that need to be updated in the target table which are identified by this query.

select...

Lookup NCHAR and unicode

select Nchar(50)

select unicode(2)

These environments are fairly low down the ladder , I am of course an accidental DBA so didn't really need a bullet proof approach , just one that lets me...