2005 Express Backup Error:Set Property Devices to accomplish this action.

I am getting error "Set property devices to accomplish this action" when I
try to do a full (or differential) backup on SQL Server 2005 Express though
the SQL Server Management Studio. I'm using the backup defaults in the GUI
and was able to back the database up a couple of days ago without any
problem. Today (second time) it just comes up with this error and I can't
find anything on the web or in Microsoft's site that talks about what it
might be.
I've tried to look at the script by using the "Script action to new query,
file, clipboard, etc., but it fails before it writes anything to either
destination. I've rebooted the server and cussed at it a great deal but
that didn't help either.
Any direction you can provide would be greatly appreciated.
Thank you,
SteveHi Steve
You don't say where you are trying to backup to?
SSMS has the option to show you the SQL Statement that it would execute. Try
copying that to the query window and running it. If that fails you could post
the statement and the exact error message.
John
"Steve Ricketts" wrote:
> I am getting error "Set property devices to accomplish this action" when I
> try to do a full (or differential) backup on SQL Server 2005 Express though
> the SQL Server Management Studio. I'm using the backup defaults in the GUI
> and was able to back the database up a couple of days ago without any
> problem. Today (second time) it just comes up with this error and I can't
> find anything on the web or in Microsoft's site that talks about what it
> might be.
> I've tried to look at the script by using the "Script action to new query,
> file, clipboard, etc., but it fails before it writes anything to either
> destination. I've rebooted the server and cussed at it a great deal but
> that didn't help either.
> Any direction you can provide would be greatly appreciated.
> Thank you,
> Steve
>
>|||Just a standard backup to the default location. In fact all I did is right
click the database, Tasks, Back Up, and clicked Ok.
As I said, I've tried to get the script by using the "Script action to new
query, file, clipboard, etc., but it fails before creating the script. I'm
using the "Script" pull-down at the top of SSMS's Backup Database dialog
page. This is the only way I know to get the script for the task. If there
is another way, please explain and I'll give that a go and post it here.
The exact error message is:
Backup failed for Server 'xxx.xxx.xxx.xxx'.
(Microsoftt.SqlServer.Express.Smo)
Additional Information:
Set property Devices to accomplish this action.
(Microsoftt.SqlServer.Express.Smo)
Thanks for the reply,
Steve
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:6E760A54-E11D-4C3D-A759-57652863FF87@.microsoft.com...
> Hi Steve
> You don't say where you are trying to backup to?
> SSMS has the option to show you the SQL Statement that it would execute.
> Try
> copying that to the query window and running it. If that fails you could
> post
> the statement and the exact error message.
> John
> "Steve Ricketts" wrote:
>> I am getting error "Set property devices to accomplish this action" when
>> I
>> try to do a full (or differential) backup on SQL Server 2005 Express
>> though
>> the SQL Server Management Studio. I'm using the backup defaults in the
>> GUI
>> and was able to back the database up a couple of days ago without any
>> problem. Today (second time) it just comes up with this error and I
>> can't
>> find anything on the web or in Microsoft's site that talks about what it
>> might be.
>> I've tried to look at the script by using the "Script action to new
>> query,
>> file, clipboard, etc., but it fails before it writes anything to either
>> destination. I've rebooted the server and cussed at it a great deal but
>> that didn't help either.
>> Any direction you can provide would be greatly appreciated.
>> Thank you,
>> Steve
>>|||Hi Steve
What is in the backup destination? If the backup is to disc and there is a
file specified, try removing it and adding a different one.
You could also try a backup command in a query window such as
BACKUP DATABASE [DBNAME] TO DISK = N'C:\MSSQL\BACKUP\DBNAME.bak'
WITH NOFORMAT, NOINIT, NAME = N'DBNAME-Full Database Backup', SKIP,
NOREWIND, NOUNLOAD, STATS = 10
GO
You would need to put in the correct details for you database etc..
John
"Steve Ricketts" wrote:
> Just a standard backup to the default location. In fact all I did is right
> click the database, Tasks, Back Up, and clicked Ok.
> As I said, I've tried to get the script by using the "Script action to new
> query, file, clipboard, etc., but it fails before creating the script. I'm
> using the "Script" pull-down at the top of SSMS's Backup Database dialog
> page. This is the only way I know to get the script for the task. If there
> is another way, please explain and I'll give that a go and post it here.
> The exact error message is:
> Backup failed for Server 'xxx.xxx.xxx.xxx'.
> (Microsoftt.SqlServer.Express.Smo)
> Additional Information:
> Set property Devices to accomplish this action.
> (Microsoftt.SqlServer.Express.Smo)
> Thanks for the reply,
> Steve
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:6E760A54-E11D-4C3D-A759-57652863FF87@.microsoft.com...
> > Hi Steve
> >
> > You don't say where you are trying to backup to?
> >
> > SSMS has the option to show you the SQL Statement that it would execute.
> > Try
> > copying that to the query window and running it. If that fails you could
> > post
> > the statement and the exact error message.
> >
> > John
> >
> > "Steve Ricketts" wrote:
> >
> >> I am getting error "Set property devices to accomplish this action" when
> >> I
> >> try to do a full (or differential) backup on SQL Server 2005 Express
> >> though
> >> the SQL Server Management Studio. I'm using the backup defaults in the
> >> GUI
> >> and was able to back the database up a couple of days ago without any
> >> problem. Today (second time) it just comes up with this error and I
> >> can't
> >> find anything on the web or in Microsoft's site that talks about what it
> >> might be.
> >>
> >> I've tried to look at the script by using the "Script action to new
> >> query,
> >> file, clipboard, etc., but it fails before it writes anything to either
> >> destination. I've rebooted the server and cussed at it a great deal but
> >> that didn't help either.
> >>
> >> Any direction you can provide would be greatly appreciated.
> >>
> >> Thank you,
> >>
> >> Steve
> >>
> >>
> >>
>
>|||Yes, I was backing up to a disk. I tried removing the file and doing the
query but neither worked. So I just uninstalled everything that had to do
with SQL Server 2005 Express and reinstalled. The backup is working now,
but what a way to fix it!!
Thanks for all your suggestions, very much appreciated.
Steve
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:E74A68D4-51AE-46F9-90EE-B0A3AE04C48C@.microsoft.com...
> Hi Steve
> What is in the backup destination? If the backup is to disc and there is a
> file specified, try removing it and adding a different one.
> You could also try a backup command in a query window such as
> BACKUP DATABASE [DBNAME] TO DISK = N'C:\MSSQL\BACKUP\DBNAME.bak'
> WITH NOFORMAT, NOINIT, NAME = N'DBNAME-Full Database Backup', SKIP,
> NOREWIND, NOUNLOAD, STATS = 10
> GO
> You would need to put in the correct details for you database etc..
> John
>
> "Steve Ricketts" wrote:
>> Just a standard backup to the default location. In fact all I did is
>> right
>> click the database, Tasks, Back Up, and clicked Ok.
>> As I said, I've tried to get the script by using the "Script action to
>> new
>> query, file, clipboard, etc., but it fails before creating the script.
>> I'm
>> using the "Script" pull-down at the top of SSMS's Backup Database dialog
>> page. This is the only way I know to get the script for the task. If
>> there
>> is another way, please explain and I'll give that a go and post it here.
>> The exact error message is:
>> Backup failed for Server 'xxx.xxx.xxx.xxx'.
>> (Microsoftt.SqlServer.Express.Smo)
>> Additional Information:
>> Set property Devices to accomplish this action.
>> (Microsoftt.SqlServer.Express.Smo)
>> Thanks for the reply,
>> Steve
>>
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:6E760A54-E11D-4C3D-A759-57652863FF87@.microsoft.com...
>> > Hi Steve
>> >
>> > You don't say where you are trying to backup to?
>> >
>> > SSMS has the option to show you the SQL Statement that it would
>> > execute.
>> > Try
>> > copying that to the query window and running it. If that fails you
>> > could
>> > post
>> > the statement and the exact error message.
>> >
>> > John
>> >
>> > "Steve Ricketts" wrote:
>> >
>> >> I am getting error "Set property devices to accomplish this action"
>> >> when
>> >> I
>> >> try to do a full (or differential) backup on SQL Server 2005 Express
>> >> though
>> >> the SQL Server Management Studio. I'm using the backup defaults in
>> >> the
>> >> GUI
>> >> and was able to back the database up a couple of days ago without any
>> >> problem. Today (second time) it just comes up with this error and I
>> >> can't
>> >> find anything on the web or in Microsoft's site that talks about what
>> >> it
>> >> might be.
>> >>
>> >> I've tried to look at the script by using the "Script action to new
>> >> query,
>> >> file, clipboard, etc., but it fails before it writes anything to
>> >> either
>> >> destination. I've rebooted the server and cussed at it a great deal
>> >> but
>> >> that didn't help either.
>> >>
>> >> Any direction you can provide would be greatly appreciated.
>> >>
>> >> Thank you,
>> >>
>> >> Steve
>> >>
>> >>
>> >>
>>|||Hi Steve
What error message did the manual backup return? If this was the same as
SSMS then it would rule SSMS out. If the disc file was a different one (and
premissions had been ruled out) then you could rule out the device. I had not
ascertained with it was related to this database or others, if every database
exhibited this problem then re-installing SQL Server may have to be one of
the option!!
John
"Steve Ricketts" wrote:
> Yes, I was backing up to a disk. I tried removing the file and doing the
> query but neither worked. So I just uninstalled everything that had to do
> with SQL Server 2005 Express and reinstalled. The backup is working now,
> but what a way to fix it!!
> Thanks for all your suggestions, very much appreciated.
> Steve
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:E74A68D4-51AE-46F9-90EE-B0A3AE04C48C@.microsoft.com...
> > Hi Steve
> >
> > What is in the backup destination? If the backup is to disc and there is a
> > file specified, try removing it and adding a different one.
> >
> > You could also try a backup command in a query window such as
> >
> > BACKUP DATABASE [DBNAME] TO DISK = N'C:\MSSQL\BACKUP\DBNAME.bak'
> > WITH NOFORMAT, NOINIT, NAME = N'DBNAME-Full Database Backup', SKIP,
> > NOREWIND, NOUNLOAD, STATS = 10
> > GO
> >
> > You would need to put in the correct details for you database etc..
> >
> > John
> >
> >
> > "Steve Ricketts" wrote:
> >
> >> Just a standard backup to the default location. In fact all I did is
> >> right
> >> click the database, Tasks, Back Up, and clicked Ok.
> >>
> >> As I said, I've tried to get the script by using the "Script action to
> >> new
> >> query, file, clipboard, etc., but it fails before creating the script.
> >> I'm
> >> using the "Script" pull-down at the top of SSMS's Backup Database dialog
> >> page. This is the only way I know to get the script for the task. If
> >> there
> >> is another way, please explain and I'll give that a go and post it here.
> >>
> >> The exact error message is:
> >>
> >> Backup failed for Server 'xxx.xxx.xxx.xxx'.
> >> (Microsoftt.SqlServer.Express.Smo)
> >> Additional Information:
> >> Set property Devices to accomplish this action.
> >> (Microsoftt.SqlServer.Express.Smo)
> >>
> >> Thanks for the reply,
> >>
> >> Steve
> >>
> >>
> >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> >> news:6E760A54-E11D-4C3D-A759-57652863FF87@.microsoft.com...
> >> > Hi Steve
> >> >
> >> > You don't say where you are trying to backup to?
> >> >
> >> > SSMS has the option to show you the SQL Statement that it would
> >> > execute.
> >> > Try
> >> > copying that to the query window and running it. If that fails you
> >> > could
> >> > post
> >> > the statement and the exact error message.
> >> >
> >> > John
> >> >
> >> > "Steve Ricketts" wrote:
> >> >
> >> >> I am getting error "Set property devices to accomplish this action"
> >> >> when
> >> >> I
> >> >> try to do a full (or differential) backup on SQL Server 2005 Express
> >> >> though
> >> >> the SQL Server Management Studio. I'm using the backup defaults in
> >> >> the
> >> >> GUI
> >> >> and was able to back the database up a couple of days ago without any
> >> >> problem. Today (second time) it just comes up with this error and I
> >> >> can't
> >> >> find anything on the web or in Microsoft's site that talks about what
> >> >> it
> >> >> might be.
> >> >>
> >> >> I've tried to look at the script by using the "Script action to new
> >> >> query,
> >> >> file, clipboard, etc., but it fails before it writes anything to
> >> >> either
> >> >> destination. I've rebooted the server and cussed at it a great deal
> >> >> but
> >> >> that didn't help either.
> >> >>
> >> >> Any direction you can provide would be greatly appreciated.
> >> >>
> >> >> Thank you,
> >> >>
> >> >> Steve
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||Well, very odd indeed! After the reinstall, the backup worked for a couple
of days and then stopped today with the same error!
I tried your suggestions and both worked without an error. The script
backed up the database and changing the name of the backup also worked. So,
does that give you a good clue?... I hope! ;-)
Steve
"John Bell" wrote:
> Hi Steve
> What error message did the manual backup return? If this was the same as
> SSMS then it would rule SSMS out. If the disc file was a different one (and
> premissions had been ruled out) then you could rule out the device. I had not
> ascertained with it was related to this database or others, if every database
> exhibited this problem then re-installing SQL Server may have to be one of
> the option!!
> John
> "Steve Ricketts" wrote:
> > Yes, I was backing up to a disk. I tried removing the file and doing the
> > query but neither worked. So I just uninstalled everything that had to do
> > with SQL Server 2005 Express and reinstalled. The backup is working now,
> > but what a way to fix it!!
> >
> > Thanks for all your suggestions, very much appreciated.
> >
> > Steve
> >
> >
> > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> > news:E74A68D4-51AE-46F9-90EE-B0A3AE04C48C@.microsoft.com...
> > > Hi Steve
> > >
> > > What is in the backup destination? If the backup is to disc and there is a
> > > file specified, try removing it and adding a different one.
> > >
> > > You could also try a backup command in a query window such as
> > >
> > > BACKUP DATABASE [DBNAME] TO DISK = N'C:\MSSQL\BACKUP\DBNAME.bak'
> > > WITH NOFORMAT, NOINIT, NAME = N'DBNAME-Full Database Backup', SKIP,
> > > NOREWIND, NOUNLOAD, STATS = 10
> > > GO
> > >
> > > You would need to put in the correct details for you database etc..
> > >
> > > John
> > >
> > >
> > > "Steve Ricketts" wrote:
> > >
> > >> Just a standard backup to the default location. In fact all I did is
> > >> right
> > >> click the database, Tasks, Back Up, and clicked Ok.
> > >>
> > >> As I said, I've tried to get the script by using the "Script action to
> > >> new
> > >> query, file, clipboard, etc., but it fails before creating the script.
> > >> I'm
> > >> using the "Script" pull-down at the top of SSMS's Backup Database dialog
> > >> page. This is the only way I know to get the script for the task. If
> > >> there
> > >> is another way, please explain and I'll give that a go and post it here.
> > >>
> > >> The exact error message is:
> > >>
> > >> Backup failed for Server 'xxx.xxx.xxx.xxx'.
> > >> (Microsoftt.SqlServer.Express.Smo)
> > >> Additional Information:
> > >> Set property Devices to accomplish this action.
> > >> (Microsoftt.SqlServer.Express.Smo)
> > >>
> > >> Thanks for the reply,
> > >>
> > >> Steve
> > >>
> > >>
> > >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> > >> news:6E760A54-E11D-4C3D-A759-57652863FF87@.microsoft.com...
> > >> > Hi Steve
> > >> >
> > >> > You don't say where you are trying to backup to?
> > >> >
> > >> > SSMS has the option to show you the SQL Statement that it would
> > >> > execute.
> > >> > Try
> > >> > copying that to the query window and running it. If that fails you
> > >> > could
> > >> > post
> > >> > the statement and the exact error message.
> > >> >
> > >> > John
> > >> >
> > >> > "Steve Ricketts" wrote:
> > >> >
> > >> >> I am getting error "Set property devices to accomplish this action"
> > >> >> when
> > >> >> I
> > >> >> try to do a full (or differential) backup on SQL Server 2005 Express
> > >> >> though
> > >> >> the SQL Server Management Studio. I'm using the backup defaults in
> > >> >> the
> > >> >> GUI
> > >> >> and was able to back the database up a couple of days ago without any
> > >> >> problem. Today (second time) it just comes up with this error and I
> > >> >> can't
> > >> >> find anything on the web or in Microsoft's site that talks about what
> > >> >> it
> > >> >> might be.
> > >> >>
> > >> >> I've tried to look at the script by using the "Script action to new
> > >> >> query,
> > >> >> file, clipboard, etc., but it fails before it writes anything to
> > >> >> either
> > >> >> destination. I've rebooted the server and cussed at it a great deal
> > >> >> but
> > >> >> that didn't help either.
> > >> >>
> > >> >> Any direction you can provide would be greatly appreciated.
> > >> >>
> > >> >> Thank you,
> > >> >>
> > >> >> Steve
> > >> >>
> > >> >>
> > >> >>
> > >>
> > >>
> > >>
> >
> >
> >|||Hi Steve
My guess is that something is either changing the file attributes or
permissions. Do you run a backup of the file system, or does your AV software
do something to these?
I guess you could get around this by having date specific filenames, but
then you would need to clear up.
John
"SteveR" wrote:
> Well, very odd indeed! After the reinstall, the backup worked for a couple
> of days and then stopped today with the same error!
> I tried your suggestions and both worked without an error. The script
> backed up the database and changing the name of the backup also worked. So,
> does that give you a good clue?... I hope! ;-)
> Steve
>
> "John Bell" wrote:
> > Hi Steve
> >
> > What error message did the manual backup return? If this was the same as
> > SSMS then it would rule SSMS out. If the disc file was a different one (and
> > premissions had been ruled out) then you could rule out the device. I had not
> > ascertained with it was related to this database or others, if every database
> > exhibited this problem then re-installing SQL Server may have to be one of
> > the option!!
> >
> > John
> >
> > "Steve Ricketts" wrote:
> >
> > > Yes, I was backing up to a disk. I tried removing the file and doing the
> > > query but neither worked. So I just uninstalled everything that had to do
> > > with SQL Server 2005 Express and reinstalled. The backup is working now,
> > > but what a way to fix it!!
> > >
> > > Thanks for all your suggestions, very much appreciated.
> > >
> > > Steve
> > >
> > >
> > > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> > > news:E74A68D4-51AE-46F9-90EE-B0A3AE04C48C@.microsoft.com...
> > > > Hi Steve
> > > >
> > > > What is in the backup destination? If the backup is to disc and there is a
> > > > file specified, try removing it and adding a different one.
> > > >
> > > > You could also try a backup command in a query window such as
> > > >
> > > > BACKUP DATABASE [DBNAME] TO DISK = N'C:\MSSQL\BACKUP\DBNAME.bak'
> > > > WITH NOFORMAT, NOINIT, NAME = N'DBNAME-Full Database Backup', SKIP,
> > > > NOREWIND, NOUNLOAD, STATS = 10
> > > > GO
> > > >
> > > > You would need to put in the correct details for you database etc..
> > > >
> > > > John
> > > >
> > > >
> > > > "Steve Ricketts" wrote:
> > > >
> > > >> Just a standard backup to the default location. In fact all I did is
> > > >> right
> > > >> click the database, Tasks, Back Up, and clicked Ok.
> > > >>
> > > >> As I said, I've tried to get the script by using the "Script action to
> > > >> new
> > > >> query, file, clipboard, etc., but it fails before creating the script.
> > > >> I'm
> > > >> using the "Script" pull-down at the top of SSMS's Backup Database dialog
> > > >> page. This is the only way I know to get the script for the task. If
> > > >> there
> > > >> is another way, please explain and I'll give that a go and post it here.
> > > >>
> > > >> The exact error message is:
> > > >>
> > > >> Backup failed for Server 'xxx.xxx.xxx.xxx'.
> > > >> (Microsoftt.SqlServer.Express.Smo)
> > > >> Additional Information:
> > > >> Set property Devices to accomplish this action.
> > > >> (Microsoftt.SqlServer.Express.Smo)
> > > >>
> > > >> Thanks for the reply,
> > > >>
> > > >> Steve
> > > >>
> > > >>
> > > >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> > > >> news:6E760A54-E11D-4C3D-A759-57652863FF87@.microsoft.com...
> > > >> > Hi Steve
> > > >> >
> > > >> > You don't say where you are trying to backup to?
> > > >> >
> > > >> > SSMS has the option to show you the SQL Statement that it would
> > > >> > execute.
> > > >> > Try
> > > >> > copying that to the query window and running it. If that fails you
> > > >> > could
> > > >> > post
> > > >> > the statement and the exact error message.
> > > >> >
> > > >> > John
> > > >> >
> > > >> > "Steve Ricketts" wrote:
> > > >> >
> > > >> >> I am getting error "Set property devices to accomplish this action"
> > > >> >> when
> > > >> >> I
> > > >> >> try to do a full (or differential) backup on SQL Server 2005 Express
> > > >> >> though
> > > >> >> the SQL Server Management Studio. I'm using the backup defaults in
> > > >> >> the
> > > >> >> GUI
> > > >> >> and was able to back the database up a couple of days ago without any
> > > >> >> problem. Today (second time) it just comes up with this error and I
> > > >> >> can't
> > > >> >> find anything on the web or in Microsoft's site that talks about what
> > > >> >> it
> > > >> >> might be.
> > > >> >>
> > > >> >> I've tried to look at the script by using the "Script action to new
> > > >> >> query,
> > > >> >> file, clipboard, etc., but it fails before it writes anything to
> > > >> >> either
> > > >> >> destination. I've rebooted the server and cussed at it a great deal
> > > >> >> but
> > > >> >> that didn't help either.
> > > >> >>
> > > >> >> Any direction you can provide would be greatly appreciated.
> > > >> >>
> > > >> >> Thank you,
> > > >> >>
> > > >> >> Steve
> > > >> >>
> > > >> >>
> > > >> >>
> > > >>
> > > >>
> > > >>
> > >
> > >
> > >|||I just leave everything as is when doing the backup, Files and Filegroups is
not selected.
Actually, permissions is a good thought. I looked at the SQL backup
directory and it was Read Only. So, I unchecked read only and gave everyone
full permissions on that directory. No change, still an error. So I gave
full permissions to everyone and took off the read only on the entire SQL
directory, still an error. So I checked the permissions again and Read Only
was checked again. I can't get it off. I wonder if that has anything to do
with the problem... not to mention how to get it off.
Steve
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:FD57916B-7478-4EEF-B12B-11A13277B071@.microsoft.com...
> Hi Steve
> My guess is that something is either changing the file attributes or
> permissions. Do you run a backup of the file system, or does your AV
> software
> do something to these?
> I guess you could get around this by having date specific filenames, but
> then you would need to clear up.
> John
> "SteveR" wrote:
>> Well, very odd indeed! After the reinstall, the backup worked for a
>> couple
>> of days and then stopped today with the same error!
>> I tried your suggestions and both worked without an error. The script
>> backed up the database and changing the name of the backup also worked.
>> So,
>> does that give you a good clue?... I hope! ;-)
>> Steve
>>
>> "John Bell" wrote:
>> > Hi Steve
>> >
>> > What error message did the manual backup return? If this was the same
>> > as
>> > SSMS then it would rule SSMS out. If the disc file was a different one
>> > (and
>> > premissions had been ruled out) then you could rule out the device. I
>> > had not
>> > ascertained with it was related to this database or others, if every
>> > database
>> > exhibited this problem then re-installing SQL Server may have to be one
>> > of
>> > the option!!
>> >
>> > John
>> >
>> > "Steve Ricketts" wrote:
>> >
>> > > Yes, I was backing up to a disk. I tried removing the file and doing
>> > > the
>> > > query but neither worked. So I just uninstalled everything that had
>> > > to do
>> > > with SQL Server 2005 Express and reinstalled. The backup is working
>> > > now,
>> > > but what a way to fix it!!
>> > >
>> > > Thanks for all your suggestions, very much appreciated.
>> > >
>> > > Steve
>> > >
>> > >
>> > > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> > > news:E74A68D4-51AE-46F9-90EE-B0A3AE04C48C@.microsoft.com...
>> > > > Hi Steve
>> > > >
>> > > > What is in the backup destination? If the backup is to disc and
>> > > > there is a
>> > > > file specified, try removing it and adding a different one.
>> > > >
>> > > > You could also try a backup command in a query window such as
>> > > >
>> > > > BACKUP DATABASE [DBNAME] TO DISK = N'C:\MSSQL\BACKUP\DBNAME.bak'
>> > > > WITH NOFORMAT, NOINIT, NAME = N'DBNAME-Full Database Backup',
>> > > > SKIP,
>> > > > NOREWIND, NOUNLOAD, STATS = 10
>> > > > GO
>> > > >
>> > > > You would need to put in the correct details for you database etc..
>> > > >
>> > > > John
>> > > >
>> > > >
>> > > > "Steve Ricketts" wrote:
>> > > >
>> > > >> Just a standard backup to the default location. In fact all I did
>> > > >> is
>> > > >> right
>> > > >> click the database, Tasks, Back Up, and clicked Ok.
>> > > >>
>> > > >> As I said, I've tried to get the script by using the "Script
>> > > >> action to
>> > > >> new
>> > > >> query, file, clipboard, etc., but it fails before creating the
>> > > >> script.
>> > > >> I'm
>> > > >> using the "Script" pull-down at the top of SSMS's Backup Database
>> > > >> dialog
>> > > >> page. This is the only way I know to get the script for the task.
>> > > >> If
>> > > >> there
>> > > >> is another way, please explain and I'll give that a go and post it
>> > > >> here.
>> > > >>
>> > > >> The exact error message is:
>> > > >>
>> > > >> Backup failed for Server 'xxx.xxx.xxx.xxx'.
>> > > >> (Microsoftt.SqlServer.Express.Smo)
>> > > >> Additional Information:
>> > > >> Set property Devices to accomplish this action.
>> > > >> (Microsoftt.SqlServer.Express.Smo)
>> > > >>
>> > > >> Thanks for the reply,
>> > > >>
>> > > >> Steve
>> > > >>
>> > > >>
>> > > >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> > > >> news:6E760A54-E11D-4C3D-A759-57652863FF87@.microsoft.com...
>> > > >> > Hi Steve
>> > > >> >
>> > > >> > You don't say where you are trying to backup to?
>> > > >> >
>> > > >> > SSMS has the option to show you the SQL Statement that it would
>> > > >> > execute.
>> > > >> > Try
>> > > >> > copying that to the query window and running it. If that fails
>> > > >> > you
>> > > >> > could
>> > > >> > post
>> > > >> > the statement and the exact error message.
>> > > >> >
>> > > >> > John
>> > > >> >
>> > > >> > "Steve Ricketts" wrote:
>> > > >> >
>> > > >> >> I am getting error "Set property devices to accomplish this
>> > > >> >> action"
>> > > >> >> when
>> > > >> >> I
>> > > >> >> try to do a full (or differential) backup on SQL Server 2005
>> > > >> >> Express
>> > > >> >> though
>> > > >> >> the SQL Server Management Studio. I'm using the backup
>> > > >> >> defaults in
>> > > >> >> the
>> > > >> >> GUI
>> > > >> >> and was able to back the database up a couple of days ago
>> > > >> >> without any
>> > > >> >> problem. Today (second time) it just comes up with this error
>> > > >> >> and I
>> > > >> >> can't
>> > > >> >> find anything on the web or in Microsoft's site that talks
>> > > >> >> about what
>> > > >> >> it
>> > > >> >> might be.
>> > > >> >>
>> > > >> >> I've tried to look at the script by using the "Script action to
>> > > >> >> new
>> > > >> >> query,
>> > > >> >> file, clipboard, etc., but it fails before it writes anything
>> > > >> >> to
>> > > >> >> either
>> > > >> >> destination. I've rebooted the server and cussed at it a great
>> > > >> >> deal
>> > > >> >> but
>> > > >> >> that didn't help either.
>> > > >> >>
>> > > >> >> Any direction you can provide would be greatly appreciated.
>> > > >> >>
>> > > >> >> Thank you,
>> > > >> >>
>> > > >> >> Steve
>> > > >> >>
>> > > >> >>
>> > > >> >>
>> > > >>
>> > > >>
>> > > >>
>> > >
>> > >
>> > >|||Hi Steve
The readonly attribute seems to do that, (although I think only on XP) if
you have granted full control to everyone I think it should be ok. If you can
create a different backup file in the same directory you should be ok at that
point in time. Have you made sure that any other OS backups are not occuring
around that time, and have you made sure that any AV actitity is not
occurring (you may want to test these by excluding the directory).
John
"Steve Ricketts" wrote:
> I just leave everything as is when doing the backup, Files and Filegroups is
> not selected.
> Actually, permissions is a good thought. I looked at the SQL backup
> directory and it was Read Only. So, I unchecked read only and gave everyone
> full permissions on that directory. No change, still an error. So I gave
> full permissions to everyone and took off the read only on the entire SQL
> directory, still an error. So I checked the permissions again and Read Only
> was checked again. I can't get it off. I wonder if that has anything to do
> with the problem... not to mention how to get it off.
> Steve
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:FD57916B-7478-4EEF-B12B-11A13277B071@.microsoft.com...
> > Hi Steve
> >
> > My guess is that something is either changing the file attributes or
> > permissions. Do you run a backup of the file system, or does your AV
> > software
> > do something to these?
> >
> > I guess you could get around this by having date specific filenames, but
> > then you would need to clear up.
> >
> > John
> >
> > "SteveR" wrote:
> >
> >> Well, very odd indeed! After the reinstall, the backup worked for a
> >> couple
> >> of days and then stopped today with the same error!
> >>
> >> I tried your suggestions and both worked without an error. The script
> >> backed up the database and changing the name of the backup also worked.
> >> So,
> >> does that give you a good clue?... I hope! ;-)
> >>
> >> Steve
> >>
> >>
> >> "John Bell" wrote:
> >>
> >> > Hi Steve
> >> >
> >> > What error message did the manual backup return? If this was the same
> >> > as
> >> > SSMS then it would rule SSMS out. If the disc file was a different one
> >> > (and
> >> > premissions had been ruled out) then you could rule out the device. I
> >> > had not
> >> > ascertained with it was related to this database or others, if every
> >> > database
> >> > exhibited this problem then re-installing SQL Server may have to be one
> >> > of
> >> > the option!!
> >> >
> >> > John
> >> >
> >> > "Steve Ricketts" wrote:
> >> >
> >> > > Yes, I was backing up to a disk. I tried removing the file and doing
> >> > > the
> >> > > query but neither worked. So I just uninstalled everything that had
> >> > > to do
> >> > > with SQL Server 2005 Express and reinstalled. The backup is working
> >> > > now,
> >> > > but what a way to fix it!!
> >> > >
> >> > > Thanks for all your suggestions, very much appreciated.
> >> > >
> >> > > Steve
> >> > >
> >> > >
> >> > > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> >> > > news:E74A68D4-51AE-46F9-90EE-B0A3AE04C48C@.microsoft.com...
> >> > > > Hi Steve
> >> > > >
> >> > > > What is in the backup destination? If the backup is to disc and
> >> > > > there is a
> >> > > > file specified, try removing it and adding a different one.
> >> > > >
> >> > > > You could also try a backup command in a query window such as
> >> > > >
> >> > > > BACKUP DATABASE [DBNAME] TO DISK = N'C:\MSSQL\BACKUP\DBNAME.bak'
> >> > > > WITH NOFORMAT, NOINIT, NAME = N'DBNAME-Full Database Backup',
> >> > > > SKIP,
> >> > > > NOREWIND, NOUNLOAD, STATS = 10
> >> > > > GO
> >> > > >
> >> > > > You would need to put in the correct details for you database etc..
> >> > > >
> >> > > > John
> >> > > >
> >> > > >
> >> > > > "Steve Ricketts" wrote:
> >> > > >
> >> > > >> Just a standard backup to the default location. In fact all I did
> >> > > >> is
> >> > > >> right
> >> > > >> click the database, Tasks, Back Up, and clicked Ok.
> >> > > >>
> >> > > >> As I said, I've tried to get the script by using the "Script
> >> > > >> action to
> >> > > >> new
> >> > > >> query, file, clipboard, etc., but it fails before creating the
> >> > > >> script.
> >> > > >> I'm
> >> > > >> using the "Script" pull-down at the top of SSMS's Backup Database
> >> > > >> dialog
> >> > > >> page. This is the only way I know to get the script for the task.
> >> > > >> If
> >> > > >> there
> >> > > >> is another way, please explain and I'll give that a go and post it
> >> > > >> here.
> >> > > >>
> >> > > >> The exact error message is:
> >> > > >>
> >> > > >> Backup failed for Server 'xxx.xxx.xxx.xxx'.
> >> > > >> (Microsoftt.SqlServer.Express.Smo)
> >> > > >> Additional Information:
> >> > > >> Set property Devices to accomplish this action.
> >> > > >> (Microsoftt.SqlServer.Express.Smo)
> >> > > >>
> >> > > >> Thanks for the reply,
> >> > > >>
> >> > > >> Steve
> >> > > >>
> >> > > >>
> >> > > >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> >> > > >> news:6E760A54-E11D-4C3D-A759-57652863FF87@.microsoft.com...
> >> > > >> > Hi Steve
> >> > > >> >
> >> > > >> > You don't say where you are trying to backup to?
> >> > > >> >
> >> > > >> > SSMS has the option to show you the SQL Statement that it would
> >> > > >> > execute.
> >> > > >> > Try
> >> > > >> > copying that to the query window and running it. If that fails
> >> > > >> > you
> >> > > >> > could
> >> > > >> > post
> >> > > >> > the statement and the exact error message.
> >> > > >> >
> >> > > >> > John
> >> > > >> >
> >> > > >> > "Steve Ricketts" wrote:
> >> > > >> >
> >> > > >> >> I am getting error "Set property devices to accomplish this
> >> > > >> >> action"
> >> > > >> >> when
> >> > > >> >> I
> >> > > >> >> try to do a full (or differential) backup on SQL Server 2005
> >> > > >> >> Express
> >> > > >> >> though
> >> > > >> >> the SQL Server Management Studio. I'm using the backup
> >> > > >> >> defaults in
> >> > > >> >> the
> >> > > >> >> GUI
> >> > > >> >> and was able to back the database up a couple of days ago
> >> > > >> >> without any
> >> > > >> >> problem. Today (second time) it just comes up with this error
> >> > > >> >> and I
> >> > > >> >> can't
> >> > > >> >> find anything on the web or in Microsoft's site that talks
> >> > > >> >> about what
> >> > > >> >> it
> >> > > >> >> might be.
> >> > > >> >>
> >> > > >> >> I've tried to look at the script by using the "Script action to
> >> > > >> >> new
> >> > > >> >> query,
> >> > > >> >> file, clipboard, etc., but it fails before it writes anything
> >> > > >> >> to
> >> > > >> >> either
> >> > > >> >> destination. I've rebooted the server and cussed at it a great
> >> > > >> >> deal
> >> > > >> >> but
> >> > > >> >> that didn't help either.
> >> > > >> >>
> >> > > >> >> Any direction you can provide would be greatly appreciated.
> >> > > >> >>
> >> > > >> >> Thank you,
> >> > > >> >>
> >> > > >> >> Steve
> >> > > >> >>
> >> > > >> >>
> >> > > >> >>
> >> > > >>
> >> > > >>
> >> > > >>
> >> > >
> >> > >
> >> > >
>
>|||No other backups are scheduled or running and there isn't an AV program on
this server yet.
If I specify a file name in the Destination field of the backup dialog, it
creates a backup fine. If I remove the file name the backup fails with the
previous error. I can even specify a file in the default backup directory
and it works so it would appear the permissions are ok. I have no idea what
the differences could be.
Steve
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:E154E9B7-F1A2-406C-86B7-F0009C1BA640@.microsoft.com...
> Hi Steve
> The readonly attribute seems to do that, (although I think only on XP) if
> you have granted full control to everyone I think it should be ok. If you
> can
> create a different backup file in the same directory you should be ok at
> that
> point in time. Have you made sure that any other OS backups are not
> occuring
> around that time, and have you made sure that any AV actitity is not
> occurring (you may want to test these by excluding the directory).
> John
> "Steve Ricketts" wrote:
>> I just leave everything as is when doing the backup, Files and Filegroups
>> is
>> not selected.
>> Actually, permissions is a good thought. I looked at the SQL backup
>> directory and it was Read Only. So, I unchecked read only and gave
>> everyone
>> full permissions on that directory. No change, still an error. So I
>> gave
>> full permissions to everyone and took off the read only on the entire SQL
>> directory, still an error. So I checked the permissions again and Read
>> Only
>> was checked again. I can't get it off. I wonder if that has anything to
>> do
>> with the problem... not to mention how to get it off.
>> Steve
>>
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:FD57916B-7478-4EEF-B12B-11A13277B071@.microsoft.com...
>> > Hi Steve
>> >
>> > My guess is that something is either changing the file attributes or
>> > permissions. Do you run a backup of the file system, or does your AV
>> > software
>> > do something to these?
>> >
>> > I guess you could get around this by having date specific filenames,
>> > but
>> > then you would need to clear up.
>> >
>> > John
>> >
>> > "SteveR" wrote:
>> >
>> >> Well, very odd indeed! After the reinstall, the backup worked for a
>> >> couple
>> >> of days and then stopped today with the same error!
>> >>
>> >> I tried your suggestions and both worked without an error. The script
>> >> backed up the database and changing the name of the backup also
>> >> worked.
>> >> So,
>> >> does that give you a good clue?... I hope! ;-)
>> >>
>> >> Steve
>> >>
>> >>
>> >> "John Bell" wrote:
>> >>
>> >> > Hi Steve
>> >> >
>> >> > What error message did the manual backup return? If this was the
>> >> > same
>> >> > as
>> >> > SSMS then it would rule SSMS out. If the disc file was a different
>> >> > one
>> >> > (and
>> >> > premissions had been ruled out) then you could rule out the device.
>> >> > I
>> >> > had not
>> >> > ascertained with it was related to this database or others, if every
>> >> > database
>> >> > exhibited this problem then re-installing SQL Server may have to be
>> >> > one
>> >> > of
>> >> > the option!!
>> >> >
>> >> > John
>> >> >
>> >> > "Steve Ricketts" wrote:
>> >> >
>> >> > > Yes, I was backing up to a disk. I tried removing the file and
>> >> > > doing
>> >> > > the
>> >> > > query but neither worked. So I just uninstalled everything that
>> >> > > had
>> >> > > to do
>> >> > > with SQL Server 2005 Express and reinstalled. The backup is
>> >> > > working
>> >> > > now,
>> >> > > but what a way to fix it!!
>> >> > >
>> >> > > Thanks for all your suggestions, very much appreciated.
>> >> > >
>> >> > > Steve
>> >> > >
>> >> > >
>> >> > > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> >> > > news:E74A68D4-51AE-46F9-90EE-B0A3AE04C48C@.microsoft.com...
>> >> > > > Hi Steve
>> >> > > >
>> >> > > > What is in the backup destination? If the backup is to disc and
>> >> > > > there is a
>> >> > > > file specified, try removing it and adding a different one.
>> >> > > >
>> >> > > > You could also try a backup command in a query window such as
>> >> > > >
>> >> > > > BACKUP DATABASE [DBNAME] TO DISK =>> >> > > > N'C:\MSSQL\BACKUP\DBNAME.bak'
>> >> > > > WITH NOFORMAT, NOINIT, NAME = N'DBNAME-Full Database Backup',
>> >> > > > SKIP,
>> >> > > > NOREWIND, NOUNLOAD, STATS = 10
>> >> > > > GO
>> >> > > >
>> >> > > > You would need to put in the correct details for you database
>> >> > > > etc..
>> >> > > >
>> >> > > > John
>> >> > > >
>> >> > > >
>> >> > > > "Steve Ricketts" wrote:
>> >> > > >
>> >> > > >> Just a standard backup to the default location. In fact all I
>> >> > > >> did
>> >> > > >> is
>> >> > > >> right
>> >> > > >> click the database, Tasks, Back Up, and clicked Ok.
>> >> > > >>
>> >> > > >> As I said, I've tried to get the script by using the "Script
>> >> > > >> action to
>> >> > > >> new
>> >> > > >> query, file, clipboard, etc., but it fails before creating the
>> >> > > >> script.
>> >> > > >> I'm
>> >> > > >> using the "Script" pull-down at the top of SSMS's Backup
>> >> > > >> Database
>> >> > > >> dialog
>> >> > > >> page. This is the only way I know to get the script for the
>> >> > > >> task.
>> >> > > >> If
>> >> > > >> there
>> >> > > >> is another way, please explain and I'll give that a go and post
>> >> > > >> it
>> >> > > >> here.
>> >> > > >>
>> >> > > >> The exact error message is:
>> >> > > >>
>> >> > > >> Backup failed for Server 'xxx.xxx.xxx.xxx'.
>> >> > > >> (Microsoftt.SqlServer.Express.Smo)
>> >> > > >> Additional Information:
>> >> > > >> Set property Devices to accomplish this action.
>> >> > > >> (Microsoftt.SqlServer.Express.Smo)
>> >> > > >>
>> >> > > >> Thanks for the reply,
>> >> > > >>
>> >> > > >> Steve
>> >> > > >>
>> >> > > >>
>> >> > > >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> >> > > >> news:6E760A54-E11D-4C3D-A759-57652863FF87@.microsoft.com...
>> >> > > >> > Hi Steve
>> >> > > >> >
>> >> > > >> > You don't say where you are trying to backup to?
>> >> > > >> >
>> >> > > >> > SSMS has the option to show you the SQL Statement that it
>> >> > > >> > would
>> >> > > >> > execute.
>> >> > > >> > Try
>> >> > > >> > copying that to the query window and running it. If that
>> >> > > >> > fails
>> >> > > >> > you
>> >> > > >> > could
>> >> > > >> > post
>> >> > > >> > the statement and the exact error message.
>> >> > > >> >
>> >> > > >> > John
>> >> > > >> >
>> >> > > >> > "Steve Ricketts" wrote:
>> >> > > >> >
>> >> > > >> >> I am getting error "Set property devices to accomplish this
>> >> > > >> >> action"
>> >> > > >> >> when
>> >> > > >> >> I
>> >> > > >> >> try to do a full (or differential) backup on SQL Server 2005
>> >> > > >> >> Express
>> >> > > >> >> though
>> >> > > >> >> the SQL Server Management Studio. I'm using the backup
>> >> > > >> >> defaults in
>> >> > > >> >> the
>> >> > > >> >> GUI
>> >> > > >> >> and was able to back the database up a couple of days ago
>> >> > > >> >> without any
>> >> > > >> >> problem. Today (second time) it just comes up with this
>> >> > > >> >> error
>> >> > > >> >> and I
>> >> > > >> >> can't
>> >> > > >> >> find anything on the web or in Microsoft's site that talks
>> >> > > >> >> about what
>> >> > > >> >> it
>> >> > > >> >> might be.
>> >> > > >> >>
>> >> > > >> >> I've tried to look at the script by using the "Script action
>> >> > > >> >> to
>> >> > > >> >> new
>> >> > > >> >> query,
>> >> > > >> >> file, clipboard, etc., but it fails before it writes
>> >> > > >> >> anything
>> >> > > >> >> to
>> >> > > >> >> either
>> >> > > >> >> destination. I've rebooted the server and cussed at it a
>> >> > > >> >> great
>> >> > > >> >> deal
>> >> > > >> >> but
>> >> > > >> >> that didn't help either.
>> >> > > >> >>
>> >> > > >> >> Any direction you can provide would be greatly appreciated.
>> >> > > >> >>
>> >> > > >> >> Thank you,
>> >> > > >> >>
>> >> > > >> >> Steve
>> >> > > >> >>
>> >> > > >> >>
>> >> > > >> >>
>> >> > > >>
>> >> > > >>
>> >> > > >>
>> >> > >
>> >> > >
>> >> > >
>>|||Hi Steve
When you are backing up to disc, you need to specify the file! Are you
saying that when you take the default file name you get the error and when
you don't it is ok?
John
"Steve Ricketts" wrote:
> No other backups are scheduled or running and there isn't an AV program on
> this server yet.
> If I specify a file name in the Destination field of the backup dialog, it
> creates a backup fine. If I remove the file name the backup fails with the
> previous error. I can even specify a file in the default backup directory
> and it works so it would appear the permissions are ok. I have no idea what
> the differences could be.
> Steve
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:E154E9B7-F1A2-406C-86B7-F0009C1BA640@.microsoft.com...
> > Hi Steve
> >
> > The readonly attribute seems to do that, (although I think only on XP) if
> > you have granted full control to everyone I think it should be ok. If you
> > can
> > create a different backup file in the same directory you should be ok at
> > that
> > point in time. Have you made sure that any other OS backups are not
> > occuring
> > around that time, and have you made sure that any AV actitity is not
> > occurring (you may want to test these by excluding the directory).
> >
> > John
> >
> > "Steve Ricketts" wrote:
> >
> >> I just leave everything as is when doing the backup, Files and Filegroups
> >> is
> >> not selected.
> >>
> >> Actually, permissions is a good thought. I looked at the SQL backup
> >> directory and it was Read Only. So, I unchecked read only and gave
> >> everyone
> >> full permissions on that directory. No change, still an error. So I
> >> gave
> >> full permissions to everyone and took off the read only on the entire SQL
> >> directory, still an error. So I checked the permissions again and Read
> >> Only
> >> was checked again. I can't get it off. I wonder if that has anything to
> >> do
> >> with the problem... not to mention how to get it off.
> >>
> >> Steve
> >>
> >>
> >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> >> news:FD57916B-7478-4EEF-B12B-11A13277B071@.microsoft.com...
> >> > Hi Steve
> >> >
> >> > My guess is that something is either changing the file attributes or
> >> > permissions. Do you run a backup of the file system, or does your AV
> >> > software
> >> > do something to these?
> >> >
> >> > I guess you could get around this by having date specific filenames,
> >> > but
> >> > then you would need to clear up.
> >> >
> >> > John
> >> >
> >> > "SteveR" wrote:
> >> >
> >> >> Well, very odd indeed! After the reinstall, the backup worked for a
> >> >> couple
> >> >> of days and then stopped today with the same error!
> >> >>
> >> >> I tried your suggestions and both worked without an error. The script
> >> >> backed up the database and changing the name of the backup also
> >> >> worked.
> >> >> So,
> >> >> does that give you a good clue?... I hope! ;-)
> >> >>
> >> >> Steve
> >> >>
> >> >>
> >> >> "John Bell" wrote:
> >> >>
> >> >> > Hi Steve
> >> >> >
> >> >> > What error message did the manual backup return? If this was the
> >> >> > same
> >> >> > as
> >> >> > SSMS then it would rule SSMS out. If the disc file was a different
> >> >> > one
> >> >> > (and
> >> >> > premissions had been ruled out) then you could rule out the device.
> >> >> > I
> >> >> > had not
> >> >> > ascertained with it was related to this database or others, if every
> >> >> > database
> >> >> > exhibited this problem then re-installing SQL Server may have to be
> >> >> > one
> >> >> > of
> >> >> > the option!!
> >> >> >
> >> >> > John
> >> >> >
> >> >> > "Steve Ricketts" wrote:
> >> >> >
> >> >> > > Yes, I was backing up to a disk. I tried removing the file and
> >> >> > > doing
> >> >> > > the
> >> >> > > query but neither worked. So I just uninstalled everything that
> >> >> > > had
> >> >> > > to do
> >> >> > > with SQL Server 2005 Express and reinstalled. The backup is
> >> >> > > working
> >> >> > > now,
> >> >> > > but what a way to fix it!!
> >> >> > >
> >> >> > > Thanks for all your suggestions, very much appreciated.
> >> >> > >
> >> >> > > Steve
> >> >> > >
> >> >> > >
> >> >> > > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> >> >> > > news:E74A68D4-51AE-46F9-90EE-B0A3AE04C48C@.microsoft.com...
> >> >> > > > Hi Steve
> >> >> > > >
> >> >> > > > What is in the backup destination? If the backup is to disc and
> >> >> > > > there is a
> >> >> > > > file specified, try removing it and adding a different one.
> >> >> > > >
> >> >> > > > You could also try a backup command in a query window such as
> >> >> > > >
> >> >> > > > BACKUP DATABASE [DBNAME] TO DISK => >> >> > > > N'C:\MSSQL\BACKUP\DBNAME.bak'
> >> >> > > > WITH NOFORMAT, NOINIT, NAME = N'DBNAME-Full Database Backup',
> >> >> > > > SKIP,
> >> >> > > > NOREWIND, NOUNLOAD, STATS = 10
> >> >> > > > GO
> >> >> > > >
> >> >> > > > You would need to put in the correct details for you database
> >> >> > > > etc..
> >> >> > > >
> >> >> > > > John
> >> >> > > >
> >> >> > > >
> >> >> > > > "Steve Ricketts" wrote:
> >> >> > > >
> >> >> > > >> Just a standard backup to the default location. In fact all I
> >> >> > > >> did
> >> >> > > >> is
> >> >> > > >> right
> >> >> > > >> click the database, Tasks, Back Up, and clicked Ok.
> >> >> > > >>
> >> >> > > >> As I said, I've tried to get the script by using the "Script
> >> >> > > >> action to
> >> >> > > >> new
> >> >> > > >> query, file, clipboard, etc., but it fails before creating the
> >> >> > > >> script.
> >> >> > > >> I'm
> >> >> > > >> using the "Script" pull-down at the top of SSMS's Backup
> >> >> > > >> Database
> >> >> > > >> dialog
> >> >> > > >> page. This is the only way I know to get the script for the
> >> >> > > >> task.
> >> >> > > >> If
> >> >> > > >> there
> >> >> > > >> is another way, please explain and I'll give that a go and post
> >> >> > > >> it
> >> >> > > >> here.
> >> >> > > >>
> >> >> > > >> The exact error message is:
> >> >> > > >>
> >> >> > > >> Backup failed for Server 'xxx.xxx.xxx.xxx'.
> >> >> > > >> (Microsoftt.SqlServer.Express.Smo)
> >> >> > > >> Additional Information:
> >> >> > > >> Set property Devices to accomplish this action.
> >> >> > > >> (Microsoftt.SqlServer.Express.Smo)
> >> >> > > >>
> >> >> > > >> Thanks for the reply,
> >> >> > > >>
> >> >> > > >> Steve
> >> >> > > >>
> >> >> > > >>
> >> >> > > >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> >> >> > > >> news:6E760A54-E11D-4C3D-A759-57652863FF87@.microsoft.com...
> >> >> > > >> > Hi Steve
> >> >> > > >> >
> >> >> > > >> > You don't say where you are trying to backup to?
> >> >> > > >> >
> >> >> > > >> > SSMS has the option to show you the SQL Statement that it
> >> >> > > >> > would
> >> >> > > >> > execute.
> >> >> > > >> > Try
> >> >> > > >> > copying that to the query window and running it. If that
> >> >> > > >> > fails
> >> >> > > >> > you
> >> >> > > >> > could
> >> >> > > >> > post
> >> >> > > >> > the statement and the exact error message.
> >> >> > > >> >
> >> >> > > >> > John
> >> >> > > >> >
> >> >> > > >> > "Steve Ricketts" wrote:
> >> >> > > >> >
> >> >> > > >> >> I am getting error "Set property devices to accomplish this
> >> >> > > >> >> action"
> >> >> > > >> >> when
> >> >> > > >> >> I
> >> >> > > >> >> try to do a full (or differential) backup on SQL Server 2005
> >> >> > > >> >> Express
> >> >> > > >> >> though
> >> >> > > >> >> the SQL Server Management Studio. I'm using the backup
> >> >> > > >> >> defaults in
> >> >> > > >> >> the
> >> >> > > >> >> GUI
> >> >> > > >> >> and was able to back the database up a couple of days ago
> >> >> > > >> >> without any
> >> >> > > >> >> problem. Today (second time) it just comes up with this
> >> >> > > >> >> error
> >> >> > > >> >> and I
> >> >> > > >> >> can't
> >> >> > > >> >> find anything on the web or in Microsoft's site that talks
> >> >> > > >> >> about what
> >> >> > > >> >> it
> >> >> > > >> >> might be.
> >> >> > > >> >>
> >> >> > > >> >> I've tried to look at the script by using the "Script action
> >> >> > > >> >> to
> >> >> > > >> >> new
> >> >> > > >> >> query,
> >> >> > > >> >> file, clipboard, etc., but it fails before it writes
> >> >> > > >> >> anything
> >> >> > > >> >> to
> >> >> > > >> >> either
> >> >> > > >> >> destination. I've rebooted the server and cussed at it a
> >> >> > > >> >> great
> >> >> > > >> >> deal
> >> >> > > >> >> but
> >> >> > > >> >> that didn't help either.
> >> >> > > >> >>
> >> >> > > >> >> Any direction you can provide would be greatly appreciated.
> >> >> > > >> >>
> >> >> > > >> >> Thank you,
> >> >> > > >> >>
> >> >> > > >> >> Steve
> >> >> > > >> >>
> >> >> > > >> >>
> >> >> > > >> >>
> >> >> > > >>
> >> >> > > >>
> >> >> > > >>
> >> >> > >
> >> >> > >
> >> >> > >
> >>
> >>
> >>
>
>|||Correct. When I first entered the backup dialog, there is no file name
specified in the Destination, Backup to: field and the backup fails. I
clicked Add and referenced a backup file in the SQL default directory
(Microsoft SQL Server\MSSQL.1\MSSQL\Backup) and the backup works. If I
remove it again, it fails.
Steve
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:2DB80403-5120-42A9-9E8D-156EDF9C89D6@.microsoft.com...
> Hi Steve
> When you are backing up to disc, you need to specify the file! Are you
> saying that when you take the default file name you get the error and when
> you don't it is ok?
> John
> "Steve Ricketts" wrote:
>> No other backups are scheduled or running and there isn't an AV program
>> on
>> this server yet.
>> If I specify a file name in the Destination field of the backup dialog,
>> it
>> creates a backup fine. If I remove the file name the backup fails with
>> the
>> previous error. I can even specify a file in the default backup
>> directory
>> and it works so it would appear the permissions are ok. I have no idea
>> what
>> the differences could be.
>> Steve
>>
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:E154E9B7-F1A2-406C-86B7-F0009C1BA640@.microsoft.com...
>> > Hi Steve
>> >
>> > The readonly attribute seems to do that, (although I think only on XP)
>> > if
>> > you have granted full control to everyone I think it should be ok. If
>> > you
>> > can
>> > create a different backup file in the same directory you should be ok
>> > at
>> > that
>> > point in time. Have you made sure that any other OS backups are not
>> > occuring
>> > around that time, and have you made sure that any AV actitity is not
>> > occurring (you may want to test these by excluding the directory).
>> >
>> > John
>> >
>> > "Steve Ricketts" wrote:
>> >
>> >> I just leave everything as is when doing the backup, Files and
>> >> Filegroups
>> >> is
>> >> not selected.
>> >>
>> >> Actually, permissions is a good thought. I looked at the SQL backup
>> >> directory and it was Read Only. So, I unchecked read only and gave
>> >> everyone
>> >> full permissions on that directory. No change, still an error. So I
>> >> gave
>> >> full permissions to everyone and took off the read only on the entire
>> >> SQL
>> >> directory, still an error. So I checked the permissions again and
>> >> Read
>> >> Only
>> >> was checked again. I can't get it off. I wonder if that has anything
>> >> to
>> >> do
>> >> with the problem... not to mention how to get it off.
>> >>
>> >> Steve
>> >>
>> >>
>> >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> >> news:FD57916B-7478-4EEF-B12B-11A13277B071@.microsoft.com...
>> >> > Hi Steve
>> >> >
>> >> > My guess is that something is either changing the file attributes or
>> >> > permissions. Do you run a backup of the file system, or does your AV
>> >> > software
>> >> > do something to these?
>> >> >
>> >> > I guess you could get around this by having date specific filenames,
>> >> > but
>> >> > then you would need to clear up.
>> >> >
>> >> > John
>> >> >
>> >> > "SteveR" wrote:
>> >> >
>> >> >> Well, very odd indeed! After the reinstall, the backup worked for
>> >> >> a
>> >> >> couple
>> >> >> of days and then stopped today with the same error!
>> >> >>
>> >> >> I tried your suggestions and both worked without an error. The
>> >> >> script
>> >> >> backed up the database and changing the name of the backup also
>> >> >> worked.
>> >> >> So,
>> >> >> does that give you a good clue?... I hope! ;-)
>> >> >>
>> >> >> Steve
>> >> >>
>> >> >>
>> >> >> "John Bell" wrote:
>> >> >>
>> >> >> > Hi Steve
>> >> >> >
>> >> >> > What error message did the manual backup return? If this was the
>> >> >> > same
>> >> >> > as
>> >> >> > SSMS then it would rule SSMS out. If the disc file was a
>> >> >> > different
>> >> >> > one
>> >> >> > (and
>> >> >> > premissions had been ruled out) then you could rule out the
>> >> >> > device.
>> >> >> > I
>> >> >> > had not
>> >> >> > ascertained with it was related to this database or others, if
>> >> >> > every
>> >> >> > database
>> >> >> > exhibited this problem then re-installing SQL Server may have to
>> >> >> > be
>> >> >> > one
>> >> >> > of
>> >> >> > the option!!
>> >> >> >
>> >> >> > John
>> >> >> >
>> >> >> > "Steve Ricketts" wrote:
>> >> >> >
>> >> >> > > Yes, I was backing up to a disk. I tried removing the file and
>> >> >> > > doing
>> >> >> > > the
>> >> >> > > query but neither worked. So I just uninstalled everything
>> >> >> > > that
>> >> >> > > had
>> >> >> > > to do
>> >> >> > > with SQL Server 2005 Express and reinstalled. The backup is
>> >> >> > > working
>> >> >> > > now,
>> >> >> > > but what a way to fix it!!
>> >> >> > >
>> >> >> > > Thanks for all your suggestions, very much appreciated.
>> >> >> > >
>> >> >> > > Steve
>> >> >> > >
>> >> >> > >
>> >> >> > > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> >> >> > > news:E74A68D4-51AE-46F9-90EE-B0A3AE04C48C@.microsoft.com...
>> >> >> > > > Hi Steve
>> >> >> > > >
>> >> >> > > > What is in the backup destination? If the backup is to disc
>> >> >> > > > and
>> >> >> > > > there is a
>> >> >> > > > file specified, try removing it and adding a different one.
>> >> >> > > >
>> >> >> > > > You could also try a backup command in a query window such as
>> >> >> > > >
>> >> >> > > > BACKUP DATABASE [DBNAME] TO DISK =>> >> >> > > > N'C:\MSSQL\BACKUP\DBNAME.bak'
>> >> >> > > > WITH NOFORMAT, NOINIT, NAME = N'DBNAME-Full Database
>> >> >> > > > Backup',
>> >> >> > > > SKIP,
>> >> >> > > > NOREWIND, NOUNLOAD, STATS = 10
>> >> >> > > > GO
>> >> >> > > >
>> >> >> > > > You would need to put in the correct details for you database
>> >> >> > > > etc..
>> >> >> > > >
>> >> >> > > > John
>> >> >> > > >
>> >> >> > > >
>> >> >> > > > "Steve Ricketts" wrote:
>> >> >> > > >
>> >> >> > > >> Just a standard backup to the default location. In fact all
>> >> >> > > >> I
>> >> >> > > >> did
>> >> >> > > >> is
>> >> >> > > >> right
>> >> >> > > >> click the database, Tasks, Back Up, and clicked Ok.
>> >> >> > > >>
>> >> >> > > >> As I said, I've tried to get the script by using the "Script
>> >> >> > > >> action to
>> >> >> > > >> new
>> >> >> > > >> query, file, clipboard, etc., but it fails before creating
>> >> >> > > >> the
>> >> >> > > >> script.
>> >> >> > > >> I'm
>> >> >> > > >> using the "Script" pull-down at the top of SSMS's Backup
>> >> >> > > >> Database
>> >> >> > > >> dialog
>> >> >> > > >> page. This is the only way I know to get the script for the
>> >> >> > > >> task.
>> >> >> > > >> If
>> >> >> > > >> there
>> >> >> > > >> is another way, please explain and I'll give that a go and
>> >> >> > > >> post
>> >> >> > > >> it
>> >> >> > > >> here.
>> >> >> > > >>
>> >> >> > > >> The exact error message is:
>> >> >> > > >>
>> >> >> > > >> Backup failed for Server 'xxx.xxx.xxx.xxx'.
>> >> >> > > >> (Microsoftt.SqlServer.Express.Smo)
>> >> >> > > >> Additional Information:
>> >> >> > > >> Set property Devices to accomplish this action.
>> >> >> > > >> (Microsoftt.SqlServer.Express.Smo)
>> >> >> > > >>
>> >> >> > > >> Thanks for the reply,
>> >> >> > > >>
>> >> >> > > >> Steve
>> >> >> > > >>
>> >> >> > > >>
>> >> >> > > >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> >> >> > > >> news:6E760A54-E11D-4C3D-A759-57652863FF87@.microsoft.com...
>> >> >> > > >> > Hi Steve
>> >> >> > > >> >
>> >> >> > > >> > You don't say where you are trying to backup to?
>> >> >> > > >> >
>> >> >> > > >> > SSMS has the option to show you the SQL Statement that it
>> >> >> > > >> > would
>> >> >> > > >> > execute.
>> >> >> > > >> > Try
>> >> >> > > >> > copying that to the query window and running it. If that
>> >> >> > > >> > fails
>> >> >> > > >> > you
>> >> >> > > >> > could
>> >> >> > > >> > post
>> >> >> > > >> > the statement and the exact error message.
>> >> >> > > >> >
>> >> >> > > >> > John
>> >> >> > > >> >
>> >> >> > > >> > "Steve Ricketts" wrote:
>> >> >> > > >> >
>> >> >> > > >> >> I am getting error "Set property devices to accomplish
>> >> >> > > >> >> this
>> >> >> > > >> >> action"
>> >> >> > > >> >> when
>> >> >> > > >> >> I
>> >> >> > > >> >> try to do a full (or differential) backup on SQL Server
>> >> >> > > >> >> 2005
>> >> >> > > >> >> Express
>> >> >> > > >> >> though
>> >> >> > > >> >> the SQL Server Management Studio. I'm using the backup
>> >> >> > > >> >> defaults in
>> >> >> > > >> >> the
>> >> >> > > >> >> GUI
>> >> >> > > >> >> and was able to back the database up a couple of days ago
>> >> >> > > >> >> without any
>> >> >> > > >> >> problem. Today (second time) it just comes up with this
>> >> >> > > >> >> error
>> >> >> > > >> >> and I
>> >> >> > > >> >> can't
>> >> >> > > >> >> find anything on the web or in Microsoft's site that
>> >> >> > > >> >> talks
>> >> >> > > >> >> about what
>> >> >> > > >> >> it
>> >> >> > > >> >> might be.
>> >> >> > > >> >>
>> >> >> > > >> >> I've tried to look at the script by using the "Script
>> >> >> > > >> >> action
>> >> >> > > >> >> to
>> >> >> > > >> >> new
>> >> >> > > >> >> query,
>> >> >> > > >> >> file, clipboard, etc., but it fails before it writes
>> >> >> > > >> >> anything
>> >> >> > > >> >> to
>> >> >> > > >> >> either
>> >> >> > > >> >> destination. I've rebooted the server and cussed at it a
>> >> >> > > >> >> great
>> >> >> > > >> >> deal
>> >> >> > > >> >> but
>> >> >> > > >> >> that didn't help either.
>> >> >> > > >> >>
>> >> >> > > >> >> Any direction you can provide would be greatly
>> >> >> > > >> >> appreciated.
>> >> >> > > >> >>
>> >> >> > > >> >> Thank you,
>> >> >> > > >> >>
>> >> >> > > >> >> Steve
>> >> >> > > >> >>
>> >> >> > > >> >>
>> >> >> > > >> >>
>> >> >> > > >>
>> >> >> > > >>
>> >> >> > > >>
>> >> >> > >
>> >> >> > >
>> >> >> > >
>> >>
>> >>
>> >>
>>|||Hi Steve
This sounds like it is working correctly! Backing up to disc with no file
specified would produce an error. This also happens on other versions of SQL
Server. When you enter the dialog the file name reflects the last backup
made, therefore if you do a backup with the name spacified the file name
should be populated if you re-enter the dialog.
John
"Steve Ricketts" wrote:
> Correct. When I first entered the backup dialog, there is no file name
> specified in the Destination, Backup to: field and the backup fails. I
> clicked Add and referenced a backup file in the SQL default directory
> (Microsoft SQL Server\MSSQL.1\MSSQL\Backup) and the backup works. If I
> remove it again, it fails.
> Steve
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:2DB80403-5120-42A9-9E8D-156EDF9C89D6@.microsoft.com...
> > Hi Steve
> >
> > When you are backing up to disc, you need to specify the file! Are you
> > saying that when you take the default file name you get the error and when
> > you don't it is ok?
> >
> > John
> >
> > "Steve Ricketts" wrote:
> >
> >> No other backups are scheduled or running and there isn't an AV program
> >> on
> >> this server yet.
> >>
> >> If I specify a file name in the Destination field of the backup dialog,
> >> it
> >> creates a backup fine. If I remove the file name the backup fails with
> >> the
> >> previous error. I can even specify a file in the default backup
> >> directory
> >> and it works so it would appear the permissions are ok. I have no idea
> >> what
> >> the differences could be.
> >>
> >> Steve
> >>
> >>
> >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> >> news:E154E9B7-F1A2-406C-86B7-F0009C1BA640@.microsoft.com...
> >> > Hi Steve
> >> >
> >> > The readonly attribute seems to do that, (although I think only on XP)
> >> > if
> >> > you have granted full control to everyone I think it should be ok. If
> >> > you
> >> > can
> >> > create a different backup file in the same directory you should be ok
> >> > at
> >> > that
> >> > point in time. Have you made sure that any other OS backups are not
> >> > occuring
> >> > around that time, and have you made sure that any AV actitity is not
> >> > occurring (you may want to test these by excluding the directory).
> >> >
> >> > John
> >> >
> >> > "Steve Ricketts" wrote:
> >> >
> >> >> I just leave everything as is when doing the backup, Files and
> >> >> Filegroups
> >> >> is
> >> >> not selected.
> >> >>
> >> >> Actually, permissions is a good thought. I looked at the SQL backup
> >> >> directory and it was Read Only. So, I unchecked read only and gave
> >> >> everyone
> >> >> full permissions on that directory. No change, still an error. So I
> >> >> gave
> >> >> full permissions to everyone and took off the read only on the entire
> >> >> SQL
> >> >> directory, still an error. So I checked the permissions again and
> >> >> Read
> >> >> Only
> >> >> was checked again. I can't get it off. I wonder if that has anything
> >> >> to
> >> >> do
> >> >> with the problem... not to mention how to get it off.
> >> >>
> >> >> Steve
> >> >>
> >> >>
> >> >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> >> >> news:FD57916B-7478-4EEF-B12B-11A13277B071@.microsoft.com...
> >> >> > Hi Steve
> >> >> >
> >> >> > My guess is that something is either changing the file attributes or
> >> >> > permissions. Do you run a backup of the file system, or does your AV
> >> >> > software
> >> >> > do something to these?
> >> >> >
> >> >> > I guess you could get around this by having date specific filenames,
> >> >> > but
> >> >> > then you would need to clear up.
> >> >> >
> >> >> > John
> >> >> >
> >> >> > "SteveR" wrote:
> >> >> >
> >> >> >> Well, very odd indeed! After the reinstall, the backup worked for
> >> >> >> a
> >> >> >> couple
> >> >> >> of days and then stopped today with the same error!
> >> >> >>
> >> >> >> I tried your suggestions and both worked without an error. The
> >> >> >> script
> >> >> >> backed up the database and changing the name of the backup also
> >> >> >> worked.
> >> >> >> So,
> >> >> >> does that give you a good clue?... I hope! ;-)
> >> >> >>
> >> >> >> Steve
> >> >> >>
> >> >> >>
> >> >> >> "John Bell" wrote:
> >> >> >>
> >> >> >> > Hi Steve
> >> >> >> >
> >> >> >> > What error message did the manual backup return? If this was the
> >> >> >> > same
> >> >> >> > as
> >> >> >> > SSMS then it would rule SSMS out. If the disc file was a
> >> >> >> > different
> >> >> >> > one
> >> >> >> > (and
> >> >> >> > premissions had been ruled out) then you could rule out the
> >> >> >> > device.
> >> >> >> > I
> >> >> >> > had not
> >> >> >> > ascertained with it was related to this database or others, if
> >> >> >> > every
> >> >> >> > database
> >> >> >> > exhibited this problem then re-installing SQL Server may have to
> >> >> >> > be
> >> >> >> > one
> >> >> >> > of
> >> >> >> > the option!!
> >> >> >> >
> >> >> >> > John
> >> >> >> >
> >> >> >> > "Steve Ricketts" wrote:
> >> >> >> >
> >> >> >> > > Yes, I was backing up to a disk. I tried removing the file and
> >> >> >> > > doing
> >> >> >> > > the
> >> >> >> > > query but neither worked. So I just uninstalled everything
> >> >> >> > > that
> >> >> >> > > had
> >> >> >> > > to do
> >> >> >> > > with SQL Server 2005 Express and reinstalled. The backup is
> >> >> >> > > working
> >> >> >> > > now,
> >> >> >> > > but what a way to fix it!!
> >> >> >> > >
> >> >> >> > > Thanks for all your suggestions, very much appreciated.
> >> >> >> > >
> >> >> >> > > Steve
> >> >> >> > >
> >> >> >> > >
> >> >> >> > > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> >> >> >> > > news:E74A68D4-51AE-46F9-90EE-B0A3AE04C48C@.microsoft.com...
> >> >> >> > > > Hi Steve
> >> >> >> > > >
> >> >> >> > > > What is in the backup destination? If the backup is to disc
> >> >> >> > > > and
> >> >> >> > > > there is a
> >> >> >> > > > file specified, try removing it and adding a different one.
> >> >> >> > > >
> >> >> >> > > > You could also try a backup command in a query window such as
> >> >> >> > > >
> >> >> >> > > > BACKUP DATABASE [DBNAME] TO DISK => >> >> >> > > > N'C:\MSSQL\BACKUP\DBNAME.bak'
> >> >> >> > > > WITH NOFORMAT, NOINIT, NAME = N'DBNAME-Full Database
> >> >> >> > > > Backup',
> >> >> >> > > > SKIP,
> >> >> >> > > > NOREWIND, NOUNLOAD, STATS = 10
> >> >> >> > > > GO
> >> >> >> > > >
> >> >> >> > > > You would need to put in the correct details for you database
> >> >> >> > > > etc..
> >> >> >> > > >
> >> >> >> > > > John
> >> >> >> > > >
> >> >> >> > > >
> >> >> >> > > > "Steve Ricketts" wrote:
> >> >> >> > > >
> >> >> >> > > >> Just a standard backup to the default location. In fact all
> >> >> >> > > >> I
> >> >> >> > > >> did
> >> >> >> > > >> is
> >> >> >> > > >> right
> >> >> >> > > >> click the database, Tasks, Back Up, and clicked Ok.
> >> >> >> > > >>
> >> >> >> > > >> As I said, I've tried to get the script by using the "Script
> >> >> >> > > >> action to
> >> >> >> > > >> new
> >> >> >> > > >> query, file, clipboard, etc., but it fails before creating
> >> >> >> > > >> the
> >> >> >> > > >> script.
> >> >> >> > > >> I'm
> >> >> >> > > >> using the "Script" pull-down at the top of SSMS's Backup
> >> >> >> > > >> Database
> >> >> >> > > >> dialog
> >> >> >> > > >> page. This is the only way I know to get the script for the
> >> >> >> > > >> task.
> >> >> >> > > >> If
> >> >> >> > > >> there
> >> >> >> > > >> is another way, please explain and I'll give that a go and
> >> >> >> > > >> post
> >> >> >> > > >> it
> >> >> >> > > >> here.
> >> >> >> > > >>
> >> >> >> > > >> The exact error message is:
> >> >> >> > > >>
> >> >> >> > > >> Backup failed for Server 'xxx.xxx.xxx.xxx'.
> >> >> >> > > >> (Microsoftt.SqlServer.Express.Smo)
> >> >> >> > > >> Additional Information:
> >> >> >> > > >> Set property Devices to accomplish this action.
> >> >> >> > > >> (Microsoftt.SqlServer.Express.Smo)
> >> >> >> > > >>
> >> >> >> > > >> Thanks for the reply,
> >> >> >> > > >>
> >> >> >> > > >> Steve
> >> >> >> > > >>
> >> >> >> > > >>
> >> >> >> > > >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> >> >> >> > > >> news:6E760A54-E11D-4C3D-A759-57652863FF87@.microsoft.com...
> >> >> >> > > >> > Hi Steve
> >> >> >> > > >> >
> >> >> >> > > >> > You don't say where you are trying to backup to?
> >> >> >> > > >> >
> >> >> >> > > >> > SSMS has the option to show you the SQL Statement that it
> >> >> >> > > >> > would
> >> >> >> > > >> > execute.
> >> >> >> > > >> > Try
> >> >> >> > > >> > copying that to the query window and running it. If that
> >> >> >> > > >> > fails
> >> >> >> > > >> > you
> >> >> >> > > >> > could
> >> >> >> > > >> > post
> >> >> >> > > >> > the statement and the exact error message.
> >> >> >> > > >> >
> >> >> >> > > >> > John
> >> >> >> > > >> >
> >> >> >> > > >> > "Steve Ricketts" wrote:
> >> >> >> > > >> >
> >> >> >> > > >> >> I am getting error "Set property devices to accomplish
> >> >> >> > > >> >> this
> >> >> >> > > >> >> action"
> >> >> >> > > >> >> when
> >> >> >> > > >> >> I
> >> >> >> > > >> >> try to do a full (or differential) backup on SQL Server
> >> >> >> > > >> >> 2005
> >> >> >> > > >> >> Express
> >> >> >> > > >> >> though
> >> >> >> > > >> >> the SQL Server Management Studio. I'm using the backup
> >> >> >> > > >> >> defaults in
> >> >> >> > > >> >> the
> >> >> >> > > >> >> GUI
> >> >> >> > > >> >> and was able to back the database up a couple of days ago
> >> >> >> > > >> >> without any
> >> >> >> > > >> >> problem. Today (second time) it just comes up with this
> >> >> >> > > >> >> error
> >> >> >> > > >> >> and I
> >> >> >> > > >> >> can't
> >> >> >> > > >> >> find anything on the web or in Microsoft's site that
> >> >> >> > > >> >> talks
> >> >> >> > > >> >> about what
> >> >> >> > > >> >> it
> >> >> >> > > >> >> might be.
> >> >> >> > > >> >>
> >> >> >> > > >> >> I've tried to look at the script by using the "Script
> >> >> >> > > >> >> action
> >> >> >> > > >> >> to
> >> >> >> > > >> >> new
> >> >> >> > > >> >> query,
> >> >> >> > > >> >> file, clipboard, etc., but it fails before it writes
> >> >> >> > > >> >> anything
> >> >> >> > > >> >> to
> >> >> >> > > >> >> either
> >> >> >> > > >> >> destination. I've rebooted the server and cussed at it a
> >> >> >> > > >> >> great
> >> >> >> > > >> >> deal
> >> >> >> > > >> >> but
> >> >> >> > > >> >> that didn't help either.
> >> >> >> > > >> >>
> >> >> >> > > >> >> Any direction you can provide would be greatly
> >> >> >> > > >> >> appreciated.
> >> >> >> > > >> >>
> >> >> >> > > >> >> Thank you,
> >> >> >> > > >> >>
> >> >> >> > > >> >> Steve
> >> >> >> > > >> >>
> >> >> >> > > >> >>
> >> >> >> > > >> >>
> >> >> >> > > >>
> >> >> >> > > >>
> >> >> >> > > >>
> >> >> >> > >
> >> >> >> > >
> >> >> >> > >|||Well then, I feel pretty stupid. I don't recall having to do that anywhere
else... or I'm probably thinking the backup jobs that create a backup file
with the date as part of the name. Ok, well thanks a ton for the help!!
Sorry I took so much of your time for such a dumb problem.
Steve
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:7FEAD582-74D7-4827-BFA0-631566AFEF01@.microsoft.com...
> Hi Steve
> This sounds like it is working correctly! Backing up to disc with no file
> specified would produce an error. This also happens on other versions of
> SQL
> Server. When you enter the dialog the file name reflects the last backup
> made, therefore if you do a backup with the name spacified the file name
> should be populated if you re-enter the dialog.
> John
> "Steve Ricketts" wrote:
>> Correct. When I first entered the backup dialog, there is no file name
>> specified in the Destination, Backup to: field and the backup fails. I
>> clicked Add and referenced a backup file in the SQL default directory
>> (Microsoft SQL Server\MSSQL.1\MSSQL\Backup) and the backup works. If I
>> remove it again, it fails.
>> Steve
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:2DB80403-5120-42A9-9E8D-156EDF9C89D6@.microsoft.com...
>> > Hi Steve
>> >
>> > When you are backing up to disc, you need to specify the file! Are you
>> > saying that when you take the default file name you get the error and
>> > when
>> > you don't it is ok?
>> >
>> > John
>> >
>> > "Steve Ricketts" wrote:
>> >
>> >> No other backups are scheduled or running and there isn't an AV
>> >> program
>> >> on
>> >> this server yet.
>> >>
>> >> If I specify a file name in the Destination field of the backup
>> >> dialog,
>> >> it
>> >> creates a backup fine. If I remove the file name the backup fails
>> >> with
>> >> the
>> >> previous error. I can even specify a file in the default backup
>> >> directory
>> >> and it works so it would appear the permissions are ok. I have no
>> >> idea
>> >> what
>> >> the differences could be.
>> >>
>> >> Steve
>> >>
>> >>
>> >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> >> news:E154E9B7-F1A2-406C-86B7-F0009C1BA640@.microsoft.com...
>> >> > Hi Steve
>> >> >
>> >> > The readonly attribute seems to do that, (although I think only on
>> >> > XP)
>> >> > if
>> >> > you have granted full control to everyone I think it should be ok.
>> >> > If
>> >> > you
>> >> > can
>> >> > create a different backup file in the same directory you should be
>> >> > ok
>> >> > at
>> >> > that
>> >> > point in time. Have you made sure that any other OS backups are not
>> >> > occuring
>> >> > around that time, and have you made sure that any AV actitity is not
>> >> > occurring (you may want to test these by excluding the directory).
>> >> >
>> >> > John
>> >> >
>> >> > "Steve Ricketts" wrote:
>> >> >
>> >> >> I just leave everything as is when doing the backup, Files and
>> >> >> Filegroups
>> >> >> is
>> >> >> not selected.
>> >> >>
>> >> >> Actually, permissions is a good thought. I looked at the SQL
>> >> >> backup
>> >> >> directory and it was Read Only. So, I unchecked read only and gave
>> >> >> everyone
>> >> >> full permissions on that directory. No change, still an error. So
>> >> >> I
>> >> >> gave
>> >> >> full permissions to everyone and took off the read only on the
>> >> >> entire
>> >> >> SQL
>> >> >> directory, still an error. So I checked the permissions again and
>> >> >> Read
>> >> >> Only
>> >> >> was checked again. I can't get it off. I wonder if that has
>> >> >> anything
>> >> >> to
>> >> >> do
>> >> >> with the problem... not to mention how to get it off.
>> >> >>
>> >> >> Steve
>> >> >>
>> >> >>
>> >> >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> >> >> news:FD57916B-7478-4EEF-B12B-11A13277B071@.microsoft.com...
>> >> >> > Hi Steve
>> >> >> >
>> >> >> > My guess is that something is either changing the file attributes
>> >> >> > or
>> >> >> > permissions. Do you run a backup of the file system, or does your
>> >> >> > AV
>> >> >> > software
>> >> >> > do something to these?
>> >> >> >
>> >> >> > I guess you could get around this by having date specific
>> >> >> > filenames,
>> >> >> > but
>> >> >> > then you would need to clear up.
>> >> >> >
>> >> >> > John
>> >> >> >
>> >> >> > "SteveR" wrote:
>> >> >> >
>> >> >> >> Well, very odd indeed! After the reinstall, the backup worked
>> >> >> >> for
>> >> >> >> a
>> >> >> >> couple
>> >> >> >> of days and then stopped today with the same error!
>> >> >> >>
>> >> >> >> I tried your suggestions and both worked without an error. The
>> >> >> >> script
>> >> >> >> backed up the database and changing the name of the backup also
>> >> >> >> worked.
>> >> >> >> So,
>> >> >> >> does that give you a good clue?... I hope! ;-)
>> >> >> >>
>> >> >> >> Steve
>> >> >> >>
>> >> >> >>
>> >> >> >> "John Bell" wrote:
>> >> >> >>
>> >> >> >> > Hi Steve
>> >> >> >> >
>> >> >> >> > What error message did the manual backup return? If this was
>> >> >> >> > the
>> >> >> >> > same
>> >> >> >> > as
>> >> >> >> > SSMS then it would rule SSMS out. If the disc file was a
>> >> >> >> > different
>> >> >> >> > one
>> >> >> >> > (and
>> >> >> >> > premissions had been ruled out) then you could rule out the
>> >> >> >> > device.
>> >> >> >> > I
>> >> >> >> > had not
>> >> >> >> > ascertained with it was related to this database or others, if
>> >> >> >> > every
>> >> >> >> > database
>> >> >> >> > exhibited this problem then re-installing SQL Server may have
>> >> >> >> > to
>> >> >> >> > be
>> >> >> >> > one
>> >> >> >> > of
>> >> >> >> > the option!!
>> >> >> >> >
>> >> >> >> > John
>> >> >> >> >
>> >> >> >> > "Steve Ricketts" wrote:
>> >> >> >> >
>> >> >> >> > > Yes, I was backing up to a disk. I tried removing the file
>> >> >> >> > > and
>> >> >> >> > > doing
>> >> >> >> > > the
>> >> >> >> > > query but neither worked. So I just uninstalled everything
>> >> >> >> > > that
>> >> >> >> > > had
>> >> >> >> > > to do
>> >> >> >> > > with SQL Server 2005 Express and reinstalled. The backup is
>> >> >> >> > > working
>> >> >> >> > > now,
>> >> >> >> > > but what a way to fix it!!
>> >> >> >> > >
>> >> >> >> > > Thanks for all your suggestions, very much appreciated.
>> >> >> >> > >
>> >> >> >> > > Steve
>> >> >> >> > >
>> >> >> >> > >
>> >> >> >> > > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> >> >> >> > > news:E74A68D4-51AE-46F9-90EE-B0A3AE04C48C@.microsoft.com...
>> >> >> >> > > > Hi Steve
>> >> >> >> > > >
>> >> >> >> > > > What is in the backup destination? If the backup is to
>> >> >> >> > > > disc
>> >> >> >> > > > and
>> >> >> >> > > > there is a
>> >> >> >> > > > file specified, try removing it and adding a different
>> >> >> >> > > > one.
>> >> >> >> > > >
>> >> >> >> > > > You could also try a backup command in a query window such
>> >> >> >> > > > as
>> >> >> >> > > >
>> >> >> >> > > > BACKUP DATABASE [DBNAME] TO DISK =>> >> >> >> > > > N'C:\MSSQL\BACKUP\DBNAME.bak'
>> >> >> >> > > > WITH NOFORMAT, NOINIT, NAME = N'DBNAME-Full Database
>> >> >> >> > > > Backup',
>> >> >> >> > > > SKIP,
>> >> >> >> > > > NOREWIND, NOUNLOAD, STATS = 10
>> >> >> >> > > > GO
>> >> >> >> > > >
>> >> >> >> > > > You would need to put in the correct details for you
>> >> >> >> > > > database
>> >> >> >> > > > etc..
>> >> >> >> > > >
>> >> >> >> > > > John
>> >> >> >> > > >
>> >> >> >> > > >
>> >> >> >> > > > "Steve Ricketts" wrote:
>> >> >> >> > > >
>> >> >> >> > > >> Just a standard backup to the default location. In fact
>> >> >> >> > > >> all
>> >> >> >> > > >> I
>> >> >> >> > > >> did
>> >> >> >> > > >> is
>> >> >> >> > > >> right
>> >> >> >> > > >> click the database, Tasks, Back Up, and clicked Ok.
>> >> >> >> > > >>
>> >> >> >> > > >> As I said, I've tried to get the script by using the
>> >> >> >> > > >> "Script
>> >> >> >> > > >> action to
>> >> >> >> > > >> new
>> >> >> >> > > >> query, file, clipboard, etc., but it fails before
>> >> >> >> > > >> creating
>> >> >> >> > > >> the
>> >> >> >> > > >> script.
>> >> >> >> > > >> I'm
>> >> >> >> > > >> using the "Script" pull-down at the top of SSMS's Backup
>> >> >> >> > > >> Database
>> >> >> >> > > >> dialog
>> >> >> >> > > >> page. This is the only way I know to get the script for
>> >> >> >> > > >> the
>> >> >> >> > > >> task.
>> >> >> >> > > >> If
>> >> >> >> > > >> there
>> >> >> >> > > >> is another way, please explain and I'll give that a go
>> >> >> >> > > >> and
>> >> >> >> > > >> post
>> >> >> >> > > >> it
>> >> >> >> > > >> here.
>> >> >> >> > > >>
>> >> >> >> > > >> The exact error message is:
>> >> >> >> > > >>
>> >> >> >> > > >> Backup failed for Server 'xxx.xxx.xxx.xxx'.
>> >> >> >> > > >> (Microsoftt.SqlServer.Express.Smo)
>> >> >> >> > > >> Additional Information:
>> >> >> >> > > >> Set property Devices to accomplish this action.
>> >> >> >> > > >> (Microsoftt.SqlServer.Express.Smo)
>> >> >> >> > > >>
>> >> >> >> > > >> Thanks for the reply,
>> >> >> >> > > >>
>> >> >> >> > > >> Steve
>> >> >> >> > > >>
>> >> >> >> > > >>
>> >> >> >> > > >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> >> >> >> > > >> news:6E760A54-E11D-4C3D-A759-57652863FF87@.microsoft.com...
>> >> >> >> > > >> > Hi Steve
>> >> >> >> > > >> >
>> >> >> >> > > >> > You don't say where you are trying to backup to?
>> >> >> >> > > >> >
>> >> >> >> > > >> > SSMS has the option to show you the SQL Statement that
>> >> >> >> > > >> > it
>> >> >> >> > > >> > would
>> >> >> >> > > >> > execute.
>> >> >> >> > > >> > Try
>> >> >> >> > > >> > copying that to the query window and running it. If
>> >> >> >> > > >> > that
>> >> >> >> > > >> > fails
>> >> >> >> > > >> > you
>> >> >> >> > > >> > could
>> >> >> >> > > >> > post
>> >> >> >> > > >> > the statement and the exact error message.
>> >> >> >> > > >> >
>> >> >> >> > > >> > John
>> >> >> >> > > >> >
>> >> >> >> > > >> > "Steve Ricketts" wrote:
>> >> >> >> > > >> >
>> >> >> >> > > >> >> I am getting error "Set property devices to accomplish
>> >> >> >> > > >> >> this
>> >> >> >> > > >> >> action"
>> >> >> >> > > >> >> when
>> >> >> >> > > >> >> I
>> >> >> >> > > >> >> try to do a full (or differential) backup on SQL
>> >> >> >> > > >> >> Server
>> >> >> >> > > >> >> 2005
>> >> >> >> > > >> >> Express
>> >> >> >> > > >> >> though
>> >> >> >> > > >> >> the SQL Server Management Studio. I'm using the
>> >> >> >> > > >> >> backup
>> >> >> >> > > >> >> defaults in
>> >> >> >> > > >> >> the
>> >> >> >> > > >> >> GUI
>> >> >> >> > > >> >> and was able to back the database up a couple of days
>> >> >> >> > > >> >> ago
>> >> >> >> > > >> >> without any
>> >> >> >> > > >> >> problem. Today (second time) it just comes up with
>> >> >> >> > > >> >> this
>> >> >> >> > > >> >> error
>> >> >> >> > > >> >> and I
>> >> >> >> > > >> >> can't
>> >> >> >> > > >> >> find anything on the web or in Microsoft's site that
>> >> >> >> > > >> >> talks
>> >> >> >> > > >> >> about what
>> >> >> >> > > >> >> it
>> >> >> >> > > >> >> might be.
>> >> >> >> > > >> >>
>> >> >> >> > > >> >> I've tried to look at the script by using the "Script
>> >> >> >> > > >> >> action
>> >> >> >> > > >> >> to
>> >> >> >> > > >> >> new
>> >> >> >> > > >> >> query,
>> >> >> >> > > >> >> file, clipboard, etc., but it fails before it writes
>> >> >> >> > > >> >> anything
>> >> >> >> > > >> >> to
>> >> >> >> > > >> >> either
>> >> >> >> > > >> >> destination. I've rebooted the server and cussed at
>> >> >> >> > > >> >> it a
>> >> >> >> > > >> >> great
>> >> >> >> > > >> >> deal
>> >> >> >> > > >> >> but
>> >> >> >> > > >> >> that didn't help either.
>> >> >> >> > > >> >>
>> >> >> >> > > >> >> Any direction you can provide would be greatly
>> >> >> >> > > >> >> appreciated.
>> >> >> >> > > >> >>
>> >> >> >> > > >> >> Thank you,
>> >> >> >> > > >> >>
>> >> >> >> > > >> >> Steve
>> >> >> >> > > >> >>
>> >> >> >> > > >> >>
>> >> >> >> > > >> >>
>> >> >> >> > > >>
>> >> >> >> > > >>
>> >> >> >> > > >>
>> >> >> >> > >
>> >> >> >> > >
>> >> >> >> > >|||Hi Steve
No problem, the backup jobs that contains dates as part of their name are
probably maintenance plans!
JOhn
"Steve Ricketts" wrote:
> Well then, I feel pretty stupid. I don't recall having to do that anywhere
> else... or I'm probably thinking the backup jobs that create a backup file
> with the date as part of the name. Ok, well thanks a ton for the help!!
> Sorry I took so much of your time for such a dumb problem.
> Steve
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:7FEAD582-74D7-4827-BFA0-631566AFEF01@.microsoft.com...
> > Hi Steve
> >
> > This sounds like it is working correctly! Backing up to disc with no file
> > specified would produce an error. This also happens on other versions of
> > SQL
> > Server. When you enter the dialog the file name reflects the last backup
> > made, therefore if you do a backup with the name spacified the file name
> > should be populated if you re-enter the dialog.
> >
> > John
> >
> > "Steve Ricketts" wrote:
> >
> >> Correct. When I first entered the backup dialog, there is no file name
> >> specified in the Destination, Backup to: field and the backup fails. I
> >> clicked Add and referenced a backup file in the SQL default directory
> >> (Microsoft SQL Server\MSSQL.1\MSSQL\Backup) and the backup works. If I
> >> remove it again, it fails.
> >>
> >> Steve
> >>
> >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> >> news:2DB80403-5120-42A9-9E8D-156EDF9C89D6@.microsoft.com...
> >> > Hi Steve
> >> >
> >> > When you are backing up to disc, you need to specify the file! Are you
> >> > saying that when you take the default file name you get the error and
> >> > when
> >> > you don't it is ok?
> >> >
> >> > John
> >> >
> >> > "Steve Ricketts" wrote:
> >> >
> >> >> No other backups are scheduled or running and there isn't an AV
> >> >> program
> >> >> on
> >> >> this server yet.
> >> >>
> >> >> If I specify a file name in the Destination field of the backup
> >> >> dialog,
> >> >> it
> >> >> creates a backup fine. If I remove the file name the backup fails
> >> >> with
> >> >> the
> >> >> previous error. I can even specify a file in the default backup
> >> >> directory
> >> >> and it works so it would appear the permissions are ok. I have no
> >> >> idea
> >> >> what
> >> >> the differences could be.
> >> >>
> >> >> Steve
> >> >>
> >> >>
> >> >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> >> >> news:E154E9B7-F1A2-406C-86B7-F0009C1BA640@.microsoft.com...
> >> >> > Hi Steve
> >> >> >
> >> >> > The readonly attribute seems to do that, (although I think only on
> >> >> > XP)
> >> >> > if
> >> >> > you have granted full control to everyone I think it should be ok.
> >> >> > If
> >> >> > you
> >> >> > can
> >> >> > create a different backup file in the same directory you should be
> >> >> > ok
> >> >> > at
> >> >> > that
> >> >> > point in time. Have you made sure that any other OS backups are not
> >> >> > occuring
> >> >> > around that time, and have you made sure that any AV actitity is not
> >> >> > occurring (you may want to test these by excluding the directory).
> >> >> >
> >> >> > John
> >> >> >
> >> >> > "Steve Ricketts" wrote:
> >> >> >
> >> >> >> I just leave everything as is when doing the backup, Files and
> >> >> >> Filegroups
> >> >> >> is
> >> >> >> not selected.
> >> >> >>
> >> >> >> Actually, permissions is a good thought. I looked at the SQL
> >> >> >> backup
> >> >> >> directory and it was Read Only. So, I unchecked read only and gave
> >> >> >> everyone
> >> >> >> full permissions on that directory. No change, still an error. So
> >> >> >> I
> >> >> >> gave
> >> >> >> full permissions to everyone and took off the read only on the
> >> >> >> entire
> >> >> >> SQL
> >> >> >> directory, still an error. So I checked the permissions again and
> >> >> >> Read
> >> >> >> Only
> >> >> >> was checked again. I can't get it off. I wonder if that has
> >> >> >> anything
> >> >> >> to
> >> >> >> do
> >> >> >> with the problem... not to mention how to get it off.
> >> >> >>
> >> >> >> Steve
> >> >> >>
> >> >> >>
> >> >> >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> >> >> >> news:FD57916B-7478-4EEF-B12B-11A13277B071@.microsoft.com...
> >> >> >> > Hi Steve
> >> >> >> >
> >> >> >> > My guess is that something is either changing the file attributes
> >> >> >> > or
> >> >> >> > permissions. Do you run a backup of the file system, or does your
> >> >> >> > AV
> >> >> >> > software
> >> >> >> > do something to these?
> >> >> >> >
> >> >> >> > I guess you could get around this by having date specific
> >> >> >> > filenames,
> >> >> >> > but
> >> >> >> > then you would need to clear up.
> >> >> >> >
> >> >> >> > John
> >> >> >> >
> >> >> >> > "SteveR" wrote:
> >> >> >> >
> >> >> >> >> Well, very odd indeed! After the reinstall, the backup worked
> >> >> >> >> for
> >> >> >> >> a
> >> >> >> >> couple
> >> >> >> >> of days and then stopped today with the same error!
> >> >> >> >>
> >> >> >> >> I tried your suggestions and both worked without an error. The
> >> >> >> >> script
> >> >> >> >> backed up the database and changing the name of the backup also
> >> >> >> >> worked.
> >> >> >> >> So,
> >> >> >> >> does that give you a good clue?... I hope! ;-)
> >> >> >> >>
> >> >> >> >> Steve
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> "John Bell" wrote:
> >> >> >> >>
> >> >> >> >> > Hi Steve
> >> >> >> >> >
> >> >> >> >> > What error message did the manual backup return? If this was
> >> >> >> >> > the
> >> >> >> >> > same
> >> >> >> >> > as
> >> >> >> >> > SSMS then it would rule SSMS out. If the disc file was a
> >> >> >> >> > different
> >> >> >> >> > one
> >> >> >> >> > (and
> >> >> >> >> > premissions had been ruled out) then you could rule out the
> >> >> >> >> > device.
> >> >> >> >> > I
> >> >> >> >> > had not
> >> >> >> >> > ascertained with it was related to this database or others, if
> >> >> >> >> > every
> >> >> >> >> > database
> >> >> >> >> > exhibited this problem then re-installing SQL Server may have
> >> >> >> >> > to
> >> >> >> >> > be
> >> >> >> >> > one
> >> >> >> >> > of
> >> >> >> >> > the option!!
> >> >> >> >> >
> >> >> >> >> > John
> >> >> >> >> >
> >> >> >> >> > "Steve Ricketts" wrote:
> >> >> >> >> >
> >> >> >> >> > > Yes, I was backing up to a disk. I tried removing the file
> >> >> >> >> > > and
> >> >> >> >> > > doing
> >> >> >> >> > > the
> >> >> >> >> > > query but neither worked. So I just uninstalled everything
> >> >> >> >> > > that
> >> >> >> >> > > had
> >> >> >> >> > > to do
> >> >> >> >> > > with SQL Server 2005 Express and reinstalled. The backup is
> >> >> >> >> > > working
> >> >> >> >> > > now,
> >> >> >> >> > > but what a way to fix it!!
> >> >> >> >> > >
> >> >> >> >> > > Thanks for all your suggestions, very much appreciated.
> >> >> >> >> > >
> >> >> >> >> > > Steve
> >> >> >> >> > >
> >> >> >> >> > >
> >> >> >> >> > > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> >> >> >> >> > > news:E74A68D4-51AE-46F9-90EE-B0A3AE04C48C@.microsoft.com...
> >> >> >> >> > > > Hi Steve
> >> >> >> >> > > >
> >> >> >> >> > > > What is in the backup destination? If the backup is to
> >> >> >> >> > > > disc
> >> >> >> >> > > > and
> >> >> >> >> > > > there is a
> >> >> >> >> > > > file specified, try removing it and adding a different
> >> >> >> >> > > > one.
> >> >> >> >> > > >
> >> >> >> >> > > > You could also try a backup command in a query window such
> >> >> >> >> > > > as
> >> >> >> >> > > >
> >> >> >> >> > > > BACKUP DATABASE [DBNAME] TO DISK => >> >> >> >> > > > N'C:\MSSQL\BACKUP\DBNAME.bak'
> >> >> >> >> > > > WITH NOFORMAT, NOINIT, NAME = N'DBNAME-Full Database
> >> >> >> >> > > > Backup',
> >> >> >> >> > > > SKIP,
> >> >> >> >> > > > NOREWIND, NOUNLOAD, STATS = 10
> >> >> >> >> > > > GO
> >> >> >> >> > > >
> >> >> >> >> > > > You would need to put in the correct details for you
> >> >> >> >> > > > database
> >> >> >> >> > > > etc..
> >> >> >> >> > > >
> >> >> >> >> > > > John
> >> >> >> >> > > >
> >> >> >> >> > > >
> >> >> >> >> > > > "Steve Ricketts" wrote:
> >> >> >> >> > > >
> >> >> >> >> > > >> Just a standard backup to the default location. In fact
> >> >> >> >> > > >> all
> >> >> >> >> > > >> I
> >> >> >> >> > > >> did
> >> >> >> >> > > >> is
> >> >> >> >> > > >> right
> >> >> >> >> > > >> click the database, Tasks, Back Up, and clicked Ok.
> >> >> >> >> > > >>
> >> >> >> >> > > >> As I said, I've tried to get the script by using the
> >> >> >> >> > > >> "Script
> >> >> >> >> > > >> action to
> >> >> >> >> > > >> new
> >> >> >> >> > > >> query, file, clipboard, etc., but it fails before
> >> >> >> >> > > >> creating
> >> >> >> >> > > >> the
> >> >> >> >> > > >> script.
> >> >> >> >> > > >> I'm
> >> >> >> >> > > >> using the "Script" pull-down at the top of SSMS's Backup
> >> >> >> >> > > >> Database
> >> >> >> >> > > >> dialog
> >> >> >> >> > > >> page. This is the only way I know to get the script for
> >> >> >> >> > > >> the
> >> >> >> >> > > >> task.
> >> >> >> >> > > >> If
> >> >> >> >> > > >> there
> >> >> >> >> > > >> is another way, please explain and I'll give that a go
> >> >> >> >> > > >> and
> >> >> >> >> > > >> post
> >> >> >> >> > > >> it
> >> >> >> >> > > >> here.
> >> >> >> >> > > >>
> >> >> >> >> > > >> The exact error message is:
> >> >> >> >> > > >>
> >> >> >> >> > > >> Backup failed for Server 'xxx.xxx.xxx.xxx'.
> >> >> >> >> > > >> (Microsoftt.SqlServer.Express.Smo)
> >> >> >> >> > > >> Additional Information:
> >> >> >> >> > > >> Set property Devices to accomplish this action.
> >> >> >> >> > > >> (Microsoftt.SqlServer.Express.Smo)
> >> >> >> >> > > >>
> >> >> >> >> > > >> Thanks for the reply,
> >> >> >> >> > > >>
> >> >> >> >> > > >> Steve
> >> >> >> >> > > >>
> >> >> >> >> > > >>
> >> >> >> >> > > >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> >> >> >> >> > > >> news:6E760A54-E11D-4C3D-A759-57652863FF87@.microsoft.com...
> >> >> >> >> > > >> > Hi Steve
> >> >> >> >> > > >> >
> >> >> >> >> > > >> > You don't say where you are trying to backup to?
> >> >> >> >> > > >> >
> >> >> >> >> > > >> > SSMS has the option to show you the SQL Statement that
> >> >> >> >> > > >> > it
> >> >> >> >> > > >> > would
> >> >> >> >> > > >> > execute.
> >> >> >> >> > > >> > Try
> >> >> >> >> > > >> > copying that to the query window and running it. If
> >> >> >> >> > > >> > that
> >> >> >> >> > > >> > fails
> >> >> >> >> > > >> > you
> >> >> >> >> > > >> > could
> >> >> >> >> > > >> > post
> >> >> >> >> > > >> > the statement and the exact error message.
> >> >> >> >> > > >> >
> >> >> >> >> > > >> > John
> >> >> >> >> > > >> >
> >> >> >> >> > > >> > "Steve Ricketts" wrote:
> >> >> >> >> > > >> >
> >> >> >> >> > > >> >> I am getting error "Set property devices to accomplish
> >> >> >> >> > > >> >> this