Backup File I/o Error

Guys,

Apologies if this is in the wrong section. I have a SQL 2000 database which I backup to a folder on the hard disk using the following command in a Server Agent:

BACKUP DATABASE [Multilog] TO DISK = N'C:\MSSQL7\BACKUP\multilog_backup' WITH INIT , NOUNLOAD , NAME = N'Multilog backup', NOSKIP , STATS = 10, NOFORMAT

Recently it has been failing with the following error message:

Nonrecoverable I/O error occurred on file 'C:\Multilog Database Files\Data\MultiLog_data.MDF'. [SQLSTATE 42000] (Error 3271) Backup or restore operation terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.

Any idea what could be causing this?

Any help would be greatly appreciated.

Sean.

Try some of the method(s) in the following kb:

http://support.microsoft.com/default.aspx/kb/904804

Is this an SP4 server? Looks like it may have been upgraded from SQL 7.0, is that correct?

|||

Chad,

Just noticed the following error on the logs:

I/O error 23(Data error (cyclic redundancy check).) detected during read of BUF pointer = 0x14243d80, page ptr = 0x1607c000, pageid = (0x1:0x1ae), dbid = 5, status = 0x801, file = C:\Multilog Database Files\Data\MultiLog_data.MDF..

Would this indicate a fault with the actual database file? Any idea what could be done to check and fix?

|||

Yeah, that would indicate a data integrity issue within your DB file. Try running a DBCC CHECKDB on the database in question and see what you get for output. Depending on the output of that, you could try using the FIX options with the CHECKDB command, rebuilding indexes, etc.

Backup file database was restored from

Hello!
I am trying to find out name of the backup file database was restored from
(I am restoring from DISK), something similar to physical_device_name in
backupmediafamily. restorehistory doesn't have this information.
Any advice is greatly appreciated.
Thanks,
Igor
You can use backup_set_id on restorehistory and media_set_id on backupset to
find the record on backupmediafamily.
Hope this helps,
Ben Nevarez
"Igor Marchenko" wrote:

> Hello!
> I am trying to find out name of the backup file database was restored from
> (I am restoring from DISK), something similar to physical_device_name in
> backupmediafamily. restorehistory doesn't have this information.
> Any advice is greatly appreciated.
> Thanks,
> Igor
|||Thanks a lot Ben! That exactly what I was looking for.
Igor
"Ben Nevarez" wrote:
[vbcol=seagreen]
> You can use backup_set_id on restorehistory and media_set_id on backupset to
> find the record on backupmediafamily.
> Hope this helps,
> Ben Nevarez
>
>
> "Igor Marchenko" wrote:
sql

Backup file database was restored from

Hello!
I am trying to find out name of the backup file database was restored from
(I am restoring from DISK), something similar to physical_device_name in
backupmediafamily. restorehistory doesn't have this information.
Any advice is greatly appreciated.
Thanks,
IgorYou can use backup_set_id on restorehistory and media_set_id on backupset to
find the record on backupmediafamily.
Hope this helps,
Ben Nevarez
"Igor Marchenko" wrote:
> Hello!
> I am trying to find out name of the backup file database was restored from
> (I am restoring from DISK), something similar to physical_device_name in
> backupmediafamily. restorehistory doesn't have this information.
> Any advice is greatly appreciated.
> Thanks,
> Igor|||Thanks a lot Ben! That exactly what I was looking for.
Igor
"Ben Nevarez" wrote:
> You can use backup_set_id on restorehistory and media_set_id on backupset to
> find the record on backupmediafamily.
> Hope this helps,
> Ben Nevarez
>
>
> "Igor Marchenko" wrote:
> > Hello!
> >
> > I am trying to find out name of the backup file database was restored from
> > (I am restoring from DISK), something similar to physical_device_name in
> > backupmediafamily. restorehistory doesn't have this information.
> > Any advice is greatly appreciated.
> >
> > Thanks,
> > Igor

Backup failed: Operating system error 112(error not found).

Hi,
I keep getting this error message for a trans.log backup.
Operating system error
112(error not found).
The disk has about 6GB space free, and the backup should only take up
about 550 MB, so I would think it is not space related but...
The disk is NTFS.
Any ideas?smeagol (carlamichelle1@.hotmail.com) writes:
> I keep getting this error message for a trans.log backup.
> Operating system error
> 112(error not found).
> The disk has about 6GB space free, and the backup should only take up
> about 550 MB, so I would think it is not space related but...

... but NET HELPMSG 112 says

There is not enough space on the disk.

> The disk is NTFS.
> Any ideas?

Not many. I would perform all sorts of sanity checks that you are looking
on the right disk, that the transaction log is small as you believe it
to be etc.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Did you ever get this sorted ?
I'm having the same problem and have heaps of free disk space ? :confused:sql

Backup Error

I got an error with a back up maintenance plan: BACKUP failed to
complete the command BACKUP LOG [EAGLE] TO DISK = N'\
\Eaglent1\backuponeaglent1\backup\EAGLE LOG BACKUP' WITH NOINIT ,
NOUNLOAD , NAME = N'EAGLE LOG BACKUP', NOSKIP , STATS = 10,
DESCRIPTION = N'EAGLE LOG BACKUP', NOFORMAT. I also see this error
along with it: The backup data in '\\Eaglent1\backuponeaglent1\backup
\EAGLE LOG BACKUP' is incorrectly formatted. Backups cannot be
appended, but existing backup sets may still be usable.
What do I need to change to get this backup completed?
Joanne Mahoney
SDN Consultants
Jacksonville, FLMy guess is that your file EAGLE LOG BACKUP already exists, and it is not a
sql backup file, and you are appending to it.
If so, taking out any one of those, you should be good.
Quentin
"Joanne M." <joanne.e.mahoney@.gmail.com> wrote in message
news:1190401872.060395.60460@.w3g2000hsg.googlegroups.com...
>I got an error with a back up maintenance plan: BACKUP failed to
> complete the command BACKUP LOG [EAGLE] TO DISK = N'\
> \Eaglent1\backuponeaglent1\backup\EAGLE LOG BACKUP' WITH NOINIT ,
> NOUNLOAD , NAME = N'EAGLE LOG BACKUP', NOSKIP , STATS = 10,
> DESCRIPTION = N'EAGLE LOG BACKUP', NOFORMAT. I also see this error
> along with it: The backup data in '\\Eaglent1\backuponeaglent1\backup
> \EAGLE LOG BACKUP' is incorrectly formatted. Backups cannot be
> appended, but existing backup sets may still be usable.
> What do I need to change to get this backup completed?
> Joanne Mahoney
> SDN Consultants
> Jacksonville, FL
>|||Sorry for my ignorance, but what do you mean by that? Where should I
look? BTW, this is sql 2000
Joanne
On Sep 21, 3:17 pm, "Quentin Ran" <remove_qr...@.yahoo.com> wrote:
> My guess is that your file EAGLE LOG BACKUP already exists, and it is not a
> sql backup file, and you are appending to it.
> If so, taking out any one of those, you should be good.
> Quentin
> "Joanne M." <joanne.e.maho...@.gmail.com> wrote in message
> news:1190401872.060395.60460@.w3g2000hsg.googlegroups.com...
>
> >I got an error with a back up maintenance plan: BACKUP failed to
> > complete the command BACKUP LOG [EAGLE] TO DISK = N'\
> > \Eaglent1\backuponeaglent1\backup\EAGLE LOG BACKUP' WITH NOINIT ,
> > NOUNLOAD , NAME = N'EAGLE LOG BACKUP', NOSKIP , STATS = 10,
> > DESCRIPTION = N'EAGLE LOG BACKUP', NOFORMAT. I also see this error
> > along with it: The backup data in '\\Eaglent1\backuponeaglent1\backup
> > \EAGLE LOG BACKUP' is incorrectly formatted. Backups cannot be
> > appended, but existing backup sets may still be usable.
> > What do I need to change to get this backup completed?
> > Joanne Mahoney
> > SDN Consultants
> > Jacksonville, FL- Hide quoted text -
> - Show quoted text -|||The most simple: if the file is not important (or copy it to somewhere if it
is), delete it and then try again.
"Joanne M." <joanne.e.mahoney@.gmail.com> wrote in message
news:1190402838.559703.52750@.y42g2000hsy.googlegroups.com...
> Sorry for my ignorance, but what do you mean by that? Where should I
> look? BTW, this is sql 2000
> Joanne
>
> On Sep 21, 3:17 pm, "Quentin Ran" <remove_qr...@.yahoo.com> wrote:
>> My guess is that your file EAGLE LOG BACKUP already exists, and it is not
>> a
>> sql backup file, and you are appending to it.
>> If so, taking out any one of those, you should be good.
>> Quentin
>> "Joanne M." <joanne.e.maho...@.gmail.com> wrote in message
>> news:1190401872.060395.60460@.w3g2000hsg.googlegroups.com...
>>
>> >I got an error with a back up maintenance plan: BACKUP failed to
>> > complete the command BACKUP LOG [EAGLE] TO DISK = N'\
>> > \Eaglent1\backuponeaglent1\backup\EAGLE LOG BACKUP' WITH NOINIT ,
>> > NOUNLOAD , NAME = N'EAGLE LOG BACKUP', NOSKIP , STATS = 10,
>> > DESCRIPTION = N'EAGLE LOG BACKUP', NOFORMAT. I also see this error
>> > along with it: The backup data in '\\Eaglent1\backuponeaglent1\backup
>> > \EAGLE LOG BACKUP' is incorrectly formatted. Backups cannot be
>> > appended, but existing backup sets may still be usable.
>> > What do I need to change to get this backup completed?
>> > Joanne Mahoney
>> > SDN Consultants
>> > Jacksonville, FL- Hide quoted text -
>> - Show quoted text -
>

Backup error

Hi all!
I take backup of a database every night using
"BACKUP DATABASE [Db1] TO DISK = N'\\server\e$\Backup\Databases\Db1\Db1.bak' WITH INIT , NOUNLOAD , NAME = N'Db1 backup', NOSKIP , STATS = 10, NOFORMAT"
But some nights a have recived the following error message when I view the job history.
"'\\server\e$\Backup\Db1\Db1\Db1.bak' is incorrectly formatted. Backups cannot be appended, but existing backup sets may still be usable. [SQLSTATE 42000] (Error 3266) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed."
I have tried to delete the backup devices and created new ones. I am backing up close to twenty databases to the same folder every night. But I get error on a couple backup jobs every night, not the same ones every night. I have tride to run the jobs manually daytime and sometimes they run ok and sometimes they fails.
I have read the MS KB 290787 but i'm not sure if it answers my question. Does anybody has any more info/help/hints it would be greatly appriciated.
Thansk
FredrikSounds like you may have some disk issues. Have you checked the integrity
of that disk lately?
--
Andrew J. Kelly SQL MVP
"Fredrik" <Fredrik@.discussions.microsoft.com> wrote in message
news:46FACB20-2670-41DD-9452-CE9753680453@.microsoft.com...
> Hi all!
> I take backup of a database every night using
> "BACKUP DATABASE [Db1] TO DISK =N'\\server\e$\Backup\Databases\Db1\Db1.bak' WITH INIT , NOUNLOAD , NAME =N'Db1 backup', NOSKIP , STATS = 10, NOFORMAT"
> But some nights a have recived the following error message when I view the
job history.
> "'\\server\e$\Backup\Db1\Db1\Db1.bak' is incorrectly formatted. Backups
cannot be appended, but existing backup sets may still be usable. [SQLSTATE
42000] (Error 3266) BACKUP DATABASE is terminating abnormally. [SQLSTATE
42000] (Error 3013). The step failed."
> I have tried to delete the backup devices and created new ones. I am
backing up close to twenty databases to the same folder every night. But I
get error on a couple backup jobs every night, not the same ones every
night. I have tride to run the jobs manually daytime and sometimes they run
ok and sometimes they fails.
> I have read the MS KB 290787 but i'm not sure if it answers my question.
Does anybody has any more info/help/hints it would be greatly appriciated.
> Thansk
> Fredrik|||sounds like a hard drive issue (?) also is this device
mirrored?
Kevin
>--Original Message--
>Hi all!
>I take backup of a database every night using
>"BACKUP DATABASE [Db1] TO DISK =N'\\server\e$\Backup\Databases\Db1\Db1.bak' WITH INIT ,
NOUNLOAD , NAME = N'Db1 backup', NOSKIP , STATS = 10,
NOFORMAT"
>But some nights a have recived the following error
message when I view the job history.
>"'\\server\e$\Backup\Db1\Db1\Db1.bak' is incorrectly
formatted. Backups cannot be appended, but existing backup
sets may still be usable. [SQLSTATE 42000] (Error 3266)
BACKUP DATABASE is terminating abnormally. [SQLSTATE
42000] (Error 3013). The step failed."
>I have tried to delete the backup devices and created new
ones. I am backing up close to twenty databases to the
same folder every night. But I get error on a couple
backup jobs every night, not the same ones every night. I
have tride to run the jobs manually daytime and sometimes
they run ok and sometimes they fails.
>I have read the MS KB 290787 but i'm not sure if it
answers my question. Does anybody has any more
info/help/hints it would be greatly appriciated.
>Thansk
>Fredrik
>.
>|||Hi Fredrik
I have a similar problem and was able to fix it, quick and simple.
I renamed the backup and log file
and re ran my backup job, it obviously was unable to append as the file was not fould (due to name change), this created new file
and the backup job suceeded.
Note before all this I manually backed up DB (FULL) and Log file (for each db that I had the problem for) Just in case :)
For completness my exact error was
Executed as user: [USER NAME]. The backup data in '[DB NAME]' is incorrectly formatted. Backups cannot be appended, but existing backup sets may still be usable. [SQLSTATE 42000] (Error 3266) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
obviously i was able to delete all non required excess backup files after a few days as I was happy with my backups
Good Luck
Eoin B
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.

Backup error

Hi all!
I take backup of a database every night using
"BACKUP DATABASE [Db1] TO DISK = N'\\server\e$\Backup\Databases\Db1\Db1.bak' WITH INIT , NOUNLOAD , NAME = N'Db1 backup', NOSKIP , STATS = 10, NOFORMAT"
But some nights a have recived the following error message when I view the job history.
"'\\server\e$\Backup\Db1\Db1\Db1.bak' is incorrectly formatted. Backups cannot be appended, but existing backup sets may still be usable. [SQLSTATE 42000] (Error 3266) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step fa
iled."
I have tried to delete the backup devices and created new ones. I am backing up close to twenty databases to the same folder every night. But I get error on a couple backup jobs every night, not the same ones every night. I have tride to run the jobs manu
ally daytime and sometimes they run ok and sometimes they fails.
I have read the MS KB 290787 but i'm not sure if it answers my question. Does anybody has any more info/help/hints it would be greatly appriciated.
Thansk
Fredrik
Sounds like you may have some disk issues. Have you checked the integrity
of that disk lately?
Andrew J. Kelly SQL MVP
"Fredrik" <Fredrik@.discussions.microsoft.com> wrote in message
news:46FACB20-2670-41DD-9452-CE9753680453@.microsoft.com...
> Hi all!
> I take backup of a database every night using
> "BACKUP DATABASE [Db1] TO DISK =
N'\\server\e$\Backup\Databases\Db1\Db1.bak' WITH INIT , NOUNLOAD , NAME =
N'Db1 backup', NOSKIP , STATS = 10, NOFORMAT"
> But some nights a have recived the following error message when I view the
job history.
> "'\\server\e$\Backup\Db1\Db1\Db1.bak' is incorrectly formatted. Backups
cannot be appended, but existing backup sets may still be usable. [SQLSTATE
42000] (Error 3266) BACKUP DATABASE is terminating abnormally. [SQLSTATE
42000] (Error 3013). The step failed."
> I have tried to delete the backup devices and created new ones. I am
backing up close to twenty databases to the same folder every night. But I
get error on a couple backup jobs every night, not the same ones every
night. I have tride to run the jobs manually daytime and sometimes they run
ok and sometimes they fails.
> I have read the MS KB 290787 but i'm not sure if it answers my question.
Does anybody has any more info/help/hints it would be greatly appriciated.
> Thansk
> Fredrik
|||Hi Fredrik
I have a similar problem and was able to fix it, quick and simple.
I renamed the backup and log file
and re ran my backup job, it obviously was unable to append as the file was not fould (due to name change), this created new file
and the backup job suceeded.
Note before all this I manually backed up DB (FULL) and Log file (for each db that I had the problem for) Just in case
For completness my exact error was
Executed as user: [USER NAME]. The backup data in '[DB NAME]' is incorrectly formatted. Backups cannot be appended, but existing backup sets may still be usable. [SQLSTATE 42000] (Error 3266) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (E
rror 3013). The step failed.
obviously i was able to delete all non required excess backup files after a few days as I was happy with my backups
Good Luck
Eoin B
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
sql

Backup error

Hi all!
I take backup of a database every night using
"BACKUP DATABASE [Db1] TO DISK = N'\\server\e$\Backup\Databases\Db1\Db1
.bak' WITH INIT , NOUNLOAD , NAME = N'Db1 backup', NOSKIP , STATS = 10,
NOFORMAT"
But some nights a have recived the following error message when I view the j
ob history.
"'\\server\e$\Backup\Db1\Db1\Db1.bak' is incorrectly formatted. Backups cann
ot be appended, but existing backup sets may still be usable. [SQLSTATE
42000] (Error 3266) BACKUP DATABASE is terminating abnormally. [SQLSTAT
E 42000] (Error 3013). The step fa
iled."
I have tried to delete the backup devices and created new ones. I am backing
up close to twenty databases to the same folder every night. But I get erro
r on a couple backup jobs every night, not the same ones every night. I have
tride to run the jobs manu
ally daytime and sometimes they run ok and sometimes they fails.
I have read the MS KB 290787 but i'm not sure if it answers my question. Doe
s anybody has any more info/help/hints it would be greatly appriciated.
Thansk
FredrikSounds like you may have some disk issues. Have you checked the integrity
of that disk lately?
Andrew J. Kelly SQL MVP
"Fredrik" <Fredrik@.discussions.microsoft.com> wrote in message
news:46FACB20-2670-41DD-9452-CE9753680453@.microsoft.com...
> Hi all!
> I take backup of a database every night using
> "BACKUP DATABASE [Db1] TO DISK =
N'\\server\e$\Backup\Databases\Db1\Db1.bak' WITH INIT , NOUNLOAD , NAME =
N'Db1 backup', NOSKIP , STATS = 10, NOFORMAT"
> But some nights a have recived the following error message when I view the
job history.
> "'\\server\e$\Backup\Db1\Db1\Db1.bak' is incorrectly formatted. Backups
cannot be appended, but existing backup sets may still be usable. [SQLST
ATE
42000] (Error 3266) BACKUP DATABASE is terminating abnormally. [SQLSTAT
E
42000] (Error 3013). The step failed."
> I have tried to delete the backup devices and created new ones. I am
backing up close to twenty databases to the same folder every night. But I
get error on a couple backup jobs every night, not the same ones every
night. I have tride to run the jobs manually daytime and sometimes they run
ok and sometimes they fails.
> I have read the MS KB 290787 but i'm not sure if it answers my question.
Does anybody has any more info/help/hints it would be greatly appriciated.
> Thansk
> Fredrik|||Hi Fredrik
I have a similar problem and was able to fix it, quick and simple.
I renamed the backup and log file
and re ran my backup job, it obviously was unable to append as the file was
not fould (due to name change), this created new file
and the backup job suceeded.
Note before all this I manually backed up DB (FULL) and Log file (for each d
b that I had the problem for) Just in case
For completness my exact error was
Executed as user: [USER NAME]. The backup data in '[DB NAME]' is inc
orrectly formatted. Backups cannot be appended, but existing backup sets may
still be usable. [SQLSTATE 42000] (Error 3266) BACKUP DATABASE is term
inating abnormally. [SQLSTATE 42000] (E
rror 3013). The step failed.
obviously i was able to delete all non required excess backup files after a
few days as I was happy with my backups
Good Luck
Eoin B
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.sql

backup devices

hey all,
i'm trying to do a full backup on my database. there is a disk device
currently assigned to do a differential backup on the db. how do i get my
backup without messing up the current device. because there have been a
couple of times where i ran the backup using osq and it still ended up
changing the device and i didn't want it to do that.
thanks,
rodchar
Hi,
Use Maintenance Plan in Enterprise manager / SQL Server Management Studio to
do the full database backup. This will automatically create file names based
on Database name
and date and time stamp. Maintenance plan have an option of archival
also...s
Thanks
Hari
"rodchar" <rodchar@.discussions.microsoft.com> wrote in message
news:2DC3B373-0006-4C19-BECC-A277913BC48D@.microsoft.com...
> hey all,
> i'm trying to do a full backup on my database. there is a disk device
> currently assigned to do a differential backup on the db. how do i get my
> backup without messing up the current device. because there have been a
> couple of times where i ran the backup using osq and it still ended up
> changing the device and i didn't want it to do that.
> thanks,
> rodchar
>
|||thank you for your help. rod.
"Hari Prasad" wrote:

> Hi,
> Use Maintenance Plan in Enterprise manager / SQL Server Management Studio to
> do the full database backup. This will automatically create file names based
> on Database name
> and date and time stamp. Maintenance plan have an option of archival
> also...s
> Thanks
> Hari
> "rodchar" <rodchar@.discussions.microsoft.com> wrote in message
> news:2DC3B373-0006-4C19-BECC-A277913BC48D@.microsoft.com...
>
>
sql

backup devices

hey all,
i'm trying to do a full backup on my database. there is a disk device
currently assigned to do a differential backup on the db. how do i get my
backup without messing up the current device. because there have been a
couple of times where i ran the backup using osq and it still ended up
changing the device and i didn't want it to do that.
thanks,
rodcharHi,
Use Maintenance Plan in Enterprise manager / SQL Server Management Studio to
do the full database backup. This will automatically create file names based
on Database name
and date and time stamp. Maintenance plan have an option of archival
also...s
Thanks
Hari
"rodchar" <rodchar@.discussions.microsoft.com> wrote in message
news:2DC3B373-0006-4C19-BECC-A277913BC48D@.microsoft.com...
> hey all,
> i'm trying to do a full backup on my database. there is a disk device
> currently assigned to do a differential backup on the db. how do i get my
> backup without messing up the current device. because there have been a
> couple of times where i ran the backup using osq and it still ended up
> changing the device and i didn't want it to do that.
> thanks,
> rodchar
>|||thank you for your help. rod.
"Hari Prasad" wrote:
> Hi,
> Use Maintenance Plan in Enterprise manager / SQL Server Management Studio to
> do the full database backup. This will automatically create file names based
> on Database name
> and date and time stamp. Maintenance plan have an option of archival
> also...s
> Thanks
> Hari
> "rodchar" <rodchar@.discussions.microsoft.com> wrote in message
> news:2DC3B373-0006-4C19-BECC-A277913BC48D@.microsoft.com...
> > hey all,
> > i'm trying to do a full backup on my database. there is a disk device
> > currently assigned to do a differential backup on the db. how do i get my
> > backup without messing up the current device. because there have been a
> > couple of times where i ran the backup using osq and it still ended up
> > changing the device and i didn't want it to do that.
> >
> > thanks,
> > rodchar
> >
>
>

backup devices

hey all,
i'm trying to do a full backup on my database. there is a disk device
currently assigned to do a differential backup on the db. how do i get my
backup without messing up the current device. because there have been a
couple of times where i ran the backup using osq and it still ended up
changing the device and i didn't want it to do that.
thanks,
rodcharHi,
Use Maintenance Plan in Enterprise manager / SQL Server Management Studio to
do the full database backup. This will automatically create file names based
on Database name
and date and time stamp. Maintenance plan have an option of archival
also...s
Thanks
Hari
"rodchar" <rodchar@.discussions.microsoft.com> wrote in message
news:2DC3B373-0006-4C19-BECC-A277913BC48D@.microsoft.com...
> hey all,
> i'm trying to do a full backup on my database. there is a disk device
> currently assigned to do a differential backup on the db. how do i get my
> backup without messing up the current device. because there have been a
> couple of times where i ran the backup using osq and it still ended up
> changing the device and i didn't want it to do that.
> thanks,
> rodchar
>|||thank you for your help. rod.
"Hari Prasad" wrote:

> Hi,
> Use Maintenance Plan in Enterprise manager / SQL Server Management Studio
to
> do the full database backup. This will automatically create file names bas
ed
> on Database name
> and date and time stamp. Maintenance plan have an option of archival
> also...s
> Thanks
> Hari
> "rodchar" <rodchar@.discussions.microsoft.com> wrote in message
> news:2DC3B373-0006-4C19-BECC-A277913BC48D@.microsoft.com...
>
>

Backup Device

I am trying to add a backup device to SQL that will use our NAS. When I enter
the UNC \\ProCom-SERVER\BACKUP\DISK.BAK for the file location I get a message
that SQL Server can not verify the existenance of the backup file location.
The path \\PROCOM-SERVER\BACKUP exist and I use it for other backup files.
The SQL Server is a stand alone server and is not a member of a domain and
neither is the NAS, this is in a peer to peer workgroup network. I have
applied service pack 4 as well.
Any help will be appreciated.
Does the account that SQL Server is running under have rights to that share
on the NAS?
Andrew J. Kelly SQL MVP
"ProCom" <ProCom@.discussions.microsoft.com> wrote in message
news:5FB2ABE4-6012-46AF-910C-C375DA6D6ABA@.microsoft.com...
>I am trying to add a backup device to SQL that will use our NAS. When I
>enter
> the UNC \\ProCom-SERVER\BACKUP\DISK.BAK for the file location I get a
> message
> that SQL Server can not verify the existenance of the backup file
> location.
> The path \\PROCOM-SERVER\BACKUP exist and I use it for other backup files.
> The SQL Server is a stand alone server and is not a member of a domain and
> neither is the NAS, this is in a peer to peer workgroup network. I have
> applied service pack 4 as well.
>
> Any help will be appreciated.
>

Backup Device

I am trying to add a backup device to SQL that will use our NAS. When I ente
r
the UNC \\ProCom-SERVER\BACKUP\DISK.BAK for the file location I get a messag
e
that SQL Server can not verify the existenance of the backup file location.
The path \\PROCOM-SERVER\BACKUP exist and I use it for other backup files.
The SQL Server is a stand alone server and is not a member of a domain and
neither is the NAS, this is in a peer to peer workgroup network. I have
applied service pack 4 as well.
Any help will be appreciated.Does the account that SQL Server is running under have rights to that share
on the NAS?
Andrew J. Kelly SQL MVP
"ProCom" <ProCom@.discussions.microsoft.com> wrote in message
news:5FB2ABE4-6012-46AF-910C-C375DA6D6ABA@.microsoft.com...
>I am trying to add a backup device to SQL that will use our NAS. When I
>enter
> the UNC \\ProCom-SERVER\BACKUP\DISK.BAK for the file location I get a
> message
> that SQL Server can not verify the existenance of the backup file
> location.
> The path \\PROCOM-SERVER\BACKUP exist and I use it for other backup files.
> The SQL Server is a stand alone server and is not a member of a domain and
> neither is the NAS, this is in a peer to peer workgroup network. I have
> applied service pack 4 as well.
>
> Any help will be appreciated.
>

Backup Device

I am trying to add a backup device to SQL that will use our NAS. When I enter
the UNC \\ProCom-SERVER\BACKUP\DISK.BAK for the file location I get a message
that SQL Server can not verify the existenance of the backup file location.
The path \\PROCOM-SERVER\BACKUP exist and I use it for other backup files.
The SQL Server is a stand alone server and is not a member of a domain and
neither is the NAS, this is in a peer to peer workgroup network. I have
applied service pack 4 as well.
Any help will be appreciated.Does the account that SQL Server is running under have rights to that share
on the NAS?
--
Andrew J. Kelly SQL MVP
"ProCom" <ProCom@.discussions.microsoft.com> wrote in message
news:5FB2ABE4-6012-46AF-910C-C375DA6D6ABA@.microsoft.com...
>I am trying to add a backup device to SQL that will use our NAS. When I
>enter
> the UNC \\ProCom-SERVER\BACKUP\DISK.BAK for the file location I get a
> message
> that SQL Server can not verify the existenance of the backup file
> location.
> The path \\PROCOM-SERVER\BACKUP exist and I use it for other backup files.
> The SQL Server is a stand alone server and is not a member of a domain and
> neither is the NAS, this is in a peer to peer workgroup network. I have
> applied service pack 4 as well.
>
> Any help will be appreciated.
>

Backup DB to File WITH INIT?

I am using:
BACKUP DATABASE XXX TO DISK = @.MyFile
-- If @.MyFile exists, i want to overwrite it. The help file says "Use
the INIT clause to overwrite the backup media, and write the backup as
the first file ... ". This sounds like it will clean-up my entire D-
Drive and then do the backup. It should simply overwrite the specific
file @.MyFile if it exists. I just want to be a 100% sure before I run
this command.
Thanks,
Jay
WITH INIT = delete all the backups in your backup device, which is the .BAK
file you specified. This means, everytime you backup, you only have the
backup from the last time the backup command executed.
"Jay" <jay6447@.hotmail.com> wrote in message
news:1183609141.844241.152410@.d30g2000prg.googlegr oups.com...
> I am using:
> BACKUP DATABASE XXX TO DISK = @.MyFile
> -- If @.MyFile exists, i want to overwrite it. The help file says "Use
> the INIT clause to overwrite the backup media, and write the backup as
> the first file ... ". This sounds like it will clean-up my entire D-
> Drive and then do the backup. It should simply overwrite the specific
> file @.MyFile if it exists. I just want to be a 100% sure before I run
> this command.
> Thanks,
> Jay
>
|||Jay
It will NOT clean your entire drive. Think about it, as if you backup
database on C:\ drive BACKUP DATABASE commnad would destroy the OS ?
BOL says
INIT
Specifies that all backup sets should be overwritten, but preserves the
media header. If INIT is specified, any existing backup set data on that
device is overwritten.
"Jay" <jay6447@.hotmail.com> wrote in message
news:1183609141.844241.152410@.d30g2000prg.googlegr oups.com...
> I am using:
> BACKUP DATABASE XXX TO DISK = @.MyFile
> -- If @.MyFile exists, i want to overwrite it. The help file says "Use
> the INIT clause to overwrite the backup media, and write the backup as
> the first file ... ". This sounds like it will clean-up my entire D-
> Drive and then do the backup. It should simply overwrite the specific
> file @.MyFile if it exists. I just want to be a 100% sure before I run
> this command.
> Thanks,
> Jay
>
|||OK, does this mean that if I have older backup files like
(MYDB_20061231.bak, MYDB_20070101.bak....) they all will be deleted?
On Jul 5, 10:18 am, "Uri Dimant" <u...@.iscar.co.il> wrote:
> Jay
> It will NOT clean your entire drive. Think about it, as if you backup
> database on C:\ drive BACKUP DATABASE commnad would destroy the OS ?
> BOL says
> INIT
> Specifies that all backup sets should be overwritten, but preserves the
> media header. If INIT is specified, any existing backup set data on that
> device is overwritten.
> "Jay" <jay6...@.hotmail.com> wrote in message
> news:1183609141.844241.152410@.d30g2000prg.googlegr oups.com...
>
>
>
>
> - Show quoted text -
|||Jay
if MYDB_20061231.bak contains more than one file and you issue BACKUP
DATABASE db to disk='c:\MYDB_20061231.bak' WITH INIT so YES it will be
overwritten
"Jay" <jay6447@.hotmail.com> wrote in message
news:1183614106.316025.235930@.j4g2000prf.googlegro ups.com...
> OK, does this mean that if I have older backup files like
> (MYDB_20061231.bak, MYDB_20070101.bak....) they all will be deleted?
>
> On Jul 5, 10:18 am, "Uri Dimant" <u...@.iscar.co.il> wrote:
>
|||OK - thanks. I got it. I didn't know a backup file can contain more
than one backups.
On Jul 5, 10:58 am, "Uri Dimant" <u...@.iscar.co.il> wrote:
> Jay
> if MYDB_20061231.bak contains more than one file and you issue BACKUP
> DATABASE db to disk='c:\MYDB_20061231.bak' WITH INIT so YES it will be
> overwritten
> "Jay" <jay6...@.hotmail.com> wrote in message
> news:1183614106.316025.235930@.j4g2000prf.googlegro ups.com...
>
>
>
>
>
>
> - Show quoted text -

Backup DB to File WITH INIT?

I am using:
BACKUP DATABASE XXX TO DISK = @.MyFile
-- If @.MyFile exists, i want to overwrite it. The help file says "Use
the INIT clause to overwrite the backup media, and write the backup as
the first file ... ". This sounds like it will clean-up my entire D-
Drive and then do the backup. It should simply overwrite the specific
file @.MyFile if it exists. I just want to be a 100% sure before I run
this command.
Thanks,
JayWITH INIT = delete all the backups in your backup device, which is the .BAK
file you specified. This means, everytime you backup, you only have the
backup from the last time the backup command executed.
"Jay" <jay6447@.hotmail.com> wrote in message
news:1183609141.844241.152410@.d30g2000prg.googlegroups.com...
> I am using:
> BACKUP DATABASE XXX TO DISK = @.MyFile
> -- If @.MyFile exists, i want to overwrite it. The help file says "Use
> the INIT clause to overwrite the backup media, and write the backup as
> the first file ... ". This sounds like it will clean-up my entire D-
> Drive and then do the backup. It should simply overwrite the specific
> file @.MyFile if it exists. I just want to be a 100% sure before I run
> this command.
> Thanks,
> Jay
>|||Jay
It will NOT clean your entire drive. Think about it, as if you backup
database on C:\ drive BACKUP DATABASE commnad would destroy the OS ?
BOL says
INIT
Specifies that all backup sets should be overwritten, but preserves the
media header. If INIT is specified, any existing backup set data on that
device is overwritten.
"Jay" <jay6447@.hotmail.com> wrote in message
news:1183609141.844241.152410@.d30g2000prg.googlegroups.com...
> I am using:
> BACKUP DATABASE XXX TO DISK = @.MyFile
> -- If @.MyFile exists, i want to overwrite it. The help file says "Use
> the INIT clause to overwrite the backup media, and write the backup as
> the first file ... ". This sounds like it will clean-up my entire D-
> Drive and then do the backup. It should simply overwrite the specific
> file @.MyFile if it exists. I just want to be a 100% sure before I run
> this command.
> Thanks,
> Jay
>|||OK, does this mean that if I have older backup files like
(MYDB_20061231.bak, MYDB_20070101.bak....) they all will be deleted?
On Jul 5, 10:18 am, "Uri Dimant" <u...@.iscar.co.il> wrote:
> Jay
> It will NOT clean your entire drive. Think about it, as if you backup
> database on C:\ drive BACKUP DATABASE commnad would destroy the OS ?
> BOL says
> INIT
> Specifies that all backup sets should be overwritten, but preserves the
> media header. If INIT is specified, any existing backup set data on that
> device is overwritten.
> "Jay" <jay6...@.hotmail.com> wrote in message
> news:1183609141.844241.152410@.d30g2000prg.googlegroups.com...
>
>
> > I am using:
> > BACKUP DATABASE XXX TO DISK = @.MyFile
> > -- If @.MyFile exists, i want to overwrite it. The help file says "Use
> > the INIT clause to overwrite the backup media, and write the backup as
> > the first file ... ". This sounds like it will clean-up my entire D-
> > Drive and then do the backup. It should simply overwrite the specific
> > file @.MyFile if it exists. I just want to be a 100% sure before I run
> > this command.
> > Thanks,
> > Jay- Hide quoted text -
> - Show quoted text -|||Jay
if MYDB_20061231.bak contains more than one file and you issue BACKUP
DATABASE db to disk='c:\MYDB_20061231.bak' WITH INIT so YES it will be
overwritten
"Jay" <jay6447@.hotmail.com> wrote in message
news:1183614106.316025.235930@.j4g2000prf.googlegroups.com...
> OK, does this mean that if I have older backup files like
> (MYDB_20061231.bak, MYDB_20070101.bak....) they all will be deleted?
>
> On Jul 5, 10:18 am, "Uri Dimant" <u...@.iscar.co.il> wrote:
>> Jay
>> It will NOT clean your entire drive. Think about it, as if you backup
>> database on C:\ drive BACKUP DATABASE commnad would destroy the OS ?
>> BOL says
>> INIT
>> Specifies that all backup sets should be overwritten, but preserves the
>> media header. If INIT is specified, any existing backup set data on that
>> device is overwritten.
>> "Jay" <jay6...@.hotmail.com> wrote in message
>> news:1183609141.844241.152410@.d30g2000prg.googlegroups.com...
>>
>>
>> > I am using:
>> > BACKUP DATABASE XXX TO DISK = @.MyFile
>> > -- If @.MyFile exists, i want to overwrite it. The help file says "Use
>> > the INIT clause to overwrite the backup media, and write the backup as
>> > the first file ... ". This sounds like it will clean-up my entire D-
>> > Drive and then do the backup. It should simply overwrite the specific
>> > file @.MyFile if it exists. I just want to be a 100% sure before I run
>> > this command.
>> > Thanks,
>> > Jay- Hide quoted text -
>> - Show quoted text -
>|||OK - thanks. I got it. I didn't know a backup file can contain more
than one backups.
On Jul 5, 10:58 am, "Uri Dimant" <u...@.iscar.co.il> wrote:
> Jay
> if MYDB_20061231.bak contains more than one file and you issue BACKUP
> DATABASE db to disk='c:\MYDB_20061231.bak' WITH INIT so YES it will be
> overwritten
> "Jay" <jay6...@.hotmail.com> wrote in message
> news:1183614106.316025.235930@.j4g2000prf.googlegroups.com...
>
> > OK, does this mean that if I have older backup files like
> > (MYDB_20061231.bak, MYDB_20070101.bak....) they all will be deleted?
> > On Jul 5, 10:18 am, "Uri Dimant" <u...@.iscar.co.il> wrote:
> >> Jay
> >> It will NOT clean your entire drive. Think about it, as if you backup
> >> database on C:\ drive BACKUP DATABASE commnad would destroy the OS ?
> >> BOL says
> >> INIT
> >> Specifies that all backup sets should be overwritten, but preserves the
> >> media header. If INIT is specified, any existing backup set data on that
> >> device is overwritten.
> >> "Jay" <jay6...@.hotmail.com> wrote in message
> >>news:1183609141.844241.152410@.d30g2000prg.googlegroups.com...
> >> > I am using:
> >> > BACKUP DATABASE XXX TO DISK = @.MyFile
> >> > -- If @.MyFile exists, i want to overwrite it. The help file says "Use
> >> > the INIT clause to overwrite the backup media, and write the backup as
> >> > the first file ... ". This sounds like it will clean-up my entire D-
> >> > Drive and then do the backup. It should simply overwrite the specific
> >> > file @.MyFile if it exists. I just want to be a 100% sure before I run
> >> > this command.
> >> > Thanks,
> >> > Jay- Hide quoted text -
> >> - Show quoted text -- Hide quoted text -
> - Show quoted text -

Backup DB to File WITH INIT?

I am using:
BACKUP DATABASE XXX TO DISK = @.MyFile
-- If @.MyFile exists, i want to overwrite it. The help file says "Use
the INIT clause to overwrite the backup media, and write the backup as
the first file ... ". This sounds like it will clean-up my entire D-
Drive and then do the backup. It should simply overwrite the specific
file @.MyFile if it exists. I just want to be a 100% sure before I run
this command.
Thanks,
JayWITH INIT = delete all the backups in your backup device, which is the .BAK
file you specified. This means, everytime you backup, you only have the
backup from the last time the backup command executed.
"Jay" <jay6447@.hotmail.com> wrote in message
news:1183609141.844241.152410@.d30g2000prg.googlegroups.com...
> I am using:
> BACKUP DATABASE XXX TO DISK = @.MyFile
> -- If @.MyFile exists, i want to overwrite it. The help file says "Use
> the INIT clause to overwrite the backup media, and write the backup as
> the first file ... ". This sounds like it will clean-up my entire D-
> Drive and then do the backup. It should simply overwrite the specific
> file @.MyFile if it exists. I just want to be a 100% sure before I run
> this command.
> Thanks,
> Jay
>|||Jay
It will NOT clean your entire drive. Think about it, as if you backup
database on C:\ drive BACKUP DATABASE commnad would destroy the OS ?
BOL says
INIT
Specifies that all backup sets should be overwritten, but preserves the
media header. If INIT is specified, any existing backup set data on that
device is overwritten.
"Jay" <jay6447@.hotmail.com> wrote in message
news:1183609141.844241.152410@.d30g2000prg.googlegroups.com...
> I am using:
> BACKUP DATABASE XXX TO DISK = @.MyFile
> -- If @.MyFile exists, i want to overwrite it. The help file says "Use
> the INIT clause to overwrite the backup media, and write the backup as
> the first file ... ". This sounds like it will clean-up my entire D-
> Drive and then do the backup. It should simply overwrite the specific
> file @.MyFile if it exists. I just want to be a 100% sure before I run
> this command.
> Thanks,
> Jay
>|||OK, does this mean that if I have older backup files like
(MYDB_20061231.bak, MYDB_20070101.bak....) they all will be deleted?
On Jul 5, 10:18 am, "Uri Dimant" <u...@.iscar.co.il> wrote:
> Jay
> It will NOT clean your entire drive. Think about it, as if you backup
> database on C:\ drive BACKUP DATABASE commnad would destroy the OS ?
> BOL says
> INIT
> Specifies that all backup sets should be overwritten, but preserves the
> media header. If INIT is specified, any existing backup set data on that
> device is overwritten.
> "Jay" <jay6...@.hotmail.com> wrote in message
> news:1183609141.844241.152410@.d30g2000prg.googlegroups.com...
>
>
>
>
>
>
> - Show quoted text -|||Jay
if MYDB_20061231.bak contains more than one file and you issue BACKUP
DATABASE db to disk='c:\MYDB_20061231.bak' WITH INIT so YES it will be
overwritten
"Jay" <jay6447@.hotmail.com> wrote in message
news:1183614106.316025.235930@.j4g2000prf.googlegroups.com...
> OK, does this mean that if I have older backup files like
> (MYDB_20061231.bak, MYDB_20070101.bak....) they all will be deleted?
>
> On Jul 5, 10:18 am, "Uri Dimant" <u...@.iscar.co.il> wrote:
>|||OK - thanks. I got it. I didn't know a backup file can contain more
than one backups.
On Jul 5, 10:58 am, "Uri Dimant" <u...@.iscar.co.il> wrote:
> Jay
> if MYDB_20061231.bak contains more than one file and you issue BACKUP
> DATABASE db to disk='c:\MYDB_20061231.bak' WITH INIT so YES it will be
> overwritten
> "Jay" <jay6...@.hotmail.com> wrote in message
> news:1183614106.316025.235930@.j4g2000prf.googlegroups.com...
>
>
>
>
>
>
>
>
>
>
> - Show quoted text -sql

backup db

I'm trying to make a backup of a DB with a stored procedure. I call the sp
through an ODBC connection.When the backup is placed on a fixed disk
everything is OK. When a give a removable device as target the backup is
removed at the moment the odbc connection is closed. I need the backup on a
removable device.
How can I fix this?
an option is to make the backup on disk and copy it to the removable device,
but I don't know exactly when the backup is finished. can I add something in
the stored procedure to wait for the completion of the backup.
here is the sp:
CREATE PROCEDURE [dbo].[sp_Backup_DB]
@.path varchar (100)
AS
-- Back up the database.
BACKUP DATABASE PasV2 TO DISK = @.path
GOBert
I'm not sure undestand what are you after, however ,see in the BOL WAITFOR
command
"Bert Okkerse" <bizix@.skynet.be> wrote in message
news:uwpRa$LpGHA.148@.TK2MSFTNGP04.phx.gbl...
> I'm trying to make a backup of a DB with a stored procedure. I call the sp
> through an ODBC connection.When the backup is placed on a fixed disk
> everything is OK. When a give a removable device as target the backup is
> removed at the moment the odbc connection is closed. I need the backup on
> a removable device.
> How can I fix this?
> an option is to make the backup on disk and copy it to the removable
> device, but I don't know exactly when the backup is finished. can I add
> something in the stored procedure to wait for the completion of the
> backup.
> here is the sp:
> CREATE PROCEDURE [dbo].[sp_Backup_DB]
> @.path varchar (100)
> AS
> -- Back up the database.
> BACKUP DATABASE PasV2 TO DISK = @.path
> GO
>|||Hi,
If you want to make a copy of your database on removable media try
sp_create_removable
refer BOL for more info
Amol Lembhe
MCDBA
amol.lembhe@.patni.com
"Bert Okkerse" wrote:
> I'm trying to make a backup of a DB with a stored procedure. I call the sp
> through an ODBC connection.When the backup is placed on a fixed disk
> everything is OK. When a give a removable device as target the backup is
> removed at the moment the odbc connection is closed. I need the backup on a
> removable device.
> How can I fix this?
> an option is to make the backup on disk and copy it to the removable device,
> but I don't know exactly when the backup is finished. can I add something in
> the stored procedure to wait for the completion of the backup.
> here is the sp:
> CREATE PROCEDURE [dbo].[sp_Backup_DB]
> @.path varchar (100)
> AS
> -- Back up the database.
> BACKUP DATABASE PasV2 TO DISK = @.path
> GO
>
>

Backup Database! this is really interesting!

Hi,
I run this in query analyzer
dump database MYDB to disk = 'c:\temp.dat' with init
sql server fails to back up and returns
Server: Msg 3202, Level 16, State 1, Line 1
Write on 'c:\temp.dat' failed, status = 64. See the SQL Server Error Log For
More details.
Server: Msg 3013, Level 16, State 1, Line 1
Backup Database is terminating abnormally
and these are the diagnostics and computer configurations i
performed(computerA):
1. There is 25.5 GB of free space available on C drive.
2. The computer has two RAIDSone SCSI drive. It generates same error on all
of them. This leads me to believe that this is not hardware problem.
3. It generates for all three databases on the server. so not dependent on
database either.
4. Tested on another computer with same hardware but got the databases from
computerA. It fails on that computer too.
5. tested on yet another computer with older versions of the same databases
,(not restored from computerA). It succeeds.
My thoughts are inclined towards virus or sth in the database. but here
comes the kicker. asked the services guy to send me the database backups.
Restored dbs on my machine to the backup copies. It all works fine.
So not the DBs, Not the SQL Server, not the Hardware. what is it?
Or am i totally on the wrong track?
Please someone put some suggestions. I am burning saturday to do this.
A couple things to note. One is that DUMP is the old 6.5 command and you
should be using BACKUP DATABASE instead. But I suspect the error is due to
incorrect permissions but without more details it's hard to say for sure.
Did you check the SQL Error log as it stated? The backup command is always
done under the account SQL Server is running under. So make sure that
account has write permissions on that directory and file. Make sure the file
is not locked by some other application such as a tape backup process.
Andrew J. Kelly SQL MVP
"venAdder" <venAdder@.discussions.microsoft.com> wrote in message
news:F7183062-C942-4B7C-8DD3-A0FAC0228CC8@.microsoft.com...
> Hi,
> I run this in query analyzer
> dump database MYDB to disk = 'c:\temp.dat' with init
> sql server fails to back up and returns
> Server: Msg 3202, Level 16, State 1, Line 1
> Write on 'c:\temp.dat' failed, status = 64. See the SQL Server Error Log
> For
> More details.
> Server: Msg 3013, Level 16, State 1, Line 1
> Backup Database is terminating abnormally
>
> and these are the diagnostics and computer configurations i
> performed(computerA):
> 1. There is 25.5 GB of free space available on C drive.
> 2. The computer has two RAIDSone SCSI drive. It generates same error on
> all
> of them. This leads me to believe that this is not hardware problem.
> 3. It generates for all three databases on the server. so not dependent on
> database either.
> 4. Tested on another computer with same hardware but got the databases
> from
> computerA. It fails on that computer too.
> 5. tested on yet another computer with older versions of the same
> databases
> ,(not restored from computerA). It succeeds.
> My thoughts are inclined towards virus or sth in the database. but here
> comes the kicker. asked the services guy to send me the database backups.
> Restored dbs on my machine to the backup copies. It all works fine.
> So not the DBs, Not the SQL Server, not the Hardware. what is it?
> Or am i totally on the wrong track?
> Please someone put some suggestions. I am burning saturday to do this.
|||I am sorry c:\temp.dat is wrong.
it is \\myserver\c$\temp.dat
Ok I think I know what the problem is. The path is actually
'\\myserver\c$\temp.dat'. The status = 64 means The specified network name
is no longer available ( ERROR_NETNAME_DELETED ). But the myserver is the
name of the computer on which sql server runs. I mean sql server is installed
on myserver. So it should be same as saying c:\temp.dat.
So the query becomes
dump database MYDB to disk = '\\myserver\c$\temp.dat' with init
But in case of c:\temp.dat it succeeds and in case of \\myserver\c$\temp.dat
it fails ( it used to work, but has been failing recently).
Now i tried following.
1. I am able to access c drive on myserver by typing \\myserver\c$ in
windows explorer from another computer on LAN.
2. I am able to access c drive by typing \\myserver\c$ in the windows
explorer on myserver.
3. ping 127.0.0.1 return normal results on myserver.
So why does windows generates ERROR_NETNAME_DELETED when i run
dump database MYDB to disk = '\\myserver\c$\temp.dat' with init
in query analyzer?
|||If this is duplicate sorry, for some reason i don't see my posts on the forum
Ok I think I know what the problem is. Sorry for the 'c:\temp.dat'. The path
is actually
'\\myserver\c$\temp.dat'. The status = 64 means The specified network name
is no longer available ( ERROR_NETNAME_DELETED ). But the myserver is the
name of the computer on which sql server runs. I mean sql server is installed
on myserver. So it should be same as saying c:\temp.dat.
So the query becomes
dump database MYDB to disk = '\\myserver\c$\temp.dat' with init
But in case of c:\temp.dat it succeeds and in case of \\myserver\c$\temp.dat
it fails ( it used to work, but ahs been failing recently).
Now i tried following.
1. I am able to access c drive on myserver by typing \\myserver\c$ in
windows explorer from another computer on LAN.
2. I am able to access c drive by typing \\myserver\c$ in the windows
explorer on myserver.
3. ping 127.0.0.1 return normal results on myserver.
So why does windows generates ERROR_NETNAME_DELETED when i run
dump database MYDB to disk = '\\myserver\c$\temp.dat' with init
in query analyzer?
|||I think Andrew is correct that it is a permissions issue. It works fine
locally on my machine.
Try this from Query Analyzer:
exec master..xp_cmdshell 'dir \\myserver\c$\temp.dat'
You should see the output of the dir command in the results pane.
Ron
Ron Talmage
SQL Server MVP
"venAdder" <venAdder@.discussions.microsoft.com> wrote in message
news:4AFC6143-1BC2-483C-AB63-DB4AFD398EE6@.microsoft.com...
> If this is duplicate sorry, for some reason i don't see my posts on the
forum
> Ok I think I know what the problem is. Sorry for the 'c:\temp.dat'. The
path
> is actually
> '\\myserver\c$\temp.dat'. The status = 64 means The specified network name
> is no longer available ( ERROR_NETNAME_DELETED ). But the myserver is the
> name of the computer on which sql server runs. I mean sql server is
installed
> on myserver. So it should be same as saying c:\temp.dat.
> So the query becomes
> dump database MYDB to disk = '\\myserver\c$\temp.dat' with init
> But in case of c:\temp.dat it succeeds and in case of
\\myserver\c$\temp.dat
> it fails ( it used to work, but ahs been failing recently).
> Now i tried following.
> 1. I am able to access c drive on myserver by typing \\myserver\c$ in
> windows explorer from another computer on LAN.
> 2. I am able to access c drive by typing \\myserver\c$ in the windows
> explorer on myserver.
> 3. ping 127.0.0.1 return normal results on myserver.
>
> So why does windows generates ERROR_NETNAME_DELETED when i run
> dump database MYDB to disk = '\\myserver\c$\temp.dat' with init
> in query analyzer?
>
|||I still think it is permissions. Log on to the server with the account that
SQL Server is running under and see if you can access that share.
Andrew J. Kelly SQL MVP
"venAdder" <venAdder@.discussions.microsoft.com> wrote in message
news:B3D7FA16-1D79-48BF-8D64-90319A6A9B7C@.microsoft.com...
>I am sorry c:\temp.dat is wrong.
> it is \\myserver\c$\temp.dat
> Ok I think I know what the problem is. The path is actually
> '\\myserver\c$\temp.dat'. The status = 64 means The specified network name
> is no longer available ( ERROR_NETNAME_DELETED ). But the myserver is the
> name of the computer on which sql server runs. I mean sql server is
> installed
> on myserver. So it should be same as saying c:\temp.dat.
> So the query becomes
> dump database MYDB to disk = '\\myserver\c$\temp.dat' with init
> But in case of c:\temp.dat it succeeds and in case of
> \\myserver\c$\temp.dat
> it fails ( it used to work, but has been failing recently).
> Now i tried following.
> 1. I am able to access c drive on myserver by typing \\myserver\c$ in
> windows explorer from another computer on LAN.
> 2. I am able to access c drive by typing \\myserver\c$ in the windows
> explorer on myserver.
> 3. ping 127.0.0.1 return normal results on myserver.
>
> So why does windows generates ERROR_NETNAME_DELETED when i run
> dump database MYDB to disk = '\\myserver\c$\temp.dat' with init
> in query analyzer?
>
>
|||No it's not a permissions issue. The reason is when that query executes i can
see the file in explorer for a few seconds. Then it gets deleted when query
fails. Here is what happened:
The issue turned out to be network redirector cahing related.
The precise article corressponding to this is
http://support.microsoft.com/default...EN-US;q285997.
The reason I am sure this is it because the articles describes that using
c:\ should
be fine, which is actually the case. It works fine if no unc is used. and
the windows reports this failed to write to
\device\lanmanredirector\........... it's exactly the error described in
that article.
the solution to this is here
http://support.microsoft.com/default...b;en-us;163401
Now this article explains how to turn off network redirector disabling in
winnt not in win 2000. I opened win registry. The keys are diff.
does anyone know how to do the same thing in win2000professional?
and also it's still a mystry what could ahve caused this problem on that
particular computer. The file size might be one of the causes, but I don't
think so because I have tried on computers configured in exactly the same
way(hardware and software) with much larger files and it all works fine.
|||Make sure your WORKSTATION has the Server Service and the RPC Service
running.
Sincerely,
Anthony Thomas

"venAdder" <venAdder@.discussions.microsoft.com> wrote in message
news:057130BB-486B-4092-AED3-5B24680AD800@.microsoft.com...
No it's not a permissions issue. The reason is when that query executes i
can
see the file in explorer for a few seconds. Then it gets deleted when query
fails. Here is what happened:
The issue turned out to be network redirector cahing related.
The precise article corressponding to this is
http://support.microsoft.com/default...EN-US;q285997.
The reason I am sure this is it because the articles describes that using
c:\ should
be fine, which is actually the case. It works fine if no unc is used. and
the windows reports this failed to write to
\device\lanmanredirector\........... it's exactly the error described in
that article.
the solution to this is here
http://support.microsoft.com/default...b;en-us;163401
Now this article explains how to turn off network redirector disabling in
winnt not in win 2000. I opened win registry. The keys are diff.
does anyone know how to do the same thing in win2000professional?
and also it's still a mystry what could ahve caused this problem on that
particular computer. The file size might be one of the causes, but I don't
think so because I have tried on computers configured in exactly the same
way(hardware and software) with much larger files and it all works fine.

Backup database with SQL to backup directory

I had write out a sql command to backup the database.

BACKUP DATABASE NorthWind
to disk = 'c:\NorthWind_20031113.bak'
with name = 'NorthWind_backup'

However, I intend to backup the database to the SQL server default backup directory, "\MSSQL7\Backup". How can I do that? Given that I don't know the SQL server were installed in C drive or D drive.

Another question was, can I do a integrity check using the sql command on the backup copy that i had created??

I'll be appreciate on the help that you offered.
Thanks.I tried this and it works, ie put the backup into the MSSQL/Backup folder

BACKUP DATABASE NorthWind
to disk = 'NorthWind_20031113.bak'
with name = 'NorthWind_backup'

Trick seems to be to not to specify a location and by default it used the backup folder

Mark|||Thank for your reply. I had try on the solution you given, however, the backup copy was placed to my "winnt\system32" directory. I had try both on my own pc and to backup remotely on the database server. Both of the trial was same where the backup copy being placed to the window system directory.|||The Holy book says :

If a relative path name is entered for a backup to disk, the backup file is placed in the default backup directory. This directory is set during installation and stored in the BackupDirectory registry key under

KEY_LOCAL_MACHINE\Software\Microsoft\ MSSQLServer\MSSQLServer.

Reffering again from the Holy Book for your second question

RESTORE VERIFYONLY
Verifies the backup but does not restore the backup. Checks to see that the backup set is complete and that all volumes are readable. However, RESTORE VERIFYONLY does not attempt to verify the structure of the data contained in the backup volumes. If the backup is valid, Microsoft SQL Server 2000 returns the message: "The backup set is valid."

Syntax
RESTORE VERIFYONLY
FROM < backup_device > [ ,...n ]
[ WITH
[ FILE = file_number ]
[ [ , ] { NOUNLOAD | UNLOAD } ]
[ [ , ] LOADHISTORY ]
[ [ , ] PASSWORD = { password | @.password_variable } ]
[ [ , ] MEDIAPASSWORD = { mediapassword | @.mediapassword_variable } ]
[ [ , ] { NOREWIND | REWIND } ]
]

< backup_device > ::=
{
{ 'logical_backup_device_name' | @.logical_backup_device_name_var }
| { DISK | TAPE } =
{ 'physical_backup_device_name' | @.physical_backup_device_name_var }
}|||If a relative path name is entered for a backup to disk, the backup file is placed in the default backup directory. This directory is set during installation and stored in the BackupDirectory registry key under

KEY_LOCAL_MACHINE\Software\Microsoft\ MSSQLServer\MSSQLServer.

I also found the statement above at the "Holy Book", however, i can't really understand what it means by relative path name. If I had to go to registry to read for the path, then as I know I can't do it.
Actually now I'm writing a simple program to do the database backup at the client pc and the database server only have MSDE but no enterprise manager. So, I can't check for the backup path from the registry value cause my program was running at the client pc.
I'm really grateful for the help you offered. Thanks for the answer for the second question.

:D|||Relative path means ... specifying no drive or directory .. just the filename|||I had tried it before, but the backup copy were being create at the system directory, "c:\winnt\system32" insteed of the SQL Backup folder.|||what does the BackupDirectory registry key under

KEY_LOCAL_MACHINE\Software\Microsoft\ MSSQLServer\MSSQLServer point to ?

You can see it by opening regedit and navigating to the key|||I check on it already, is pointing to the sql path. D:\MSSQL7\Backup\|||Originally posted by coffytan
I check on it already, is pointing to the sql path. D:\MSSQL7\Backup\

Still backup gos to systerm Winnt ,, wierd !!!!!!!!