Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Backing up SQL database
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Backing up SQL database
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
Redbelt View Drop Down
Newbie
Newbie


Joined: 18 April 2006
Location: Bahrain
Status: Offline
Points: 3 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Redbelt Quote  Post ReplyReply Direct Link To This Post Topic: Backing up SQL database
    Posted: 18 April 2006 at 10:10pm
Hi guys
I will sound like a complete NOOB but
I want to migrate from 7.x to 8 and before I run the tool I gotta back up the Database.
I have a dedicated Win server with shared SQL server. I don't know how I can back up my data before I upgrade.
Can anyone help?
Cry
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 19 April 2006 at 10:20am
The way I usually back up an SQL Server database is to install SQL Server on my own PC then use Enterprise Manager to backup the database to my own PC.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Redbelt View Drop Down
Newbie
Newbie


Joined: 18 April 2006
Location: Bahrain
Status: Offline
Points: 3 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Redbelt Quote  Post ReplyReply Direct Link To This Post Posted: 19 April 2006 at 12:57pm
Thanks -boRg-
 
I don't have SQL Server now, can I do it with Access 2003 or is SQL a must?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 19 April 2006 at 1:00pm
You can't with Access.

Why not download the free version of SQL Server from Microsoft?
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670 		Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 19 April 2006 at 3:23pm
Or, if you have a shared SQL Server, check with your host to run an actual backup at a certain time. My host setup a backup device pointing to my own folder (web directory) so I can down and upload backup file via ftp.
Blog | MPG Tracker
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.