I'm sorry Gail--new to this.

I do have a separate server for the principal, mirror, and witness.

I get no errors when I look at the Database Mirroring Monitor

When I...

The attached pdf is the database layout on the mirror server.

Thanks

Kathy

Hi Gail

No the databases that are on the mirror server are not listed in the results of the query select name from sys.databases. I wonder if instead of first...

I found the answer--I took any semi-colons off my statements and the 55 rows exported.

Thanks

Kathy

Yes I have the correct server and database selected. When I do the preview on the OLE DB Source Editor I see the data but when I try and look...

Hi Perry

Your response was very clear and concise. I greatly appreciate your input. I'm so sorry that I did not respond correctly.

While I am learning, I make mistakes and...

I did consider changing the Ola's script but I would have had to learn how to deal with tokens, which I will learn eventually. So I made the decision to...

robocopy e:\backup|xxx'$'xxx\master\Full "*.bak" \\sharebackup\xxx'$'xxx\master\Full worked!!

I couldn't assign variables to represent the $SourceLocation = e:\backup|xxx'$'xxx\master\Full or $DestinationLocation = \\sharebackup\xxx'$'xxx\master\Full that I use to do error checking. So if...

This is the error I am receiving:

A job step received an error at line 17 in a PowerShell script.

The corresponding line is 'throw("Failure in copying $SourceLocation files to...

I will try again and report back.

No real solid reason for using robocopy vs. move. I have a powershell script that runs robocopy from sql server agent. So right after the agent executes Ola's backup...

No I haven't tried that yet. I was first looking for a syntactical solution -- if possible.

I guess I don't understand the question. Would you elaborate please?

Thanks

Kathy

Thanks Steve!

I found out that the table's data is deleted based on date so all the data may not necessarily be deleted. I suggested that when select count(*) from this...

Thanks Grant--got it