<div>
Make a backup of all databases.
</div>


<div>
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)
</div>


<div>
Right, getting there with the PowerShell...I'm using this command:<br />

<pre><code class="code-1 nolinks" id="code-20-41472556-1"><span>Backup-SqlDatabase -ServerInstance dmssql.databasehost.co.uk -Database silas02_walkden2 -Credential (Get-Credential silas02_uname) -BackupFile &quot;c:\deletes\walkden.bak&quot;</span>
</code></pre>
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)
</div>


<div>
no it will not bring the DB down
</div>


<div>
wht version of powershell are you running?
</div>


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


<div>
<blockquote>
That transact SQL isn't going to bring the DB down from the web is it?
</blockquote>
You can backup to a network share:<br />

<pre><code class="code-1 nolinks" id="code-20-41475409-1"><span>BACKUP DATABASE DatabaseName</span>
<span> TO DISK = '\\ServerName\ShareName\DatabaseName.Bak'</span>
</code></pre>
</div>


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


<div>
<div class="content wysiwyg-content">
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.<br />
What is the best thing to do?
</div>
</div>


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?

SQL Backup

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.