Hi,
I tried to the following but i'm getting an error near '.' Can someone tell
me if this is correct?
Here is my syntax to backup a database from another location:
BACKUP DATABASE [192.168.160.20].Mydatabase TO DISK =
N'\\BACKUPSERVER\Backup\Mydatabase.bak'You cannot server qualify the database for the backup command. Try below:
BACKUP DATABASE Mydatabase TO DISK =
N'\\BACKUPSERVER\Backup\Mydatabase.bak'
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Jason" <jasonlewis@.hotrmail.com> wrote in message news:O1OAmoQNFHA.1496@.TK2MSFTNGP10.phx.g
bl...
> Hi,
> I tried to the following but i'm getting an error near '.' Can someone tel
l
> me if this is correct?
> Here is my syntax to backup a database from another location:
> BACKUP DATABASE [192.168.160.20].Mydatabase TO DISK =
> N'\\BACKUPSERVER\Backup\Mydatabase.bak'
>
No comments:
Post a Comment