|
|
Rank: Newbie
Groups: Member
Joined: 6/17/2007
Posts: 4
Points: 0
Location: Edinburgh
|
I have my new asp.net website working a treat on my local PC and now's the time to upload to the web hosting company's server - can I use myLittleBackup to publish my database to the host for the first time? If so, how? If not, what do most folks do? Do you use the Microsoft SQL script generating wizard or is there a simpler way?
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
If your web hoster proposes myLittleBackup in its control panel, then it is definitively the easiest solution for you to publish your database.
You just to need to create a backup of your database on your development server (with SQL Server Management Studio for instance. Then log into myLittleBackup. Click on the restore link. Choose your db, upload the backup file and click on the restore button. This is all what you have to do!
|
|
Rank: Newbie
Groups: Member
Joined: 6/17/2007
Posts: 4
Points: 0
Location: Edinburgh
|
So the backup file is a different format from the original mdf? I think I understand now.
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
Quote:So the backup file is a different format from the original mdf? Yes it is. You can create a backup file from SQL Server Management Studio or using a T-SQL command For instance Code:BACKUP DATABASE yourdbname TO DISK='c:\yourdbname.bak'
WITH SKIP, NOREWIND, NOUNLOAD, STATS=10
|
|
Rank: Newbie
Groups: Member
Joined: 6/17/2007
Posts: 4
Points: 0
Location: Edinburgh
|
Thank you - you have been very helpful
|
|
Rank: Newbie
Groups: Member
Joined: 7/6/2007
Posts: 1
Points: 0
Location: Buenos Aires
|
Hi Guys!
But How can I get my back up again into the server after that.
I dont see an option for do that at tools or management.
I have a bak file that I want to use to populate my db again.
I have myLittleAdmin available on my shared hosting.
I only see an option to import data from csv files :(
Could you please give me some ideas?
Thank you in advance-
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
Check if your webhoster offers myLittleBackup.
Restore feature in myLittleAdmin is often disabled by the hosting companies.
|
|
Rank: Newbie
Groups: Member
Joined: 12/24/2007
Posts: 1
Points: 0
|
I tried calling my web host to enable myLittleBackup but I think they're loaded with calls. I really need help in uploading my db online... how can you do that without using myLittleBackup?
|
|
|
Guest |