What we discovered for a solution: We change the default encoding of UTF-8 to UTF-16 and then in the insert code change the varchar to nvarchar. That worked and I...

The developer is trying to load data from an xml file and he is getting an error of "invalid character was found in text content" The character data that is...

Thanks for all the input. I am working with the network guys on this. Then I want to test, test, test recoverability.

Thanks

Kathy

We are working on this with our network guys and they say they can't do VM backups without Backup Exec doing a database backup. Has anyone found a work around...

Thanks for all the comments--I needed a good laugh.

Kathy

Hi Lowell

I am trying your script. It is executing successfully but the backups are not being copied over. Have you experience this? I have to do some research into robocopy...

Thank you so much for all of your input. I will have to look into the suggested solutions to see what works for each environment.

Thanks again

Kathy

all are Standard Edition

I have sql server 6.5, 7.0, 2000, 2005, 2008, 2008R2, and 2012.

Thanks

Kathy

Yes the production servers have mirrored sessions also. The production servers were set up before the test servers. There was no testing. Now as the DBA, I would like to...

Thanks I'll give it a try.

Kathy

No. The Alter and Tail-log backup were done in one query window and then the attempt at the full restore was done in another query window.

Thanks

Kathy

Yes the Alter command to set to single_user did complete successfully. To ensure this I ran this code

USE [master]

ALTER DATABASE [TESTFULL] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

GO

and got this message

Msg 5064,...

I ran the exec sp_who2 and my TESTFULL database isn't listed. I do have a database that stores statistics from databases, servers, etc. I disabled the jobs for this server....

Thanks for the input. I tried your suggestion as seen below and I still get the same error message:

USE [master]

RESTORE DATABASE [TESTFULL] FROM DISK = N'TESTFULL_FULL_20141120_190322.bak'

WITH FILE...