Files missing after upload

Hi,

I have used "Copy website" in WVD2008 to upload my site files to my account.

But only folders of the site showing after loading, all the web forms such as Default.aspx are not showing. Also the files under folders such as App_code are not showing.

What's the problem with that?

Thanks

 

Hi,
There are two things I would try first...
1) Re-sync your remote site from VWD.
2) Log into your Control Panel and [IIS Tools] Recycle App Pool, then Stop/Restart.
All the best,
Mark

 

I followed the steps, but I still can't see all the files....May be I didn't go to the right place.

Is "Web Application Tool" the right place to see all the files of my website?
and where can I see the files in the sql server 2008 database?

Thanks!

 

Hi,
When you use the Copy Website feature in VWD you should be able to see all of your remote files on the right side.
To see your SQL Server objects you'll need to use a local SQL Server, you can download the Express version of SQL Server 2008...Or you can use the DASP Web admin.
https://sqlwebadmin.discountasp.net/

 

You will not be able to see the individual files in your hosting control panel. What you are looking for is a file management tool. We don't have a file management tool inside the control panel. You can only see the files either through Visual Studio or through some type of FTP client.

 

I just wonder if all my database files uploaded correctly. I can see all the files from VWD when using Copy Site, but not the database files such as tables,stored procedures I created on local sql server 2008. I used SQL Server Management Studio to connect to my DASP account, but couldn't see the database files from there either.

When trying to open my site, I just got the following error message:

----------------------------------------------------------------------------------
Server Error in '/' Application.

Could not find stored procedure 'GetCatalogs'.

[FONT=Arial, Helvetica, Geneva, SunSans-Regular, sans-serif]Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Could not find stored procedure 'GetCatalogs'.

Source Error:

Line 32: {Line 33: Utilities.LogError(ex);Line 34: throw ex;Line 35: }Line 36: finally
Source File: e:\web\stareadcom0\htdocs\App_Code\GenericDataAccess.cs Line: 34

Stack Trace:

[SqlException (0x80131904): Could not find stored procedure 'GetCatalogs'.] GenericDataAccess.ExecuteSelectCommand(DbCommand command) in e:\web\stareadcom0\htdocs\App_Code\GenericDataAccess.cs:34 CatalogAccess.GetCatalog() in e:\web\stareadcom0\htdocs\App_Code\CatalogAccess.cs:43 UnserControls_CatalogList.Page_Load(Object sender, EventArgs e) in e:\web\stareadcom0\htdocs\UserControls\CatalogList.ascx.cs:12 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +50 System.Web.UI.Control.LoadRecursive() +141 System.Web.UI.Control.LoadRecursive() +141 System.Web.UI.Control.LoadRecursive() +141 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627[/FONT]

----------------------------------------------------------------------------------------------------

which shows the first stored procedure the site needs can not be found...

So I don't know if the database files actually got uploaded....

Thus my Big (naive) question should be how to upload db files created locally? will Copy Site also upload all the db files including tables, and procedures...? Or have to do separately?

Thanks a lot!!

Will

 

If you haven't already done so you will need to order the SQL addon for your account if you plan to have a SQL server for your application. Once this addon is provisioned in your account, you should be able to use the SQL Management Tool feature in the control panel to either attach or restore your local database to our server. Make sure you update the connection string to point to our server.

 

I do have SQL 2008 addon for my account. And I used Copy Site from VWD to upload all the folders/files of my site to DASP, so the ASPNETDB.MDF under App_data should be also be uploaded, right? Caz I can see ASPNETDB.MDF at the right side(remote site) of the Copy Site panel....

Or I have to use the "Attach MDF file" in SQL tool suite to upload ASPNETDB.MDF again separately?

The ASPNETDB.MDF on my local machine has size of 10MB, but the SQL Usage meter shows the ASPNETDB.MDF in my DASP account has only 2 MB . Does that mean the ASPNETDB has not been uploaded successfully?

Thanks!!

 

You will need to use the SQL Tool Suite in your control panel to upload the .mdf file to our SQL server. The sql server is a stand alone box separate from the web server. This gives our customer the added performance and security. Refer to this kb article.

http://kb.discountasp.net/KB/a188/sql-2008-management-tools.aspx

 

Thank you for the helps. But I still have problem, I followed the steps to detach the local sql db in SQL Server Management Studio, to upload MDF fle using Copy Site. Then used SQL tool suite to attach MDF file. But it seems the website still not work, it shows the same error message that the first stored procedure can not be found when be accessed...

And when viewing the db size in Database Management of DASP, its size is still 2 MB, but it is 10 MB in local server. Is it supposed to be like this due to compression or...?

And when I use SSMS to connect the db on my account, it only shows the tables created by VWD for security, not any tables I created. The screenshot is attached. Is this also right?

Please let me know, thanks a million!

 

When log into LittlePower interface, I can not see the tables, stored procedures created by me either...

So basically, the database objects are missing.......this problem has been several days and is driving me nuts.....please help!

 

Hi,
In your local system are some of the objects in separate DBes?
When you used the Attach tool did you sync your DB objects afterwards?
All the best,
Mark

 

hi Mark,

I did all the steps again from detach the database from the local SQL Management Studio...through attached MDF file. Then in the Copy Site panel, I selected all the files in the left panel and right click and choose sync site. But after that, I still have the same problem: the very first procedure can't be found.

I have all the files in one DB, please see the attached showing the "Solution Explorer" from my VWD, anything wrong with that?

And the other attached is my SSMSE showing tables I created from local SQL server at top but not showing my tables on remote server of my DASP account at buttom.

Anything I can do next?

Thanks for help!

 

Hi,
It looks to me that many of your remote DB objects are missing.
You can use your local SQL Express to pump them to remote.
I'm currently in the process of a series of Webcasts for SQL Server 2008 and I'll include things like that.
Some of the things you can use to your advantage now are the exciting new additions to SQL Server 2008, which for the first time include the Express versions, nice.
i.e. MultiServer Query and the new Object Explorer enhancements.
With those two tools you can quickly verify which objects, local and remote, are valid.
All the best,
Mark

 

hi Mark,

Could you briefly tell me how to use local SQL Exress to pump DB objects to my account?

I really need the website be up to show something immediately, the same problem has been hanging for a week...

BTW- when I use Ipswitch to ftp my account, the ASPNET.MDF file at DASP is showing as 10MB, but why "SQL Usage Meter" of my account shows it only as 2MB?

Thanks for your help.

 

Hi,
Looks like a Webcast on this would be helpful to many.
I need to check into something first with the Microsoft SQL Team...running the Express versions with my Developer editition on Vista Ultimate.
Which version are you using? With SQL Server 2008 Express there are three major editions of Express, some have more tools.
As for size, DASP does not hit us for the log file size, which is most often larger than the DB file itself.
All the best,
Mark

 

I am not sure which edition of SQL Server 2008 Express it is. There is a folder with name"MSSQL10.SQLEXPRESS" on my computer. My OS is Vista Home Premium (64bit).

And I tried to upload the DB to DASP in SSMSE by publish using web service, but failed.

 

Hi,
You can see the Express versions listed here:
http://blogs.msdn.com/sqlexpress/

In my Webcasts I'm going to suggest that DASP customers without SQL Server should install this version: Microsoft® SQL Server® 2008 Express with Tools
http://www.microsoft.com/downloads/...83-4CB2-454E-B908-E805E9BD4E28&displaylang=en

I got some good feedback on running 2008 Express with 2008 Dev on Vista so I'll go ahead and install it then create a Webcast tomorrow on how to do this.
All the best,
Mark

 

Thanks, I am looking forward to see that

 

Hi,
Me too. ;-)
I am working on it, hopefully today...Yesterday's plans fell to pieces.
All the best,
Mark

 

...Sorry for the delay

Here's the SQL Server 2008 (/Database/Table/Record Export) video:
video.wmv

*Best to view that in a recent version of IE, FF may ask for plugins. (Windows Media)
I'll get it on the dasptv.com site soon, had trouble just now adding it there.

Please let me know if anything is missing in that video, all too happy to correct it.
All the best,
Mark

 

The link to the video is not working.

 

...I clicked it just now and it played from FF3.5 and IE8.
Working on getting it on the Webcasts site right now, I'll re-post soon.

 

...Added a Silverlight and Flash version here: http://www.iis7test.com/webcasts/
(Videos 15 and 16, same Webcast, one is Silverlight Streaming the other Flash.)
All the best,
Mark

 

My website is showing up now after using the method in the video to upload db objects.

Thank you very much for the helps!

 

...Whew! Good job.