Can anyone guide me on the checkpoint command. Issuing a checkpoint and shrinking the log file will help to reduce the log file backup size???

Don't have any disaster recovery process for this instance...

No other errors. Now I am getting below 2 errors only

[Access Database [173]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E03.

[SSIS.Pipeline] Error: SSIS...

Very less number of Records and the columns are also not of huge size.

I am using a OLEDB Source where i placed a query and the query output has been transfered to flat file (.csv)

Thank you

Chelladurai

bcp may not work because the output of a stored procedure needs to be exported to a flat file. since it is not taken direct from a table nor a...

Can we name the .csv file dynamically. i.e for example file name should be "XXXXX_mmddyyyy.csv" it should be suffixed with current date so that it will not overwrite and also...

Sorry. I mean to say that this need to be happen through a stored procedure (can be assigned to a job) and not from the query window.

Thanks. But this will not help 🙁 Output should be automatically pushed into CSV and not a manual process.

Hi,

Can someone help me how to restore diff backup and then a log backup? I am getting error as below

I tried with below command and i get error.

restore database...

Hi GAIL,

Could you please help me on below issue and let me know with little example on how to restore full and then diff and then followed by log backups...

I...

But i am able to restore log backups with same command as below

restore log logtest

with standby='e:\sql\primarydb_20120223093001.trn'

I tried with below command and i get error. Please help.

restore database logtest

with standby='e:\sql\primarydb_diff.bak'

Msg 3153, Level 16, State 3, Line 1

The database is already fully recovered.

Msg 3013, Level 16, State...

If that ad-hoc log backup wasn't taken WITH COPY_ONLY and wasn't copied over and restored to the secondary, then the next log restore after that will fail, and so will...

Hi,

We are calling with DB.DBO.Procname. when we remove the create table script bcp runs fine.