After I pause, log shipping, take the t-log backup, a.trn,

On Secondary Instance

RESTORE LOG A_Log

FROM DISK='E:\MSSQL\BACKUP\a.trn'

WITH MOVE 'a2' to 'G:\MSSQL\Data\a.ndf',

NO RECOVERY

Start Log shipping back up.

One other question, for now:w00t:

Will all the...

Thanks, that is what I wanted to do.

I was trying to avoid doing a full restore, but if I have to, I have to, no big deal.

Thankss

Lots of good input.

Here is what I plan to do:

Primary Datbase: A

Secondary Database: B

On Primary Instance

Alter database A ADD FILE (NAME 'a2', FILENAME 'G:\MSSQL\Data\a.ndf')

TO FILEGROUP Primary

GO

On Secondary Instance

Alter database...

If I add a secondary data file to the Primary Filegroup in Production, how will the Secondary db know where to create the secondary file? The drive letters for...

I don't want to add a Secondary Filegroup, only a secondary file to the Primary Filegroup.

I don't need to add a secondary file on the production database, only on the...

I vote for option 2 also, the developer says he may have but does not remember,

so the matter is closed.

The good thing is we got the production table back and...

He was using the GUI, so all he did was put back in the name of the table "batch", not dbo.batch.

Bouncing the SQL Server Agent worked.

Thanks all.

Keith

yes the operator is enabled.

Error" NOT: Failed to notify 'DBA' via email.

No we have not bounced the SQL Server Agent.

That was my next guess.

Thanks,

Keith

Thanks for the quick response.

We would rather not shrink the file, as you said, all indexes would have to be rebuilt.

This is an older system, 32 bit Windows.

The reason we...

Thanks for the info, I will give it a try.

Keith