I dont know what im doing wrong. But my Watch window doesnt let me to type anything.

I marked the breakpoint, the package stops there, but i can edit anything in...

Yes thank you.

I didnt know how to delete one post.

Regards,

not body ?

Forgot the little detail.

I tried and I found I can do either way:

Option a

RESTORE DATABASE [backup] WITH noRECOVERY

Restore log [backup] FROM DISK = 'c:\Logshipping\LastTran.trn' with recovery

Option b

Restore log [backup]...

Ok.. Im doing some testing and I force the primary server to have an error so I can bring to live my StandBy database

the last log file wasnt restored, so...

I got it now.

Its just a different way to restore in time. I just need to restore the last one that hasnt been restored. or maybe the T-Log of...

Forgot to mention:

I have weekly full backups and hourly log backups

full backup size is 4GB

.tran is 1GB

so, evern if I have my differential sets. I can work just fine with...

Yes, I do understand that.

But, since the logs are being restored in the standby. i will need to do a restore steps like:

Restore las Fulbackup withnot recovery

Restore last diff with...

I GOT THE SOLUTION:

If you are looking to insert data into a database from flat files. Those flat files are located in different paths and you only need to get...

Ok, I got this so far.

I can read my files coming from different folders. You have to check the Traverse subfolders option on the collection in the Editor of the...

I can’t create a view at this point. Flat Files are located in specific path in another server. Maybe I’m not clear about the process.

I have 3 connections in my...

I found a solution:

for some reason the ODBC connection was gone (i guess after the updates) and the provider as well. Just need to be reinstalled and configured

here is teh...

Hi all,

I didnt have any chance to post the results 'cause we are with another issue.

The CHECKDB never end. It was still a KILL/ROLLBACK process "running". So when we...

I cant use a Loop becasue the path where I need toread has more than 1000 files, then the loop will process all the files. I need to repeat the...

should I stop it?

It has 3:23hours already