MS SQL

MS SQL RSS

Backuping error

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Oct 2008

Posts: 57

Reputation: konczuras is an unknown quantity at this point

Solved Threads: 1

konczuras

Offline

Junior Poster in Training

Backuping error

Nov 19th, 2008

Hello!

I want to use the following code

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
SELECT *
INTO Persons_Backup IN 'Backup.mdb'
FROM Persons
SELECT *
INTO Persons_Backup IN 'Backup.mdb'
FROM Persons

But all I ever get is the error message: "Incorrect syntax near IN"
How could I solve this?

But when I miss the IN clause, it works perfectly.
I think the problem is that I'm not connected to the second database, which I need to copy the data into. But how is it possible to be connected to two databases via one connection string?

Thank you very much!

Last edited by peter_budo; Nov 19th, 2008 at 8:26 pm. Reason: Please [code] tag, instead of [quote]

•

Join Date: Dec 2007

Posts: 252

Reputation: ProfessorPC is an unknown quantity at this point

Solved Threads: 27

ProfessorPC ProfessorPC is offline

Offline

Posting Whiz in Training

Re: Backuping error

Nov 24th, 2008

try this

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
USE Persons;
GO
BACKUP DATABASE Persons
TO DISK = 'Z:\SQLServerBackups\Persons.Bak'
   WITH FORMAT,
      MEDIANAME = 'Z_SQLServerBackups',
      NAME = 'Full Backup of Persons';
GO
USE Persons;
GO
BACKUP DATABASE Persons
TO DISK = 'Z:\SQLServerBackups\Persons.Bak'
   WITH FORMAT,
      MEDIANAME = 'Z_SQLServerBackups',
      NAME = 'Full Backup of Persons';
GO