Sql Restore Error

By -
I was doing a client implementation and in the process I have to do a SQL restore (48 GB, yes crazy). My customer uploaded the back-up to an ftp site and I tried downloading it from there.

I was getting the following error while restore. I did it with three different copy and everytime I got the same issue.
=======================================================================
The media family on device 'My_Content_DB.bak' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)

=======================================================================

Cause.

The backup was corrupted. The file was transferred using FTP in text mode rather than binary mode.


Solution.

1.Downloaded Filezilla.
2. Asked my customer to upload it to ftp with the binary option. (Trasfer > changed the Format from Auto to 'Binary'.)
3. The backup file was transferred again using FTP in binary mode.
4. I did the same thing using Filezilla to download the back up file.
5. Restore operation was successful.

Baam Zoom! Done

Comments

Anonymous said…
Битторрент трекер KINORELIZ.NET предоставляет шанс абсолютно бесплатно скачать бесплатно торрент фильмы, музыку, игры, книги, программы, документацию. Быстрый торрент трекер - лучший способ ускорить просмотр кино или прослушивание мелодий.

KINORELIZ.NET Торрент трекер: [url=http://kinoreliz.net]торрент скачать[/url]
3:17 PM
Anonymous said…
Если вы столкнулись с вопросом, как зарегистрировать предприятие, не обладая необходимой юридической подготовкой, то надежнее обратиться в ООО "Регистратор". Ведь для самостоятельного сбора всех надлежащих документов необходимо время и знания, так как любая ошибка может обойтись слишком дорого. Высококвалифицированные специалисты ООО "Регистратор" возьмутся качественно оформить фирму.

ООО "Регистратор": [url=http://www.registratorfirm.ru/howtoregfirm/]оформление фирмы[/url]
10:53 AM
Anonymous said…
Несмотря на визуальную простоту, регистрация в качестве ип требует соблюдение надлежащих норм и правил, поэтому лучше доверьтесь профессионалам, которые имеют практический опыт такого рода. Если вы полюбопытствуйте, как оформить ип, вам ответят очень запросто.… Квалифицированные юристы ООО "РЕГИСТРАТОР" возьмут всю операцию оформления и регистрации вашей фирмы, на себя...

Юридические услуги - [url=http://www.registratorfirm.ru/openip/]ип оформление[/url]
4:34 AM
Post a Comment

Popular posts from this blog

Linksys Wireless Connection Failure

By -
I configured the Linksys wireless router [WRT54G] couple of years before and it just worked great. I myself configured the password and everything worked great at my home. Anyone comes in home takes my password and it just worked great most of the time. all these were with windows server 2003 and Dell machaines. When I bought a new Hp DV9000 (XP) I had an issue connecting to the home wireless. I started browsing and found this solution: Issue : Couldn't connect to the selected connection. 1. Installed an update http://www.microsoft.com/downloads/thankyou.aspx?familyId=17d997d2-5034-4bbb-b74d-ad8430a1f7c8&displayLang=en Issue after the update : Acquiring Network address status and stayed there. Did the following after that: 1. Browsed http://192.168.1.1/ 2. used the user-id / password of the connection (default userid is empty & pwd is admin) 3. Navigated to wireless (Basic wireless settings), click Reset security and name your userid for SSID 4. Clicked save settings 5. cli...
Read more

The security validation for this page is invalid. Click Back in your Web

By -
If you are getting the following error, while renaming the page title using publishingpage object " The security validation for this page is invalid. Click Back in your Webbrowser, refresh the page, and try your operation again ." Code Snippet: PublishingWeb publishingweb = PublishingWeb.GetPublishingWeb(newUri(" http://YourPortal/Plans/ ")); PublishingPage pp =publishingweb.GetPublishingPages()["Pages/TestArticle.aspx"]; pp.Title = e.Node.Text; pp.Update(); You should check for this : Navigate thru the followwing and turn the security validation Off Central Administration--->application management---->web application settings-->"turn security validation off"
Read more

Access Denied Host Header Sharepoint 2010 Windows Server 2008 R2

By -
If you are running into a weird issue, where you get prompted for your credentials repeatedly in your local sharepoint server and was denied access to the site, even though you are using an administrator account, and if this happens only when you create a nice host header and on 80 port, then you are here at the right place - Just read the below. Method 1 works for me :  Click  Start , click  Run , type  regedit , and then click  OK . In Registry Editor, locate and then click the following registry key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\MSV1_0 Right-click  MSV1_0 , point to  New , and then click  Multi-String Value . Type  BackConnectionHostNames , and then press ENTER. Right-click  BackConnectionHostNames , and then click  Modify . In the  Value data  box, type the host name or the host names for the sites that are on the local computer, and then click  OK . Quit Registry Editor, and th...
Read more