Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Backup to External Without a Backup Device

Author  Topic 

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2010-12-28 : 14:41:36
Hi everyone,

backup database DEPDB to "\\PNCLRMDBCO\C$\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\FromRMDB\DEPDB.bak" WITH INIT, COPY_ONLY;

This parses correctly but fails upon execution becasue it cannot find a backup device named \\PNCLRMDBCO\C$\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\FromRMDB\DEPDB.bak

Will I HAVE to create a backup device to do the above ?

Thanks, John

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-12-28 : 14:52:00
backup database DEPDB
to disk = '\\PNCLRMDBCO\C$\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\FromRMDB\DEPDB.bak'
WITH INIT, COPY_ONLY

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2010-12-28 : 14:54:56
.... and that worked (of course).

Thanks, Tara!
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-12-28 : 14:55:30
You're welcome, glad to help.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -