Hy Guys!
I`m having a BIG problem!
This is the way i`m following:
All Tasks - Restore Database - From Device - Select Devices - Add - ...
Error!
Take a look in this popup:
EVENT ID: 26
DESCRIPTION:
Application Popup: sqlserver.exe - No Disk: There is no disk in the drive. Please insert a disk into drive A:
Thanx!You know sometimes Microsoft remembers the last time it opened Explorer, which may have been the 'A' drive, who knows. But have you tried putting a disk into 'A' drive just to get past the error?|||Yes I putted.
But, when i removed it..
The same problm...|||So what steps did you do:[list=1]
Put disk into 'A'
Go into Enterprise Manager and add a backup device
The new backup device you choose was on a drive other than 'A'
Close the Backup/Restore screen
Remove disk from 'A'
[/list=1]
Then go back into Back/Restore?|||I did exactly this. But the same problem.
----------------------
Now,
Take a look in this article:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;q301077&
Microsoft tells to install W2K SP3. But it is already installed.
I can`t install the offered patch... It may trouble SP3 instalation...
What do You think?
Should I Install patch ? I need to restore a Database...
PS.: Doing this with T-SQL gives the same message...
This is a servetr that controls almost all bank transactions of BB the principal bak of Brazil.|||I don't want to make the call, but if I had clean backups of my databases, I would apply the patch. However I feel confident that given any situation I would be able to recover.
It is up to you. Not what you wanted to hear.|||heheh!
Not what I wanted to hear.
But, need to be done!
Really appreciate your help!
Thanx!
Showing posts with label select. Show all posts
Showing posts with label select. Show all posts
Monday, March 19, 2012
Sunday, March 11, 2012
Backup problems
Hi,
I'm getting "BackupMedium::ReportIoError: write failure on
backup device 'd:\select
legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK'.
Operating system error 112(error not found)" messages in
the SQL 2000 Server logs when we try to backup our
databases. This is followed by "Internal I/O request
0x53BE4B78: Op: Write, pBuffer: 0x0D6A0000, Size: 983040,
Position: 21632512, UMS: Internal: 0x103, InternalHigh:
0x0, Offset: 0x14A1600, OffsetHigh: 0x0, m_buf:
0x0D6A0000, m_len: 983040, m_actualBytes: 0, m_errcode:
112, BackupFile: d:\select
legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK" and
then "BACKUP failed to complete the command BACKUP
DATABASE [legal] TO DISK = N'd:\select
legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK' WITH
INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT"
messages. The database is around 300Mb and we have 40Gb of
free space on the drive.
The server is Dell PE2600 with a Perc Raid controller
handling 3 drives in Raid 5 config. These are split into
two drives; C: for OS and D: for applications and data.
The smaller system databases back up OK as do the
transaction logs. I've found a reference to writeback
cache but don't know if this is the root cause of the
problem. The OS is Windows 2003 Small Business Server with
SQL Server SP3a.
TIA
Trevor>
> Hi,
> I'm getting "BackupMedium::ReportIoError: write failure on
> backup device 'd:\select
> legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK'.
> Operating system error 112(error not found)" messages in
> the SQL 2000 Server logs when we try to backup our
> databases. This is followed by "Internal I/O request
> 0x53BE4B78: Op: Write, pBuffer: 0x0D6A0000, Size: 983040,
> Position: 21632512, UMS: Internal: 0x103, InternalHigh:
> 0x0, Offset: 0x14A1600, OffsetHigh: 0x0, m_buf:
> 0x0D6A0000, m_len: 983040, m_actualBytes: 0, m_errcode:
> 112, BackupFile: d:\select
> legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK" and
> then "BACKUP failed to complete the command BACKUP
> DATABASE [legal] TO DISK = N'd:\select
> legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK' WITH
> INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT"
> messages. The database is around 300Mb and we have 40Gb of
> free space on the drive.
> The server is Dell PE2600 with a Perc Raid controller
> handling 3 drives in Raid 5 config. These are split into
> two drives; C: for OS and D: for applications and data.
> The smaller system databases back up OK as do the
> transaction logs. I've found a reference to writeback
> cache but don't know if this is the root cause of the
> problem. The OS is Windows 2003 Small Business Server with
> SQL Server SP3a.
> TIA
> Trevor
>
--
Hi Trevor,
Are you using a compressed volume? It is possible that you are out of
diskspace.
Compressed volumes are not supported. Also checkout the following article:
INF: SQL Server and Striped Backups
http://support.microsoft.com/?id=325334
Hope this helps,
--
Eric Cárdenas
SQL Server senior support professional|||Eric Cardenas wrote:
> >
> > Hi,
> > I'm getting "BackupMedium::ReportIoError: write failure on
> > backup device 'd:\select
> > legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK'.
> > Operating system error 112(error not found)" messages in
> > the SQL 2000 Server logs when we try to backup our
> > databases. This is followed by "Internal I/O request
> > 0x53BE4B78: Op: Write, pBuffer: 0x0D6A0000, Size: 983040,
> > Position: 21632512, UMS: Internal: 0x103, InternalHigh:
> > 0x0, Offset: 0x14A1600, OffsetHigh: 0x0, m_buf:
> > 0x0D6A0000, m_len: 983040, m_actualBytes: 0, m_errcode:
> > 112, BackupFile: d:\select
> > legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK" and
> > then "BACKUP failed to complete the command BACKUP
> > DATABASE [legal] TO DISK = N'd:\select
> > legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK' WITH
> > INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT"
> > messages. The database is around 300Mb and we have 40Gb of
> > free space on the drive.
> > The server is Dell PE2600 with a Perc Raid controller
> > handling 3 drives in Raid 5 config. These are split into
> > two drives; C: for OS and D: for applications and data.
> > The smaller system databases back up OK as do the
> > transaction logs. I've found a reference to writeback
> > cache but don't know if this is the root cause of the
> > problem. The OS is Windows 2003 Small Business Server with
> > SQL Server SP3a.
> > TIA
> > Trevor
> >
> --
> Hi Trevor,
> Are you using a compressed volume? It is possible that you are out of
> diskspace.
> Compressed volumes are not supported. Also checkout the following
> article:
> INF: SQL Server and Striped Backups
> http://support.microsoft.com/?id=325334
> Hope this helps,
> --
> Eric Cardenas
> SQL Server senior support professional
Eric,
We should have plenty of disk space. The drives aren't compressed as
far as I am aware.
The databases reside on the same drive that we are backing up to.
We are backing up the databases to a folder on the drive using the SQL
Server backup, and then to tape; the actual database files we exclude
from the tape backup.
The server reports around 40Gb of free space on a 60Gb drive, and the
databases that it fails to back up are our main data database which is
around 200Mb to 250Mb in size, and one of the SQL Server system
databases which looks to be only around 25Mb! The other smaller system
databases back up OK.
The drive is on a Raid 5 array which comprises three 60Gb drives.
We can copy and otherwise create large files on the drive without any
problems; we can copy the database files manually with out any problems
(when we shutdown the SQL Server)
It just seems to be the SQL Server backup of the databases that are
reporting an error.
I've seen some references to writeback cache causing a problem like
this, but nothing that I can say "this is how we fix the problem"
I can't believe that the problem is with the raid striping as I would
then expect loads of people to be reporting this.
Trevor
I'm getting "BackupMedium::ReportIoError: write failure on
backup device 'd:\select
legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK'.
Operating system error 112(error not found)" messages in
the SQL 2000 Server logs when we try to backup our
databases. This is followed by "Internal I/O request
0x53BE4B78: Op: Write, pBuffer: 0x0D6A0000, Size: 983040,
Position: 21632512, UMS: Internal: 0x103, InternalHigh:
0x0, Offset: 0x14A1600, OffsetHigh: 0x0, m_buf:
0x0D6A0000, m_len: 983040, m_actualBytes: 0, m_errcode:
112, BackupFile: d:\select
legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK" and
then "BACKUP failed to complete the command BACKUP
DATABASE [legal] TO DISK = N'd:\select
legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK' WITH
INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT"
messages. The database is around 300Mb and we have 40Gb of
free space on the drive.
The server is Dell PE2600 with a Perc Raid controller
handling 3 drives in Raid 5 config. These are split into
two drives; C: for OS and D: for applications and data.
The smaller system databases back up OK as do the
transaction logs. I've found a reference to writeback
cache but don't know if this is the root cause of the
problem. The OS is Windows 2003 Small Business Server with
SQL Server SP3a.
TIA
Trevor>
> Hi,
> I'm getting "BackupMedium::ReportIoError: write failure on
> backup device 'd:\select
> legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK'.
> Operating system error 112(error not found)" messages in
> the SQL 2000 Server logs when we try to backup our
> databases. This is followed by "Internal I/O request
> 0x53BE4B78: Op: Write, pBuffer: 0x0D6A0000, Size: 983040,
> Position: 21632512, UMS: Internal: 0x103, InternalHigh:
> 0x0, Offset: 0x14A1600, OffsetHigh: 0x0, m_buf:
> 0x0D6A0000, m_len: 983040, m_actualBytes: 0, m_errcode:
> 112, BackupFile: d:\select
> legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK" and
> then "BACKUP failed to complete the command BACKUP
> DATABASE [legal] TO DISK = N'd:\select
> legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK' WITH
> INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT"
> messages. The database is around 300Mb and we have 40Gb of
> free space on the drive.
> The server is Dell PE2600 with a Perc Raid controller
> handling 3 drives in Raid 5 config. These are split into
> two drives; C: for OS and D: for applications and data.
> The smaller system databases back up OK as do the
> transaction logs. I've found a reference to writeback
> cache but don't know if this is the root cause of the
> problem. The OS is Windows 2003 Small Business Server with
> SQL Server SP3a.
> TIA
> Trevor
>
--
Hi Trevor,
Are you using a compressed volume? It is possible that you are out of
diskspace.
Compressed volumes are not supported. Also checkout the following article:
INF: SQL Server and Striped Backups
http://support.microsoft.com/?id=325334
Hope this helps,
--
Eric Cárdenas
SQL Server senior support professional|||Eric Cardenas wrote:
> >
> > Hi,
> > I'm getting "BackupMedium::ReportIoError: write failure on
> > backup device 'd:\select
> > legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK'.
> > Operating system error 112(error not found)" messages in
> > the SQL 2000 Server logs when we try to backup our
> > databases. This is followed by "Internal I/O request
> > 0x53BE4B78: Op: Write, pBuffer: 0x0D6A0000, Size: 983040,
> > Position: 21632512, UMS: Internal: 0x103, InternalHigh:
> > 0x0, Offset: 0x14A1600, OffsetHigh: 0x0, m_buf:
> > 0x0D6A0000, m_len: 983040, m_actualBytes: 0, m_errcode:
> > 112, BackupFile: d:\select
> > legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK" and
> > then "BACKUP failed to complete the command BACKUP
> > DATABASE [legal] TO DISK = N'd:\select
> > legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK' WITH
> > INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT"
> > messages. The database is around 300Mb and we have 40Gb of
> > free space on the drive.
> > The server is Dell PE2600 with a Perc Raid controller
> > handling 3 drives in Raid 5 config. These are split into
> > two drives; C: for OS and D: for applications and data.
> > The smaller system databases back up OK as do the
> > transaction logs. I've found a reference to writeback
> > cache but don't know if this is the root cause of the
> > problem. The OS is Windows 2003 Small Business Server with
> > SQL Server SP3a.
> > TIA
> > Trevor
> >
> --
> Hi Trevor,
> Are you using a compressed volume? It is possible that you are out of
> diskspace.
> Compressed volumes are not supported. Also checkout the following
> article:
> INF: SQL Server and Striped Backups
> http://support.microsoft.com/?id=325334
> Hope this helps,
> --
> Eric Cardenas
> SQL Server senior support professional
Eric,
We should have plenty of disk space. The drives aren't compressed as
far as I am aware.
The databases reside on the same drive that we are backing up to.
We are backing up the databases to a folder on the drive using the SQL
Server backup, and then to tape; the actual database files we exclude
from the tape backup.
The server reports around 40Gb of free space on a 60Gb drive, and the
databases that it fails to back up are our main data database which is
around 200Mb to 250Mb in size, and one of the SQL Server system
databases which looks to be only around 25Mb! The other smaller system
databases back up OK.
The drive is on a Raid 5 array which comprises three 60Gb drives.
We can copy and otherwise create large files on the drive without any
problems; we can copy the database files manually with out any problems
(when we shutdown the SQL Server)
It just seems to be the SQL Server backup of the databases that are
reporting an error.
I've seen some references to writeback cache causing a problem like
this, but nothing that I can say "this is how we fix the problem"
I can't believe that the problem is with the raid striping as I would
then expect loads of people to be reporting this.
Trevor
Backup problems
Hi,
I'm getting "BackupMedium::ReportIoError: write failure on
backup device 'd:\select
legal\MSSQL$LEGAL\BACKUP\legal_db_200404
292100.BAK'.
Operating system error 112(error not found)" messages in
the SQL 2000 Server logs when we try to backup our
databases. This is followed by "Internal I/O request
0x53BE4B78: Op: Write, pBuffer: 0x0D6A0000, Size: 983040,
Position: 21632512, UMS: Internal: 0x103, InternalHigh:
0x0, Offset: 0x14A1600, OffsetHigh: 0x0, m_buf:
0x0D6A0000, m_len: 983040, m_actualBytes: 0, m_errcode:
112, BackupFile: d:\select
legal\MSSQL$LEGAL\BACKUP\legal_db_200404
292100.BAK" and
then "BACKUP failed to complete the command BACKUP
DATABASE [legal] TO DISK = N'd:\select
legal\MSSQL$LEGAL\BACKUP\legal_db_200404
292100.BAK' WITH
INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT"
messages. The database is around 300Mb and we have 40Gb of
free space on the drive.
The server is Dell PE2600 with a Perc Raid controller
handling 3 drives in Raid 5 config. These are split into
two drives; C: for OS and D: for applications and data.
The smaller system databases back up OK as do the
transaction logs. I've found a reference to writeback
cache but don't know if this is the root cause of the
problem. The OS is Windows 2003 Small Business Server with
SQL Server SP3a.
TIA
Trevor>
> Hi,
> I'm getting "BackupMedium::ReportIoError: write failure on
> backup device 'd:\select
> legal\MSSQL$LEGAL\BACKUP\legal_db_200404
292100.BAK'.
> Operating system error 112(error not found)" messages in
> the SQL 2000 Server logs when we try to backup our
> databases. This is followed by "Internal I/O request
> 0x53BE4B78: Op: Write, pBuffer: 0x0D6A0000, Size: 983040,
> Position: 21632512, UMS: Internal: 0x103, InternalHigh:
> 0x0, Offset: 0x14A1600, OffsetHigh: 0x0, m_buf:
> 0x0D6A0000, m_len: 983040, m_actualBytes: 0, m_errcode:
> 112, BackupFile: d:\select
> legal\MSSQL$LEGAL\BACKUP\legal_db_200404
292100.BAK" and
> then "BACKUP failed to complete the command BACKUP
> DATABASE [legal] TO DISK = N'd:\select
> legal\MSSQL$LEGAL\BACKUP\legal_db_200404
292100.BAK' WITH
> INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT"
> messages. The database is around 300Mb and we have 40Gb of
> free space on the drive.
> The server is Dell PE2600 with a Perc Raid controller
> handling 3 drives in Raid 5 config. These are split into
> two drives; C: for OS and D: for applications and data.
> The smaller system databases back up OK as do the
> transaction logs. I've found a reference to writeback
> cache but don't know if this is the root cause of the
> problem. The OS is Windows 2003 Small Business Server with
> SQL Server SP3a.
> TIA
> Trevor
>
--
Hi Trevor,
Are you using a compressed volume? It is possible that you are out of
diskspace.
Compressed volumes are not supported. Also checkout the following article:
INF: SQL Server and Striped Backups
http://support.microsoft.com/?id=325334
Hope this helps,
Eric Crdenas
SQL Server senior support professional|||Eric Cardenas wrote:
> --
> Hi Trevor,
> Are you using a compressed volume? It is possible that you are out of
> diskspace.
> Compressed volumes are not supported. Also checkout the following
> article:
> INF: SQL Server and Striped Backups
> http://support.microsoft.com/?id=325334
> Hope this helps,
> --
> Eric Cardenas
> SQL Server senior support professional
Eric,
We should have plenty of disk space. The drives aren't compressed as
far as I am aware.
The databases reside on the same drive that we are backing up to.
We are backing up the databases to a folder on the drive using the SQL
Server backup, and then to tape; the actual database files we exclude
from the tape backup.
The server reports around 40Gb of free space on a 60Gb drive, and the
databases that it fails to back up are our main data database which is
around 200Mb to 250Mb in size, and one of the SQL Server system
databases which looks to be only around 25Mb! The other smaller system
databases back up OK.
The drive is on a Raid 5 array which comprises three 60Gb drives.
We can copy and otherwise create large files on the drive without any
problems; we can copy the database files manually with out any problems
(when we shutdown the SQL Server)
It just seems to be the SQL Server backup of the databases that are
reporting an error.
I've seen some references to writeback cache causing a problem like
this, but nothing that I can say "this is how we fix the problem"
I can't believe that the problem is with the raid striping as I would
then expect loads of people to be reporting this.
Trevor
I'm getting "BackupMedium::ReportIoError: write failure on
backup device 'd:\select
legal\MSSQL$LEGAL\BACKUP\legal_db_200404
292100.BAK'.
Operating system error 112(error not found)" messages in
the SQL 2000 Server logs when we try to backup our
databases. This is followed by "Internal I/O request
0x53BE4B78: Op: Write, pBuffer: 0x0D6A0000, Size: 983040,
Position: 21632512, UMS: Internal: 0x103, InternalHigh:
0x0, Offset: 0x14A1600, OffsetHigh: 0x0, m_buf:
0x0D6A0000, m_len: 983040, m_actualBytes: 0, m_errcode:
112, BackupFile: d:\select
legal\MSSQL$LEGAL\BACKUP\legal_db_200404
292100.BAK" and
then "BACKUP failed to complete the command BACKUP
DATABASE [legal] TO DISK = N'd:\select
legal\MSSQL$LEGAL\BACKUP\legal_db_200404
292100.BAK' WITH
INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT"
messages. The database is around 300Mb and we have 40Gb of
free space on the drive.
The server is Dell PE2600 with a Perc Raid controller
handling 3 drives in Raid 5 config. These are split into
two drives; C: for OS and D: for applications and data.
The smaller system databases back up OK as do the
transaction logs. I've found a reference to writeback
cache but don't know if this is the root cause of the
problem. The OS is Windows 2003 Small Business Server with
SQL Server SP3a.
TIA
Trevor>
> Hi,
> I'm getting "BackupMedium::ReportIoError: write failure on
> backup device 'd:\select
> legal\MSSQL$LEGAL\BACKUP\legal_db_200404
292100.BAK'.
> Operating system error 112(error not found)" messages in
> the SQL 2000 Server logs when we try to backup our
> databases. This is followed by "Internal I/O request
> 0x53BE4B78: Op: Write, pBuffer: 0x0D6A0000, Size: 983040,
> Position: 21632512, UMS: Internal: 0x103, InternalHigh:
> 0x0, Offset: 0x14A1600, OffsetHigh: 0x0, m_buf:
> 0x0D6A0000, m_len: 983040, m_actualBytes: 0, m_errcode:
> 112, BackupFile: d:\select
> legal\MSSQL$LEGAL\BACKUP\legal_db_200404
292100.BAK" and
> then "BACKUP failed to complete the command BACKUP
> DATABASE [legal] TO DISK = N'd:\select
> legal\MSSQL$LEGAL\BACKUP\legal_db_200404
292100.BAK' WITH
> INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT"
> messages. The database is around 300Mb and we have 40Gb of
> free space on the drive.
> The server is Dell PE2600 with a Perc Raid controller
> handling 3 drives in Raid 5 config. These are split into
> two drives; C: for OS and D: for applications and data.
> The smaller system databases back up OK as do the
> transaction logs. I've found a reference to writeback
> cache but don't know if this is the root cause of the
> problem. The OS is Windows 2003 Small Business Server with
> SQL Server SP3a.
> TIA
> Trevor
>
--
Hi Trevor,
Are you using a compressed volume? It is possible that you are out of
diskspace.
Compressed volumes are not supported. Also checkout the following article:
INF: SQL Server and Striped Backups
http://support.microsoft.com/?id=325334
Hope this helps,
Eric Crdenas
SQL Server senior support professional|||Eric Cardenas wrote:
> --
> Hi Trevor,
> Are you using a compressed volume? It is possible that you are out of
> diskspace.
> Compressed volumes are not supported. Also checkout the following
> article:
> INF: SQL Server and Striped Backups
> http://support.microsoft.com/?id=325334
> Hope this helps,
> --
> Eric Cardenas
> SQL Server senior support professional
Eric,
We should have plenty of disk space. The drives aren't compressed as
far as I am aware.
The databases reside on the same drive that we are backing up to.
We are backing up the databases to a folder on the drive using the SQL
Server backup, and then to tape; the actual database files we exclude
from the tape backup.
The server reports around 40Gb of free space on a 60Gb drive, and the
databases that it fails to back up are our main data database which is
around 200Mb to 250Mb in size, and one of the SQL Server system
databases which looks to be only around 25Mb! The other smaller system
databases back up OK.
The drive is on a Raid 5 array which comprises three 60Gb drives.
We can copy and otherwise create large files on the drive without any
problems; we can copy the database files manually with out any problems
(when we shutdown the SQL Server)
It just seems to be the SQL Server backup of the databases that are
reporting an error.
I've seen some references to writeback cache causing a problem like
this, but nothing that I can say "this is how we fix the problem"
I can't believe that the problem is with the raid striping as I would
then expect loads of people to be reporting this.
Trevor
Thursday, March 8, 2012
Backup Permissions
Hi,
The user that i use to make backups is in the
db_backupoperator, but when i select the backup
destination the following error appear:
ERROR 229: EXECUTE permission denied on
object 'xp_availablemedia', database 'master', owner 'dbo'
cant understand
Beat regardsHi
An what are the permissions on this stored procedure?
John
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:18f4301c44c93$2caec050$a301280a@.phx
.gbl...
> Hi,
> The user that i use to make backups is in the
> db_backupoperator, but when i select the backup
> destination the following error appear:
> ERROR 229: EXECUTE permission denied on
> object 'xp_availablemedia', database 'master', owner 'dbo'
> cant understand
> Beat regards|||Hi,
Open query analyzer and execute the below command:-
master..xp_availablemedia
Check the drives, the command is displaying. Based on this create the backup
files. I think you are trying to backup to a remote server or a media not
available. If the execution gives you an error try giving execute prev to
this extended procedure to your backup user.
use master
go
sp_adduser <user_name>
go
grant exec on xp_availablemedia to <user>
(Try executing backup database now)
Still if you have errors then try below:- Can you please assign "SYSADMIN"
server fixed role to this user and try backup the database.
Thanks
Hari
MCDBA
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:18f4301c44c93$2caec050$a301280a@.phx
.gbl...
> Hi,
> The user that i use to make backups is in the
> db_backupoperator, but when i select the backup
> destination the following error appear:
> ERROR 229: EXECUTE permission denied on
> object 'xp_availablemedia', database 'master', owner 'dbo'
> cant understand
> Beat regards
The user that i use to make backups is in the
db_backupoperator, but when i select the backup
destination the following error appear:
ERROR 229: EXECUTE permission denied on
object 'xp_availablemedia', database 'master', owner 'dbo'
cant understand
Beat regardsHi
An what are the permissions on this stored procedure?
John
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:18f4301c44c93$2caec050$a301280a@.phx
.gbl...
> Hi,
> The user that i use to make backups is in the
> db_backupoperator, but when i select the backup
> destination the following error appear:
> ERROR 229: EXECUTE permission denied on
> object 'xp_availablemedia', database 'master', owner 'dbo'
> cant understand
> Beat regards|||Hi,
Open query analyzer and execute the below command:-
master..xp_availablemedia
Check the drives, the command is displaying. Based on this create the backup
files. I think you are trying to backup to a remote server or a media not
available. If the execution gives you an error try giving execute prev to
this extended procedure to your backup user.
use master
go
sp_adduser <user_name>
go
grant exec on xp_availablemedia to <user>
(Try executing backup database now)
Still if you have errors then try below:- Can you please assign "SYSADMIN"
server fixed role to this user and try backup the database.
Thanks
Hari
MCDBA
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:18f4301c44c93$2caec050$a301280a@.phx
.gbl...
> Hi,
> The user that i use to make backups is in the
> db_backupoperator, but when i select the backup
> destination the following error appear:
> ERROR 229: EXECUTE permission denied on
> object 'xp_availablemedia', database 'master', owner 'dbo'
> cant understand
> Beat regards
Backup Permissions
Hi,
The user that i use to make backups is in the
db_backupoperator, but when i select the backup
destination the following error appear:
ERROR 229: EXECUTE permission denied on
object 'xp_availablemedia', database 'master', owner 'dbo'
cant understand
Beat regardsHi
An what are the permissions on this stored procedure?
John
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:18f4301c44c93$2caec050$a301280a@.phx.gbl...
> Hi,
> The user that i use to make backups is in the
> db_backupoperator, but when i select the backup
> destination the following error appear:
> ERROR 229: EXECUTE permission denied on
> object 'xp_availablemedia', database 'master', owner 'dbo'
> cant understand
> Beat regards|||Hi,
Open query analyzer and execute the below command:-
master..xp_availablemedia
Check the drives, the command is displaying. Based on this create the backup
files. I think you are trying to backup to a remote server or a media not
available. If the execution gives you an error try giving execute prev to
this extended procedure to your backup user.
use master
go
sp_adduser <user_name>
go
grant exec on xp_availablemedia to <user>
(Try executing backup database now)
Still if you have errors then try below:- Can you please assign "SYSADMIN"
server fixed role to this user and try backup the database.
Thanks
Hari
MCDBA
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:18f4301c44c93$2caec050$a301280a@.phx.gbl...
> Hi,
> The user that i use to make backups is in the
> db_backupoperator, but when i select the backup
> destination the following error appear:
> ERROR 229: EXECUTE permission denied on
> object 'xp_availablemedia', database 'master', owner 'dbo'
> cant understand
> Beat regards
The user that i use to make backups is in the
db_backupoperator, but when i select the backup
destination the following error appear:
ERROR 229: EXECUTE permission denied on
object 'xp_availablemedia', database 'master', owner 'dbo'
cant understand
Beat regardsHi
An what are the permissions on this stored procedure?
John
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:18f4301c44c93$2caec050$a301280a@.phx.gbl...
> Hi,
> The user that i use to make backups is in the
> db_backupoperator, but when i select the backup
> destination the following error appear:
> ERROR 229: EXECUTE permission denied on
> object 'xp_availablemedia', database 'master', owner 'dbo'
> cant understand
> Beat regards|||Hi,
Open query analyzer and execute the below command:-
master..xp_availablemedia
Check the drives, the command is displaying. Based on this create the backup
files. I think you are trying to backup to a remote server or a media not
available. If the execution gives you an error try giving execute prev to
this extended procedure to your backup user.
use master
go
sp_adduser <user_name>
go
grant exec on xp_availablemedia to <user>
(Try executing backup database now)
Still if you have errors then try below:- Can you please assign "SYSADMIN"
server fixed role to this user and try backup the database.
Thanks
Hari
MCDBA
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:18f4301c44c93$2caec050$a301280a@.phx.gbl...
> Hi,
> The user that i use to make backups is in the
> db_backupoperator, but when i select the backup
> destination the following error appear:
> ERROR 229: EXECUTE permission denied on
> object 'xp_availablemedia', database 'master', owner 'dbo'
> cant understand
> Beat regards
Backup Permissions
Hi,
The user that i use to make backups is in the
db_backupoperator, but when i select the backup
destination the following error appear:
ERROR 229: EXECUTE permission denied on
object 'xp_availablemedia', database 'master', owner 'dbo'
cant understand
Beat regards
Hi
An what are the permissions on this stored procedure?
John
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:18f4301c44c93$2caec050$a301280a@.phx.gbl...
> Hi,
> The user that i use to make backups is in the
> db_backupoperator, but when i select the backup
> destination the following error appear:
> ERROR 229: EXECUTE permission denied on
> object 'xp_availablemedia', database 'master', owner 'dbo'
> cant understand
> Beat regards
|||Hi,
Open query analyzer and execute the below command:-
master..xp_availablemedia
Check the drives, the command is displaying. Based on this create the backup
files. I think you are trying to backup to a remote server or a media not
available. If the execution gives you an error try giving execute prev to
this extended procedure to your backup user.
use master
go
sp_adduser <user_name>
go
grant exec on xp_availablemedia to <user>
(Try executing backup database now)
Still if you have errors then try below:- Can you please assign "SYSADMIN"
server fixed role to this user and try backup the database.
Thanks
Hari
MCDBA
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:18f4301c44c93$2caec050$a301280a@.phx.gbl...
> Hi,
> The user that i use to make backups is in the
> db_backupoperator, but when i select the backup
> destination the following error appear:
> ERROR 229: EXECUTE permission denied on
> object 'xp_availablemedia', database 'master', owner 'dbo'
> cant understand
> Beat regards
The user that i use to make backups is in the
db_backupoperator, but when i select the backup
destination the following error appear:
ERROR 229: EXECUTE permission denied on
object 'xp_availablemedia', database 'master', owner 'dbo'
cant understand
Beat regards
Hi
An what are the permissions on this stored procedure?
John
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:18f4301c44c93$2caec050$a301280a@.phx.gbl...
> Hi,
> The user that i use to make backups is in the
> db_backupoperator, but when i select the backup
> destination the following error appear:
> ERROR 229: EXECUTE permission denied on
> object 'xp_availablemedia', database 'master', owner 'dbo'
> cant understand
> Beat regards
|||Hi,
Open query analyzer and execute the below command:-
master..xp_availablemedia
Check the drives, the command is displaying. Based on this create the backup
files. I think you are trying to backup to a remote server or a media not
available. If the execution gives you an error try giving execute prev to
this extended procedure to your backup user.
use master
go
sp_adduser <user_name>
go
grant exec on xp_availablemedia to <user>
(Try executing backup database now)
Still if you have errors then try below:- Can you please assign "SYSADMIN"
server fixed role to this user and try backup the database.
Thanks
Hari
MCDBA
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:18f4301c44c93$2caec050$a301280a@.phx.gbl...
> Hi,
> The user that i use to make backups is in the
> db_backupoperator, but when i select the backup
> destination the following error appear:
> ERROR 229: EXECUTE permission denied on
> object 'xp_availablemedia', database 'master', owner 'dbo'
> cant understand
> Beat regards
Wednesday, March 7, 2012
Backup operation terminating abnormally
Hi.
I have a problem with sql when trie backup my Data. The message is follow:
"Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such as
CREATIVE FILE) operations on a database must be serialized. Reissue the
statement after the current backup, checkalloc, or file file manipulation
operation is competed.
Backup or restore operation terminating abnormally."
What i do for resolve this problem?
Thanks a lot
Gerardo
Look up the help for BACKUP. Some operations will block backup operations,
such as those mentioned in the message you posted. Someone must've been
running one of those operations while you were trying to perform the backup.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Use MiniSQLBackup Lite, free!
"Gerardo" <Gerardo @.discussions.microsoft.com> wrote in message
news:8C3D21F2-B2CA-40BF-A09B-BBFCFC98DD36@.microsoft.com...
> Hi.
> I have a problem with sql when trie backup my Data. The message is follow:
> "Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such
as
> CREATIVE FILE) operations on a database must be serialized. Reissue the
> statement after the current backup, checkalloc, or file file manipulation
> operation is competed.
> Backup or restore operation terminating abnormally."
>
> What i do for resolve this problem?
> Thanks a lot
> Gerardo
I have a problem with sql when trie backup my Data. The message is follow:
"Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such as
CREATIVE FILE) operations on a database must be serialized. Reissue the
statement after the current backup, checkalloc, or file file manipulation
operation is competed.
Backup or restore operation terminating abnormally."
What i do for resolve this problem?
Thanks a lot
Gerardo
Look up the help for BACKUP. Some operations will block backup operations,
such as those mentioned in the message you posted. Someone must've been
running one of those operations while you were trying to perform the backup.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Use MiniSQLBackup Lite, free!
"Gerardo" <Gerardo @.discussions.microsoft.com> wrote in message
news:8C3D21F2-B2CA-40BF-A09B-BBFCFC98DD36@.microsoft.com...
> Hi.
> I have a problem with sql when trie backup my Data. The message is follow:
> "Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such
as
> CREATIVE FILE) operations on a database must be serialized. Reissue the
> statement after the current backup, checkalloc, or file file manipulation
> operation is competed.
> Backup or restore operation terminating abnormally."
>
> What i do for resolve this problem?
> Thanks a lot
> Gerardo
Backup operation terminating abnormally
Hi.
I have a problem with sql when trie backup my Data. The message is follow:
"Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such as
CREATIVE FILE) operations on a database must be serialized. Reissue the
statement after the current backup, checkalloc, or file file manipulation
operation is competed.
Backup or restore operation terminating abnormally."
What i do for resolve this problem?
Thanks a lot
GerardoLook up the help for BACKUP. Some operations will block backup operations,
such as those mentioned in the message you posted. Someone must've been
running one of those operations while you were trying to perform the backup.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Use MiniSQLBackup Lite, free!
"Gerardo" <Gerardo @.discussions.microsoft.com> wrote in message
news:8C3D21F2-B2CA-40BF-A09B-BBFCFC98DD36@.microsoft.com...
> Hi.
> I have a problem with sql when trie backup my Data. The message is follow:
> "Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such
as
> CREATIVE FILE) operations on a database must be serialized. Reissue the
> statement after the current backup, checkalloc, or file file manipulation
> operation is competed.
> Backup or restore operation terminating abnormally."
>
> What i do for resolve this problem?
> Thanks a lot
> Gerardo
I have a problem with sql when trie backup my Data. The message is follow:
"Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such as
CREATIVE FILE) operations on a database must be serialized. Reissue the
statement after the current backup, checkalloc, or file file manipulation
operation is competed.
Backup or restore operation terminating abnormally."
What i do for resolve this problem?
Thanks a lot
GerardoLook up the help for BACKUP. Some operations will block backup operations,
such as those mentioned in the message you posted. Someone must've been
running one of those operations while you were trying to perform the backup.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Use MiniSQLBackup Lite, free!
"Gerardo" <Gerardo @.discussions.microsoft.com> wrote in message
news:8C3D21F2-B2CA-40BF-A09B-BBFCFC98DD36@.microsoft.com...
> Hi.
> I have a problem with sql when trie backup my Data. The message is follow:
> "Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such
as
> CREATIVE FILE) operations on a database must be serialized. Reissue the
> statement after the current backup, checkalloc, or file file manipulation
> operation is competed.
> Backup or restore operation terminating abnormally."
>
> What i do for resolve this problem?
> Thanks a lot
> Gerardo
Backup operation terminating abnormally
Hi.
I have a problem with sql when trie backup my Data. The message is follow:
"Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such as
CREATIVE FILE) operations on a database must be serialized. Reissue the
statement after the current backup, checkalloc, or file file manipulation
operation is competed.
Backup or restore operation terminating abnormally."
What i do for resolve this problem?
Thanks a lot
GerardoLook up the help for BACKUP. Some operations will block backup operations,
such as those mentioned in the message you posted. Someone must've been
running one of those operations while you were trying to perform the backup.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Use MiniSQLBackup Lite, free!
"Gerardo" <Gerardo @.discussions.microsoft.com> wrote in message
news:8C3D21F2-B2CA-40BF-A09B-BBFCFC98DD36@.microsoft.com...
> Hi.
> I have a problem with sql when trie backup my Data. The message is follow:
> "Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such
as
> CREATIVE FILE) operations on a database must be serialized. Reissue the
> statement after the current backup, checkalloc, or file file manipulation
> operation is competed.
> Backup or restore operation terminating abnormally."
>
> What i do for resolve this problem?
> Thanks a lot
> Gerardo
I have a problem with sql when trie backup my Data. The message is follow:
"Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such as
CREATIVE FILE) operations on a database must be serialized. Reissue the
statement after the current backup, checkalloc, or file file manipulation
operation is competed.
Backup or restore operation terminating abnormally."
What i do for resolve this problem?
Thanks a lot
GerardoLook up the help for BACKUP. Some operations will block backup operations,
such as those mentioned in the message you posted. Someone must've been
running one of those operations while you were trying to perform the backup.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Use MiniSQLBackup Lite, free!
"Gerardo" <Gerardo @.discussions.microsoft.com> wrote in message
news:8C3D21F2-B2CA-40BF-A09B-BBFCFC98DD36@.microsoft.com...
> Hi.
> I have a problem with sql when trie backup my Data. The message is follow:
> "Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such
as
> CREATIVE FILE) operations on a database must be serialized. Reissue the
> statement after the current backup, checkalloc, or file file manipulation
> operation is competed.
> Backup or restore operation terminating abnormally."
>
> What i do for resolve this problem?
> Thanks a lot
> Gerardo
Backup of tables
Hi Guys,
I would like to take a backup of tables and further use them for manipulation purpose.
(e.g.)
Select * into arc_employee_07_07_2005 from employee
Where 07_07_2005 is formatted from getdate().
Thanks in advance.
How can i achieve this formate.
select right('00' + cast(day(current_timestamp) as varchar)), 2)|||Hi JayaChandran
i have just modified ur query to something like this.
select * into Arc_Employee_+(select cast(day(current_timestamp) as varchar)+'_'+
cast(month(current_timestamp) as varchar)+'_'+cast(year(current_timestamp) as varchar))
from Employee
Can you modify the above query. so that the table name should be having a suffix of date. (eg) Ar_TableName_Date.
Thanks in Advance|||You cannot specify an expression as table name for the INTO clause. You have to generate the name and then use dynamic SQL to execute the SELECT INTO statement. If you do not want to use dynamic sql, another option is to do following:
select * into _temp_arc_employee from Employee
exec sp_rename '_temp_arc_employee', 'new name'
This will work only if this is the only connection performing this operation otherwise you will get error due to same name being used for the SELECT...INTO table name from different connections.
Friday, February 10, 2012
Backup files
hello! can you take a look at my question?
We use ARCServe to backup exchange server file (priv1.stm and priv1.edb) every night. When I select both of the files and start to back up using ARCServe. It showed me that Backup Operation Successful.
When I check the files, it didnt backup both of the files. I dont know why. Do you know how to backup these two files?
Many thanks.:S
Hmmm ... now what forum should I post this in? ArcServe? Exchange? OS?
:D
I know! SQL Server!
?????
We use ARCServe to backup exchange server file (priv1.stm and priv1.edb) every night. When I select both of the files and start to back up using ARCServe. It showed me that Backup Operation Successful.
When I check the files, it didnt backup both of the files. I dont know why. Do you know how to backup these two files?
Many thanks.:S
Hmmm ... now what forum should I post this in? ArcServe? Exchange? OS?
:D
I know! SQL Server!
?????
Subscribe to:
Posts (Atom)