Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 how to upload long database online

Author  Topic 

vedjha
Posting Yak Master

228 Posts

Posted - 2013-04-16 : 15:51:30
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

1974 Posts

Posted - 2013-04-16 : 16:58:01
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

228 Posts

Posted - 2013-04-16 : 19:48:00
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

1974 Posts

Posted - 2013-04-16 : 19:55:32
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

228 Posts

Posted - 2013-04-18 : 07:04:38
in shared server, no more rights

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

- Advertisement -