Snitz Forums 2000 - mssql backup

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: Database: MS SQL Server

mssql backup

New Topic

Topic Locked

Printer Friendly

Author

Topic

i_need_help
Starting Member

2 Posts

Posted - 01 September 2006 : 12:49:59

Hi
I have a hosted site and I'm setting up this forum on it using MSSQL, not being a DBA or having access to the server how do I back up the data off server ie dump it some how to a flat file?

Thanks

Podge
Support Moderator

Ireland
3776 Posts

Posted - 01 September 2006 : 13:12:04

Is there any particular need to have it in a flat file ? Would a normal MSSQL backup do ?

Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.

i_need_help
Starting Member

2 Posts

Posted - 01 September 2006 : 13:41:08

I just assumed that as I have no access to the server it would need to be done that way!?

I just want a backup so if my ISP wipes the db I still have most of the data...

Podge
Support Moderator

Ireland
3776 Posts

Posted - 01 September 2006 : 13:55:18

If they allow external access (e.g. via Enterprise Manager) you could transfer the contents of the database using DTS to a local version running on your computer i.e. MSDE or Sql Sxpress.

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 01 September 2006 : 14:13:45

if no remote access, you could use something like TableEditor, or the .net SQLmanager if your host supports .net to do a transfer or backup

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.18 seconds.