Error 1221 and 1102 on making back ups in SQL 2008 DB

Asked By 0 points N/A Posted on -
qa-featured

I have SQL 2008 Database installed on Windows 2003 server. But I am receiving Error 1221 and error 1102 during the backup process. I have searched everywhere but I could not find a perfect solution. Can anybody suggest any solution?

SHARE
Answered By 0 points N/A #118293

Error 1221 and 1102 on making back ups in SQL 2008 DB

qa-featured

Error 1102 is most likely to appear as Retrospect is trying to protect your data. Even if it knows that a repartitioned volume with the same name, it will still see as a different volume as the volume ID information is different.

You may try the steps below:

·         Inside Retrospect, try to unlicensed and relicense SQL.

·         Change the settings in Retrospect that it will not back up duplicate files which are already in the backup set.

·         Remove and read volume in Retrospect.

·         Make sure that the ‘Match only files in same location’ option is always turned on.

Login/Register to Answer

Related Questions