mardi 15 mars 2016

Full Backup of MSSQL 2005 Database (with script or visual studio?)

I'm not much into MSSQL, but I need to do a full backup of a remote MSSQL-2005 Database. I have a computer with Visual Studio 2013 Prof. installed. I can use the Server-Explorer of Visual Studio to look into the database, but there seem to be no way to backup it there.

I found C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Publishing\1.2\SqlPubWiz.exe installed on my computer. But starting it with doubleclick, it just crashes.

I tried starting it via console with:

"C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Publishing\1.2\sqlpubwiz.exe" script -d mydatabase -S myserver -U myuser -P mypass g:\mybackup.sql

but it just says:

Microsoft (R) SQL Server Datenbankveröffentlichungs-Assistent
Version (10.0.0.0)
Copyright (c) Microsoft Corporation. Alle Rechte vorbehalten.

Done.

Without outputting anything to g:\mybackup.sql

Any ideas?

Aucun commentaire:

Enregistrer un commentaire