SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 how to upload long database online
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

vedjha
Posting Yak Master

India
225 Posts

Posted - 04/16/2013 :  15:51:30  Show Profile  Visit vedjha's Homepage  Reply with Quote
Sir,
I have to upload heavy database online.

1st Step

I have generated tables query and uploading . it takes lots of time but uploading rest.

2nd Step

I have convert data in to excel file into a certain format and calling that sheet to upload online. It takes long time still task not completed.


3rd Step

I have take backup MS Sql database as filename.bak
and restore in MS SQL Server 2005. it is in shared server.
as I choose from device---> select Path-->
window appear as Specify backup--->> click Add Button
but it does not shows directory where i can select my backup file.

so this process not completed.


please guide me how can i upload heavy database online in minimum time
its very urgent
please help


http://kiransoftech.com

chadmat
The Chadinator

USA
1974 Posts

Posted - 04/16/2013 :  16:58:01  Show Profile  Visit chadmat's Homepage  Reply with Quote
It should give you a dialog where you can browse to your backup file. If it doesn't, just script the restore rather than use the gui.

-Chad
Go to Top of Page

vedjha
Posting Yak Master

India
225 Posts

Posted - 04/16/2013 :  19:48:00  Show Profile  Visit vedjha's Homepage  Reply with Quote
Hello Chad,

as I say That i am using Shared Server, window appears but a message box appears and says that for security reason we cannot show you drives.
so window appears as a blank window.

http://kiransoftech.com
Go to Top of Page

chadmat
The Chadinator

USA
1974 Posts

Posted - 04/16/2013 :  19:55:32  Show Profile  Visit chadmat's Homepage  Reply with Quote
Looks like you need to talk to an Admin and have permissions granted so you can see the drives.

-Chad
Go to Top of Page

vedjha
Posting Yak Master

India
225 Posts

Posted - 04/18/2013 :  07:04:38  Show Profile  Visit vedjha's Homepage  Reply with Quote
in shared server, no more rights

http://kiransoftech.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000