asked on

SQL Backup

I've got a SQL server at an ISP which I want to archive, structure + data. I'm trying to find the old SQL Publishing Wizard, but I can't seem to get one that works. I just want a backup in case this app ever goes online again.
What is the best thing to do?

ste5an

Make a backup of all databases.

SOLUTION

Arana (G.P.)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Silas2

ASKER

That transact SQL isn't going to bring the DB down from the web is it? (I can't make a file on the remote server)

Silas2

ASKER

Right, getting there with the PowerShell...I'm using this command:

Backup-SqlDatabase -ServerInstance dmssql.databasehost.co.uk -Database silas02_walkden2 -Credential (Get-Credential silas02_uname) -BackupFile "c:\deletes\walkden.bak"

Open in new window

I'm getting in, but just saying the backup file doesn't exist. I was hoping it would make it + even better to make a sql script like the wizard used to ....any help? (sorry to be so helpless)

Arana (G.P.)

no it will not bring the DB down

Arana (G.P.)

wht version of powershell are you running?

ASKER CERTIFIED SOLUTION

Arana (G.P.)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Silas2

ASKER

Thanks for that.
The funny thing is, I keep getting 'Cannot open device c:\deletes\walkden.bak', maybe I should create it with Management Studio?

Vitor Montalvão

That transact SQL isn't going to bring the DB down from the web is it?

You can backup to a network share:

BACKUP DATABASE DatabaseName
 TO DISK = '\\ServerName\ShareName\DatabaseName.Bak'

Open in new window

Silas2

ASKER

The db as with an ISP, I don't have any network share, only ftp access.

SOLUTION

Vitor Montalvão

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial