Click here to Skip to main content
15,895,746 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello everyone ,

I have a problem about running my MSSQL script on my hosting. I created a sql db using aspnet_regsql on command prompt. After i generate db's script.

When i trying to run this script on my hosting. It's giving Incorrect syntax near "GO" error.

I'm trying import just default aspnet_regsql's db.

I can't find the problem.


Also i made a .bak file. I tried this way. But this time we have this error :

SQL
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: Error executing 'RESTORE' task on 'aspnetdb' SQL_DATABASE ---> System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> The media family on device 'C:WindowsTEMPaspnetdb.bak' is incorrectly formed. SQL Server cannot process this media family.
RESTORE FILELIST is terminating abnormally.
Posted
Updated 2-Jul-14 22:23pm
v2

1 solution

I think your .sql file has format issue. Refer [Format Issue]
 
Share this answer
 
v2
Comments
kozmikadam 3-Jul-14 1:57am    
Already , i tried this. I convert to Windows format with Notepad++. But still i have same problem.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900