2nd Try: Restore Database Dialog missing Backups (Archive BIT)

I have a strange problem with restoring files. I have one SQL server
installation that does not show any .BAK files that no longer have the
archive bit set. Is there a switch somewhere that I can throw to
change this back?
I have 3 other SQL server installations in different places that do
not have this issue.
Thanks,
Doug
"Doug Crabtree" <not@.gonna.tell> wrote in message
news:GPKdnbA9tLgxur_cRVn-rw@.comcast.com...
> I have a strange problem with restoring files. I have one SQL server
> installation that does not show any .BAK files that no longer have the
> archive bit set. Is there a switch somewhere that I can throw to
> change this back?
> I have 3 other SQL server installations in different places that do
> not have this issue.
You can change the archive bit from a command prompt with the ATTRIB
command. It sounds like you may have backup software running that is
resetting the bit. This should not prevent you from restoring any backup
files, perhaps there is something else going on here?
Steve
|||I can reset the bit, our backup is indeed changing it.
But the problem remains that the dialog that shows the backups does not show
those without the bit. Only 1 server does it. All our other servers show
it regardless of the archive bit. I was just hoping somebody out there knew
why this was happening.
Thanks,
Doug
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:%23qtYktIhEHA.2908@.TK2MSFTNGP10.phx.gbl...
> You can change the archive bit from a command prompt with the ATTRIB
> command. It sounds like you may have backup software running that is
> resetting the bit. This should not prevent you from restoring any backup
> files, perhaps there is something else going on here?
> Steve
>
|||AFAIK, the restore dialog doesn't care at all whether the backup files archive bit is set or not.
Actually, it doesn't even care whether the file in question *exists*. My guess is that your problem
is elsewhere. You might want to troubleshoot this by doing a backup, verify that EM show this, set
the archive bit and check EM again.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Doug Crabtree" <not@.gonna.tell> wrote in message news:tcydnc2FZ7rZ_r_cRVn-vQ@.comcast.com...
> I can reset the bit, our backup is indeed changing it.
> But the problem remains that the dialog that shows the backups does not show
> those without the bit. Only 1 server does it. All our other servers show
> it regardless of the archive bit. I was just hoping somebody out there knew
> why this was happening.
> Thanks,
> Doug
> "Steve Thompson" <stevethompson@.nomail.please> wrote in message
> news:%23qtYktIhEHA.2908@.TK2MSFTNGP10.phx.gbl...
>
|||I have tried that. It dissapears from the selection dialog when the archive
bit is not set. When set, it appears again.
Strange...
Thanks anyway,
Doug
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ePeJe3OhEHA.3272@.TK2MSFTNGP11.phx.gbl...
> AFAIK, the restore dialog doesn't care at all whether the backup files
archive bit is set or not.
> Actually, it doesn't even care whether the file in question *exists*. My
guess is that your problem
> is elsewhere. You might want to troubleshoot this by doing a backup,
verify that EM show this, set
> the archive bit and check EM again.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
|||Strange indeed. Can you point me to exactly what dialog you refer to (how to you "click" to get
there) and I'll give it a spin. I've never encountered this, or even thought about the archive bit
being relevant...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Doug Crabtree" <not@.gonna.tell> wrote in message news:nOOdnVUDjKWVzr7cRVn-qA@.comcast.com...
> I have tried that. It dissapears from the selection dialog when the archive
> bit is not set. When set, it appears again.
> Strange...
> Thanks anyway,
> Doug
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:ePeJe3OhEHA.3272@.TK2MSFTNGP11.phx.gbl...
> archive bit is set or not.
> guess is that your problem
> verify that EM show this, set
>
|||In Enterprise Manager, Right click on Databases, and select All Tasks ->
Restore Database...
"Restore Database" Dialog Box
Restore as database: <<DBNAME>>
From Device selected
Restore backup set (Database - complete) selected
Click Select Devices button
"Choose Restore Devices" Dialog Box
Disk selected
Click Add button
"Choose Restore Destination" dialog box:
File Name (click the ...)
"Backup Device Location - <<SERVERNAME>>" Dialog box:
They don't show.
Interesting, though ... I copied one of the backups to another disk, turned
off the archive bit, and it showed there. Something about that drive?
Permissions? We have the Server running as an administrator's account.
Would that have anything to do with it?
Thanks,
Doug
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OtgmcOShEHA.1156@.TK2MSFTNGP10.phx.gbl...
> Strange indeed. Can you point me to exactly what dialog you refer to (how
to you "click" to get
> there) and I'll give it a spin. I've never encountered this, or even
thought about the archive bit
> being relevant...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
|||I tried your steps and I could not reproduce, the file did show, regardless of what I set the "the file is
ready for ..." option in Explorer (I assume this is the ol' archive bit).
I did a Profiler trace and it seems like EM is executing xp_dirtree to get this list. This might give you
something to go on when searching KB, Google etc.
Also, opening a case with MS might be an option.
I doubt is has anything to do with permissions. But who know...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Doug Crabtree" <not@.gonna.tell> wrote in message news:np-dnVZYZaxf9b7cRVn-ig@.comcast.com...
> In Enterprise Manager, Right click on Databases, and select All Tasks ->
> Restore Database...
> "Restore Database" Dialog Box
> Restore as database: <<DBNAME>>
> From Device selected
> Restore backup set (Database - complete) selected
> Click Select Devices button
> "Choose Restore Devices" Dialog Box
> Disk selected
> Click Add button
> "Choose Restore Destination" dialog box:
> File Name (click the ...)
> "Backup Device Location - <<SERVERNAME>>" Dialog box:
> They don't show.
> ----
> --
> Interesting, though ... I copied one of the backups to another disk, turned
> off the archive bit, and it showed there. Something about that drive?
> Permissions? We have the Server running as an administrator's account.
> Would that have anything to do with it?
> Thanks,
> Doug
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:OtgmcOShEHA.1156@.TK2MSFTNGP10.phx.gbl...
> to you "click" to get
> thought about the archive bit
>
|||Interesting problem indeed -- can you use the "native" T-SQL RESTORE to
perform the database restore?
Steve
"Doug Crabtree" <not@.gonna.tell> wrote in message
news:np-dnVZYZaxf9b7cRVn-ig@.comcast.com...
> In Enterprise Manager, Right click on Databases, and select All Tasks ->
> Restore Database...
> "Restore Database" Dialog Box
> Restore as database: <<DBNAME>>
> From Device selected
> Restore backup set (Database - complete) selected
> Click Select Devices button
> "Choose Restore Devices" Dialog Box
> Disk selected
> Click Add button
> "Choose Restore Destination" dialog box:
> File Name (click the ...)
> "Backup Device Location - <<SERVERNAME>>" Dialog box:
> They don't show.
> ----
--
> --
> Interesting, though ... I copied one of the backups to another disk,
turned
> off the archive bit, and it showed there. Something about that drive?
> Permissions? We have the Server running as an administrator's account.
> Would that have anything to do with it?
> Thanks,
> Doug
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in[vbcol=seagreen]
> message news:OtgmcOShEHA.1156@.TK2MSFTNGP10.phx.gbl...
(how
> to you "click" to get
> thought about the archive bit
>
|||I can acutally just type in the name of the file in the "Choose Restore
Destination" Dialog Box. It will restore it, they just don't show in the
dir tree.
Doug
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:uxhb6pUhEHA.3664@.TK2MSFTNGP12.phx.gbl...
> Interesting problem indeed -- can you use the "native" T-SQL RESTORE to
> perform the database restore?
> Steve

2nd Try: Restore Database Dialog missing Backups (Archive BIT)

I have a strange problem with restoring files. I have one SQL server
installation that does not show any .BAK files that no longer have the
archive bit set. Is there a switch somewhere that I can throw to
change this back?
I have 3 other SQL server installations in different places that do
not have this issue.
Thanks,
Doug"Doug Crabtree" <not@.gonna.tell> wrote in message
news:GPKdnbA9tLgxur_cRVn-rw@.comcast.com...
> I have a strange problem with restoring files. I have one SQL server
> installation that does not show any .BAK files that no longer have the
> archive bit set. Is there a switch somewhere that I can throw to
> change this back?
> I have 3 other SQL server installations in different places that do
> not have this issue.
You can change the archive bit from a command prompt with the ATTRIB
command. It sounds like you may have backup software running that is
resetting the bit. This should not prevent you from restoring any backup
files, perhaps there is something else going on here?
Steve|||I can reset the bit, our backup is indeed changing it.
But the problem remains that the dialog that shows the backups does not show
those without the bit. Only 1 server does it. All our other servers show
it regardless of the archive bit. I was just hoping somebody out there knew
why this was happening.
Thanks,
Doug
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:%23qtYktIhEHA.2908@.TK2MSFTNGP10.phx.gbl...
> You can change the archive bit from a command prompt with the ATTRIB
> command. It sounds like you may have backup software running that is
> resetting the bit. This should not prevent you from restoring any backup
> files, perhaps there is something else going on here?
> Steve
>|||AFAIK, the restore dialog doesn't care at all whether the backup files archive bit is set or not.
Actually, it doesn't even care whether the file in question *exists*. My guess is that your problem
is elsewhere. You might want to troubleshoot this by doing a backup, verify that EM show this, set
the archive bit and check EM again.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Doug Crabtree" <not@.gonna.tell> wrote in message news:tcydnc2FZ7rZ_r_cRVn-vQ@.comcast.com...
> I can reset the bit, our backup is indeed changing it.
> But the problem remains that the dialog that shows the backups does not show
> those without the bit. Only 1 server does it. All our other servers show
> it regardless of the archive bit. I was just hoping somebody out there knew
> why this was happening.
> Thanks,
> Doug
> "Steve Thompson" <stevethompson@.nomail.please> wrote in message
> news:%23qtYktIhEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > You can change the archive bit from a command prompt with the ATTRIB
> > command. It sounds like you may have backup software running that is
> > resetting the bit. This should not prevent you from restoring any backup
> > files, perhaps there is something else going on here?
> >
> > Steve
> >
> >
>|||I have tried that. It dissapears from the selection dialog when the archive
bit is not set. When set, it appears again.
Strange...
Thanks anyway,
Doug
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ePeJe3OhEHA.3272@.TK2MSFTNGP11.phx.gbl...
> AFAIK, the restore dialog doesn't care at all whether the backup files
archive bit is set or not.
> Actually, it doesn't even care whether the file in question *exists*. My
guess is that your problem
> is elsewhere. You might want to troubleshoot this by doing a backup,
verify that EM show this, set
> the archive bit and check EM again.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/|||Strange indeed. Can you point me to exactly what dialog you refer to (how to you "click" to get
there) and I'll give it a spin. I've never encountered this, or even thought about the archive bit
being relevant...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Doug Crabtree" <not@.gonna.tell> wrote in message news:nOOdnVUDjKWVzr7cRVn-qA@.comcast.com...
> I have tried that. It dissapears from the selection dialog when the archive
> bit is not set. When set, it appears again.
> Strange...
> Thanks anyway,
> Doug
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:ePeJe3OhEHA.3272@.TK2MSFTNGP11.phx.gbl...
> > AFAIK, the restore dialog doesn't care at all whether the backup files
> archive bit is set or not.
> > Actually, it doesn't even care whether the file in question *exists*. My
> guess is that your problem
> > is elsewhere. You might want to troubleshoot this by doing a backup,
> verify that EM show this, set
> > the archive bit and check EM again.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
>|||In Enterprise Manager, Right click on Databases, and select All Tasks ->
Restore Database...
"Restore Database" Dialog Box
Restore as database: <<DBNAME>>
From Device selected
Restore backup set (Database - complete) selected
Click Select Devices button
"Choose Restore Devices" Dialog Box
Disk selected
Click Add button
"Choose Restore Destination" dialog box:
File Name (click the ...)
"Backup Device Location - <<SERVERNAME>>" Dialog box:
They don't show.
----
--
Interesting, though ... I copied one of the backups to another disk, turned
off the archive bit, and it showed there. Something about that drive?
Permissions? We have the Server running as an administrator's account.
Would that have anything to do with it?
Thanks,
Doug
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OtgmcOShEHA.1156@.TK2MSFTNGP10.phx.gbl...
> Strange indeed. Can you point me to exactly what dialog you refer to (how
to you "click" to get
> there) and I'll give it a spin. I've never encountered this, or even
thought about the archive bit
> being relevant...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/|||I tried your steps and I could not reproduce, the file did show, regardless of what I set the "the file is
ready for ..." option in Explorer (I assume this is the ol' archive bit).
I did a Profiler trace and it seems like EM is executing xp_dirtree to get this list. This might give you
something to go on when searching KB, Google etc.
Also, opening a case with MS might be an option.
I doubt is has anything to do with permissions. But who know...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Doug Crabtree" <not@.gonna.tell> wrote in message news:np-dnVZYZaxf9b7cRVn-ig@.comcast.com...
> In Enterprise Manager, Right click on Databases, and select All Tasks ->
> Restore Database...
> "Restore Database" Dialog Box
> Restore as database: <<DBNAME>>
> From Device selected
> Restore backup set (Database - complete) selected
> Click Select Devices button
> "Choose Restore Devices" Dialog Box
> Disk selected
> Click Add button
> "Choose Restore Destination" dialog box:
> File Name (click the ...)
> "Backup Device Location - <<SERVERNAME>>" Dialog box:
> They don't show.
> ----
> --
> Interesting, though ... I copied one of the backups to another disk, turned
> off the archive bit, and it showed there. Something about that drive?
> Permissions? We have the Server running as an administrator's account.
> Would that have anything to do with it?
> Thanks,
> Doug
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:OtgmcOShEHA.1156@.TK2MSFTNGP10.phx.gbl...
> > Strange indeed. Can you point me to exactly what dialog you refer to (how
> to you "click" to get
> > there) and I'll give it a spin. I've never encountered this, or even
> thought about the archive bit
> > being relevant...
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
>|||Interesting problem indeed -- can you use the "native" T-SQL RESTORE to
perform the database restore?
Steve
"Doug Crabtree" <not@.gonna.tell> wrote in message
news:np-dnVZYZaxf9b7cRVn-ig@.comcast.com...
> In Enterprise Manager, Right click on Databases, and select All Tasks ->
> Restore Database...
> "Restore Database" Dialog Box
> Restore as database: <<DBNAME>>
> From Device selected
> Restore backup set (Database - complete) selected
> Click Select Devices button
> "Choose Restore Devices" Dialog Box
> Disk selected
> Click Add button
> "Choose Restore Destination" dialog box:
> File Name (click the ...)
> "Backup Device Location - <<SERVERNAME>>" Dialog box:
> They don't show.
> ----
--
> --
> Interesting, though ... I copied one of the backups to another disk,
turned
> off the archive bit, and it showed there. Something about that drive?
> Permissions? We have the Server running as an administrator's account.
> Would that have anything to do with it?
> Thanks,
> Doug
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:OtgmcOShEHA.1156@.TK2MSFTNGP10.phx.gbl...
> > Strange indeed. Can you point me to exactly what dialog you refer to
(how
> to you "click" to get
> > there) and I'll give it a spin. I've never encountered this, or even
> thought about the archive bit
> > being relevant...
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
>|||I can acutally just type in the name of the file in the "Choose Restore
Destination" Dialog Box. It will restore it, they just don't show in the
dir tree.
Doug
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:uxhb6pUhEHA.3664@.TK2MSFTNGP12.phx.gbl...
> Interesting problem indeed -- can you use the "native" T-SQL RESTORE to
> perform the database restore?
> Steve

2nd Try: Restore Database Dialog missing Backups (Archive BIT)

I have a strange problem with restoring files. I have one SQL server
installation that does not show any .BAK files that no longer have the
archive bit set. Is there a switch somewhere that I can throw to
change this back?
I have 3 other SQL server installations in different places that do
not have this issue.
Thanks,
Doug"Doug Crabtree" <not@.gonna.tell> wrote in message
news:GPKdnbA9tLgxur_cRVn-rw@.comcast.com...
> I have a strange problem with restoring files. I have one SQL server
> installation that does not show any .BAK files that no longer have the
> archive bit set. Is there a switch somewhere that I can throw to
> change this back?
> I have 3 other SQL server installations in different places that do
> not have this issue.
You can change the archive bit from a command prompt with the ATTRIB
command. It sounds like you may have backup software running that is
resetting the bit. This should not prevent you from restoring any backup
files, perhaps there is something else going on here?
Steve|||I can reset the bit, our backup is indeed changing it.
But the problem remains that the dialog that shows the backups does not show
those without the bit. Only 1 server does it. All our other servers show
it regardless of the archive bit. I was just hoping somebody out there knew
why this was happening.
Thanks,
Doug
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:%23qtYktIhEHA.2908@.TK2MSFTNGP10.phx.gbl...
> You can change the archive bit from a command prompt with the ATTRIB
> command. It sounds like you may have backup software running that is
> resetting the bit. This should not prevent you from restoring any backup
> files, perhaps there is something else going on here?
> Steve
>|||AFAIK, the restore dialog doesn't care at all whether the backup files archi
ve bit is set or not.
Actually, it doesn't even care whether the file in question *exists*. My gue
ss is that your problem
is elsewhere. You might want to troubleshoot this by doing a backup, verify
that EM show this, set
the archive bit and check EM again.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Doug Crabtree" <not@.gonna.tell> wrote in message news:tcydnc2FZ7rZ_r_cRVn-vQ@.comcast.com...

> I can reset the bit, our backup is indeed changing it.
> But the problem remains that the dialog that shows the backups does not sh
ow
> those without the bit. Only 1 server does it. All our other servers show
> it regardless of the archive bit. I was just hoping somebody out there kn
ew
> why this was happening.
> Thanks,
> Doug
> "Steve Thompson" <stevethompson@.nomail.please> wrote in message
> news:%23qtYktIhEHA.2908@.TK2MSFTNGP10.phx.gbl...
>|||I have tried that. It dissapears from the selection dialog when the archive
bit is not set. When set, it appears again.
Strange...
Thanks anyway,
Doug
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ePeJe3OhEHA.3272@.TK2MSFTNGP11.phx.gbl...
> AFAIK, the restore dialog doesn't care at all whether the backup files
archive bit is set or not.
> Actually, it doesn't even care whether the file in question *exists*. My
guess is that your problem
> is elsewhere. You might want to troubleshoot this by doing a backup,
verify that EM show this, set
> the archive bit and check EM again.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/|||Strange indeed. Can you point me to exactly what dialog you refer to (how to
you "click" to get
there) and I'll give it a spin. I've never encountered this, or even thought
about the archive bit
being relevant...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Doug Crabtree" <not@.gonna.tell> wrote in message news:nOOdnVUDjKWVzr7cRVn-qA@.comcast.com...

> I have tried that. It dissapears from the selection dialog when the archi
ve
> bit is not set. When set, it appears again.
> Strange...
> Thanks anyway,
> Doug
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:ePeJe3OhEHA.3272@.TK2MSFTNGP11.phx.gbl...
> archive bit is set or not.
> guess is that your problem
> verify that EM show this, set
>|||In Enterprise Manager, Right click on Databases, and select All Tasks ->
Restore Database...
"Restore Database" Dialog Box
Restore as database: <<DBNAME>>
From Device selected
Restore backup set (Database - complete) selected
Click Select Devices button
"Choose Restore Devices" Dialog Box
Disk selected
Click Add button
"Choose Restore Destination" dialog box:
File Name (click the ...)
"Backup Device Location - <<SERVERNAME>>" Dialog box:
They don't show.
----
--
Interesting, though ... I copied one of the backups to another disk, turned
off the archive bit, and it showed there. Something about that drive?
Permissions? We have the Server running as an administrator's account.
Would that have anything to do with it?
Thanks,
Doug
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OtgmcOShEHA.1156@.TK2MSFTNGP10.phx.gbl...
> Strange indeed. Can you point me to exactly what dialog you refer to (how
to you "click" to get
> there) and I'll give it a spin. I've never encountered this, or even
thought about the archive bit
> being relevant...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/|||I tried your steps and I could not reproduce, the file did show, regardless
of what I set the "the file is
ready for ..." option in Explorer (I assume this is the ol' archive bit).
I did a Profiler trace and it seems like EM is executing xp_dirtree to get t
his list. This might give you
something to go on when searching KB, Google etc.
Also, opening a case with MS might be an option.
I doubt is has anything to do with permissions. But who know...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Doug Crabtree" <not@.gonna.tell> wrote in message news:np-dnVZYZaxf9b7cRVn-ig@.comcast.com...

> In Enterprise Manager, Right click on Databases, and select All Tasks ->
> Restore Database...
> "Restore Database" Dialog Box
> Restore as database: <<DBNAME>>
> From Device selected
> Restore backup set (Database - complete) selected
> Click Select Devices button
> "Choose Restore Devices" Dialog Box
> Disk selected
> Click Add button
> "Choose Restore Destination" dialog box:
> File Name (click the ...)
> "Backup Device Location - <<SERVERNAME>>" Dialog box:
> They don't show.
> ----
--
> --
> Interesting, though ... I copied one of the backups to another disk, turne
d
> off the archive bit, and it showed there. Something about that drive?
> Permissions? We have the Server running as an administrator's account.
> Would that have anything to do with it?
> Thanks,
> Doug
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:OtgmcOShEHA.1156@.TK2MSFTNGP10.phx.gbl...
> to you "click" to get
> thought about the archive bit
>|||Interesting problem indeed -- can you use the "native" T-SQL RESTORE to
perform the database restore?
Steve
"Doug Crabtree" <not@.gonna.tell> wrote in message
news:np-dnVZYZaxf9b7cRVn-ig@.comcast.com...
> In Enterprise Manager, Right click on Databases, and select All Tasks ->
> Restore Database...
> "Restore Database" Dialog Box
> Restore as database: <<DBNAME>>
> From Device selected
> Restore backup set (Database - complete) selected
> Click Select Devices button
> "Choose Restore Devices" Dialog Box
> Disk selected
> Click Add button
> "Choose Restore Destination" dialog box:
> File Name (click the ...)
> "Backup Device Location - <<SERVERNAME>>" Dialog box:
> They don't show.
> ----
--
> --
> Interesting, though ... I copied one of the backups to another disk,
turned
> off the archive bit, and it showed there. Something about that drive?
> Permissions? We have the Server running as an administrator's account.
> Would that have anything to do with it?
> Thanks,
> Doug
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:OtgmcOShEHA.1156@.TK2MSFTNGP10.phx.gbl...
(how[vbcol=seagreen]
> to you "click" to get
> thought about the archive bit
>|||I can acutally just type in the name of the file in the "Choose Restore
Destination" Dialog Box. It will restore it, they just don't show in the
dir tree.
Doug
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:uxhb6pUhEHA.3664@.TK2MSFTNGP12.phx.gbl...
> Interesting problem indeed -- can you use the "native" T-SQL RESTORE to
> perform the database restore?
> Steve

2147190908 Failed to export the report

Hi All,
Facing an issue while exporting a report(invoice) to PDF in Crystal 8.5 after exporting 1000's of files(invoices) to PDF.

Error msg "2147190908 Failed to export the report". after generating this error, OKB PDF file is generated and we are nt getting any invoices from then.

We have a Licensed Copy of Crystal Reports 8.5 Developer Version
We are facing a Problem while exporting our Invoices in PDF Format

After Printing Some Invoices It Starts giving the following error
Error message" -2147190908 Failed to export the report".

The Number at which the process starts giving this error is not Consistent .
Some time the problem starts after printing 60, 000 Invoice and some times
it starts coming after 40 to 50 thousand.
But once the problem comes , then it keeps coming whatever we do.

We did the following to rectify the problem but of no use
1. Restarted the machine
2. Un installed the Application and re-installed it .
3. Replace the Crystal DLLs , some of them I am listing here (Crxddrt.dll ,
crxdrt.dll, crxDesignerctrl.DLL, CRXDUI.DLL)
4. Applied the HOT fix patch CR85devwin_en.zip on our existing Development
env

It is a very Critical Problem as Implementation is starting from 31st
January , and Client is just waiting for this patch

Any help will be highly appreciated , In case somebody assure me to
solve this problem we can also go for the annual Support Contract.

Please help !!!!

Regards,
RajWe are experiencing the exact same issue. Reports have been exporting fine for over a year and then suddenly we are getting the same export error.

We have also tried reinstalling Crystal and before we re-image the machine, has anyone found a solution to this issue or at least what we can look into.

You said that there is not a set number of reports where you start to see this error. How were you able to get it to start temporarily working again??

Thanks for any help!|||Incase anyone comes looking, our solution was to empty out the temp folder where Crystal was creating the files before converting to PDF. We had over 75000 temp files sitting in the folder. Why Crystal doesn't clean up after itself I don't know, but we ended up creating a service that empties this folder everyday.

Hope this solves your issue as well.

walther|||Bumping this thread for resolution.

Our system just recently experienced the same issue.

Win2k3 Server
Citrix Metaframe XP
Crystal Reports 8.5
Adobe Acrobat 5

I've already uninstall acrobat, crystals, java, and a plethora of other software in hopes of fixing this bug. I've regsvr32 practically all the dlls and deleted the temp files/folders as well.

I've done practically everything short of reinstalling the entire server.

Any suggestions would be greatly appreciated.|||Hello,

I know this is an ancient subject, but I am running into the same issue. I see that Walther, you mentioned that you solved the problem by deleting the files out of the temp folder. Can you tell me where Crystal Reports keeps it's temp files. I want to view that folder on our box to see what it looks like.

Thanks, Neil

2005: Script objects to separate files?

In addition to many of the other useful things in EM, i cannot find (and i
assume has been removed) the ability to script database objects each to
their own file. e.g.
*.tab
*.viw
*.prc
*.trg
etc
Is this also gone?
Yes. As an alternative, check the blog on this issue and a
utility that provides some missing scripting in SQL 2005:
http://weblogs.sqlteam.com/billg/arc...1/22/8414.aspx
-Sue
On Sun, 26 Mar 2006 13:58:51 -0500, "Ian Boyd"
<admin@.SWIFTPA.NET> wrote:

>In addition to many of the other useful things in EM, i cannot find (and i
>assume has been removed) the ability to script database objects each to
>their own file. e.g.
> *.tab
> *.viw
> *.prc
> *.trg
>etc
>Is this also gone?
>

2005: Script objects to separate files?

In addition to many of the other useful things in EM, i cannot find (and i
assume has been removed) the ability to script database objects each to
their own file. e.g.
*.tab
*.viw
*.prc
*.trg
etc
Is this also gone?Yes. As an alternative, check the blog on this issue and a
utility that provides some missing scripting in SQL 2005:
http://weblogs.sqlteam.com/billg/archive/2005/11/22/8414.aspx
-Sue
On Sun, 26 Mar 2006 13:58:51 -0500, "Ian Boyd"
<admin@.SWIFTPA.NET> wrote:
>In addition to many of the other useful things in EM, i cannot find (and i
>assume has been removed) the ability to script database objects each to
>their own file. e.g.
> *.tab
> *.viw
> *.prc
> *.trg
>etc
>Is this also gone?
>

2005: Script objects to separate files?

In addition to many of the other useful things in EM, i cannot find (and i
assume has been removed) the ability to script database objects each to
their own file. e.g.
*.tab
*.viw
*.prc
*.trg
etc
Is this also gone?Yes. As an alternative, check the blog on this issue and a
utility that provides some missing scripting in SQL 2005:
http://weblogs.sqlteam.com/billg/ar...11/22/8414.aspx
-Sue
On Sun, 26 Mar 2006 13:58:51 -0500, "Ian Boyd"
<admin@.SWIFTPA.NET> wrote:

>In addition to many of the other useful things in EM, i cannot find (and i
>assume has been removed) the ability to script database objects each to
>their own file. e.g.
> *.tab
> *.viw
> *.prc
> *.trg
>etc
>Is this also gone?
>

2005: Database cannot be opened

Hello,
Could you explain me please the following error:

"Database 'DemoDotNET' cannot be opened due to inaccessible files or
insufficient memory or disk space. (Microsoft SQL Server, Error: 945)"

I have checked: free disk space is large enough, I have much enough
memory, other files in the directory are accessible.

Here is tail of ERRORLOG:

2006-06-12 21:19:55.68 Logon Error: 18456, Severity: 14, State:
16.
2006-06-12 21:19:55.68 Logon Login failed for user 'PC\Robert'.
[CLIENT: <local machine>]
2006-06-12 21:20:43.39 Server Server resumed execution after
being idle 1 seconds: user activity awakened the server. This is an
informational message only. No user action is required.

Please help to solve this.
Thank you.
/RAM/R.A.M. (r_ahimsa_m@.poczta.onet.pl) writes:
> "Database 'DemoDotNET' cannot be opened due to inaccessible files or
> insufficient memory or disk space. (Microsoft SQL Server, Error: 945)"
> I have checked: free disk space is large enough, I have much enough
> memory, other files in the directory are accessible.

Or there is some file for DemoDotNET which is located somewhere where
you don't think it is.

Unfortunately, with the information at hand it's impossible to say. You
could at least have posted the part of the error log where this message
appears. Or tell us when you get this error. Does it happen at startup?
Do you try to attach the database? Something else?

And, not the least, you did not tell us which version of SQL Server
you are using.

--
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|||On Mon, 12 Jun 2006 21:36:15 +0000 (UTC), Erland Sommarskog
<esquel@.sommarskog.se> wrote:

>R.A.M. (r_ahimsa_m@.poczta.onet.pl) writes:
>> "Database 'DemoDotNET' cannot be opened due to inaccessible files or
>> insufficient memory or disk space. (Microsoft SQL Server, Error: 945)"
>>
>> I have checked: free disk space is large enough, I have much enough
>> memory, other files in the directory are accessible.
>Or there is some file for DemoDotNET which is located somewhere where
>you don't think it is.
>Unfortunately, with the information at hand it's impossible to say. You
>could at least have posted the part of the error log where this message
>appears. Or tell us when you get this error. Does it happen at startup?
>Do you try to attach the database? Something else?
>And, not the least, you did not tell us which version of SQL Server
>you are using.

I am using SQL Server 2005.
In directory of the database I have files: DemoDotNET.mdf,
DemoDotNET_log.ldf.
I got the error when I try to see properties of database, or script
database or open in C#.NET or VB program.|||R.A.M. (r_ahimsa_m@.poczta.onet.pl) writes:
> I am using SQL Server 2005.
> In directory of the database I have files: DemoDotNET.mdf,
> DemoDotNET_log.ldf.
> I got the error when I try to see properties of database, or script
> database or open in C#.NET or VB program.

If you do

SELECT name, physical_name
FROM sys.master_files
where database_id = db_id('DemoDotNet')

does physical_name agree with the files you see in Explorer?

If they do, my suspicion is that the log file has been tampered with,
and is not usable.

--
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

2005 vs 2000 views performance q

We are attempting to move from sq12k to 2k5 for one of our products, and
have a few replay trace files that we are using to determine performance
diffs between the two.
What we do is baseline backup a 2k db, then start a replay trace, and then
have users run thru their test cases. So for our test, on either 2k or 2k5,
we restore the pre-test database, run a checkdb and rebuild all indexes on
every table in the db.
We have one statement "duration" that sticks out like a sore thumb
performance wise between 2k and 2k5, 2k5 being much slower, here is the
scenario, in sql 2005:
1) The statement hits a view, that sits on top of a table with *a lot* of
data
2) The select statement does a top, and a "like" on 3 varchar columns in the
table, none of which are indexed
3) The first time this query is run, via the sql replay, the statment takes
over a minute to complete.
4) Each subsequent execution takes about 350 microseconds.
Now, in sql2k, we run the exact same test, restore the db, run checkdb,
recreate all indexes. All executions of the above statement take around 14
milliseconds, first exec, and all after that.
Has anyone seen/experienced this?
Thanks in advance!
DerrickDid you update statistics?
Denis The SQL Menace
http://sqlservercode.blogspot.com
http://sqlblog.com/blogs/denis_gobo/default.aspx
On Aug 23, 9:55 am, "Derrick" <derrick1...@.excite.com> wrote:
> We are attempting to move from sq12k to 2k5 for one of our products, and
> have a few replay trace files that we are using to determine performance
> diffs between the two.
> What we do is baseline backup a 2k db, then start a replay trace, and then
> have users run thru their test cases. So for our test, on either 2k or 2k5,
> we restore the pre-test database, run a checkdb and rebuild all indexes on
> every table in the db.
> We have one statement "duration" that sticks out like a sore thumb
> performance wise between 2k and 2k5, 2k5 being much slower, here is the
> scenario, in sql 2005:
> 1) The statement hits a view, that sits on top of a table with *a lot* of
> data
> 2) The select statement does a top, and a "like" on 3 varchar columns in the
> table, none of which are indexed
> 3) The first time this query is run, via the sql replay, the statment takes
> over a minute to complete.
> 4) Each subsequent execution takes about 350 microseconds.
> Now, in sql2k, we run the exact same test, restore the db, run checkdb,
> recreate all indexes. All executions of the above statement take around 14
> milliseconds, first exec, and all after that.
> Has anyone seen/experienced this?
> Thanks in advance!
> Derrick|||I have a backup of the pre-test mdf/ldf, do an attach, and then execute
this:
use <dbname just attached>
dbcc checkdb
exec sp_Msforeachtable "DBCC DBREINDEX ('?')"
I was going on the theory that this would also update statistics
automatically, is that not the case?
Thanks for input,
Derrick
"SQL Menace" <denis.gobo@.gmail.com> wrote in message
news:1187877687.713708.281740@.j4g2000prf.googlegroups.com...
> Did you update statistics?
>
> Denis The SQL Menace
> http://sqlservercode.blogspot.com
> http://sqlblog.com/blogs/denis_gobo/default.aspx
>
> On Aug 23, 9:55 am, "Derrick" <derrick1...@.excite.com> wrote:
>> We are attempting to move from sq12k to 2k5 for one of our products, and
>> have a few replay trace files that we are using to determine performance
>> diffs between the two.
>> What we do is baseline backup a 2k db, then start a replay trace, and
>> then
>> have users run thru their test cases. So for our test, on either 2k or
>> 2k5,
>> we restore the pre-test database, run a checkdb and rebuild all indexes
>> on
>> every table in the db.
>> We have one statement "duration" that sticks out like a sore thumb
>> performance wise between 2k and 2k5, 2k5 being much slower, here is the
>> scenario, in sql 2005:
>> 1) The statement hits a view, that sits on top of a table with *a lot* of
>> data
>> 2) The select statement does a top, and a "like" on 3 varchar columns in
>> the
>> table, none of which are indexed
>> 3) The first time this query is run, via the sql replay, the statment
>> takes
>> over a minute to complete.
>> 4) Each subsequent execution takes about 350 microseconds.
>> Now, in sql2k, we run the exact same test, restore the db, run checkdb,
>> recreate all indexes. All executions of the above statement take around
>> 14
>> milliseconds, first exec, and all after that.
>> Has anyone seen/experienced this?
>> Thanks in advance!
>> Derrick
>|||> I was going on the theory that this would also update statistics automatically, is that not the
> case?
It will update statistics of all you indexes. But not statistics only.
I'd start with comparing the execution plans between the queries to see if they differ and take it
from there.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Derrick" <derrick1298@.excite.com> wrote in message news:%23DjW$iZ5HHA.4584@.TK2MSFTNGP03.phx.gbl...
>I have a backup of the pre-test mdf/ldf, do an attach, and then execute this:
> use <dbname just attached>
> dbcc checkdb
> exec sp_Msforeachtable "DBCC DBREINDEX ('?')"
> I was going on the theory that this would also update statistics automatically, is that not the
> case?
> Thanks for input,
> Derrick
>
> "SQL Menace" <denis.gobo@.gmail.com> wrote in message
> news:1187877687.713708.281740@.j4g2000prf.googlegroups.com...
>> Did you update statistics?
>>
>> Denis The SQL Menace
>> http://sqlservercode.blogspot.com
>> http://sqlblog.com/blogs/denis_gobo/default.aspx
>>
>> On Aug 23, 9:55 am, "Derrick" <derrick1...@.excite.com> wrote:
>> We are attempting to move from sq12k to 2k5 for one of our products, and
>> have a few replay trace files that we are using to determine performance
>> diffs between the two.
>> What we do is baseline backup a 2k db, then start a replay trace, and then
>> have users run thru their test cases. So for our test, on either 2k or 2k5,
>> we restore the pre-test database, run a checkdb and rebuild all indexes on
>> every table in the db.
>> We have one statement "duration" that sticks out like a sore thumb
>> performance wise between 2k and 2k5, 2k5 being much slower, here is the
>> scenario, in sql 2005:
>> 1) The statement hits a view, that sits on top of a table with *a lot* of
>> data
>> 2) The select statement does a top, and a "like" on 3 varchar columns in the
>> table, none of which are indexed
>> 3) The first time this query is run, via the sql replay, the statment takes
>> over a minute to complete.
>> 4) Each subsequent execution takes about 350 microseconds.
>> Now, in sql2k, we run the exact same test, restore the db, run checkdb,
>> recreate all indexes. All executions of the above statement take around 14
>> milliseconds, first exec, and all after that.
>> Has anyone seen/experienced this?
>> Thanks in advance!
>> Derrick
>>
>

2005 SQL EXPRESS DATABASE BACKUP

I am using Veritas backup exec 10.d with sql agent. I am able to see the sql express studio 2005 database files but there is difference in file size between original database file and the one shows in sql agent backup selection. The backup performs 100% successful but the original database file size is different e.g( original file:350MB, backup file: 28MB)..

Any ideas...?

Thanks in advance..

Have you talked to the folks at Veritas/Symantec about this? They can probably give you better information about their software.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||

The SQL API that BE plugs into will only send extents that are currently allocated by the database, so if you have created a database with an initial size and not filled it, we'd expect this delta.

Beyond this, I'd check if compression is enabled.

Of course, the ultimate test of whether a backup is valid or not is to attempt to do a restore. This should be a periodic task for any backup setup.

2005 Maintenance Plans

Hi,
can anyone tell me if it is possible to cycle the backup files. They just
seem to append, but I wany to cycle them based on a 7 day period.
TIAwhen you say cycle, i believe you want to delete bkup files older than
a week or something, if in that case you have to use another task
called maintenance cleanup task..which will do that for you

2005 Maintenance Plans

Hi,
can anyone tell me if it is possible to cycle the backup files. They just
seem to append, but I wany to cycle them based on a 7 day period.
TIA
when you say cycle, i believe you want to delete bkup files older than
a week or something, if in that case you have to use another task
called maintenance cleanup task..which will do that for you

2005 Maintenance Plans

Hi,
can anyone tell me if it is possible to cycle the backup files. They just
seem to append, but I wany to cycle them based on a 7 day period.
TIAwhen you say cycle, i believe you want to delete bkup files older than
a week or something, if in that case you have to use another task
called maintenance cleanup task..which will do that for you

2005 install ques re owner of database?

Hello -
I just installed Sql Server 2005 on a company server. I copied and attached
database mdf and ldf files. The database runs okay with my application on
my developer machine. I just started setting up security on the server and
it is indicating the owner of the database is "MyOrganization"\MyName. My
login name (user name) on the network is MyName. I tried to change to chang
e
the Owner of the database under Files and I'm getting the message:
...The login 'MyName' does not exist on this server.
How can I fix this?
Any help will be greatly appreciated!
--
SandyHow do you connect to the company server? If you connect via SQL login, then
execute the below should do it (assuming the sql login is part of sysadmin).
exec <the_database_name>..sp_changedbowner 'the_sql_login'
If you're login as a NT user/acct and is part of the administrators group,
your NT user name is implicitly granted permission. If you really want to
use your NT user name/acct as the db_owner, you will have to explicitly add
your NT acct to sql sysadmin role.
e.g.
create login [domain\nt_acct] from windows;
exec sp_addsrvrolemember 'domain\nt_acct', 'sysadmin'
then you can change dbowner
exec <the_database_name>..sp_changedbowner 'domain\nt_acct'
-oj
"Sandy" <Sandy@.discussions.microsoft.com> wrote in message
news:CCFAE0DB-7208-4189-B9B4-F5A3B1EDCD0B@.microsoft.com...
> Hello -
> I just installed Sql Server 2005 on a company server. I copied and
> attached
> database mdf and ldf files. The database runs okay with my application on
> my developer machine. I just started setting up security on the server
> and
> it is indicating the owner of the database is "MyOrganization"\MyName. My
> login name (user name) on the network is MyName. I tried to change to
> change
> the Owner of the database under Files and I'm getting the message:
> ...The login 'MyName' does not exist on this server.
> How can I fix this?
> Any help will be greatly appreciated!
> --
> Sandy

2005 install ques re owner of database?

Hello -
I just installed Sql Server 2005 on a company server. I copied and attached
database mdf and ldf files. The database runs okay with my application on
my developer machine. I just started setting up security on the server and
it is indicating the owner of the database is "MyOrganization"\MyName. My
login name (user name) on the network is MyName. I tried to change to change
the Owner of the database under Files and I'm getting the message:
...The login 'MyName' does not exist on this server.
How can I fix this?
Any help will be greatly appreciated!
--
SandyHow do you connect to the company server? If you connect via SQL login, then
execute the below should do it (assuming the sql login is part of sysadmin).
exec <the_database_name>..sp_changedbowner 'the_sql_login'
If you're login as a NT user/acct and is part of the administrators group,
your NT user name is implicitly granted permission. If you really want to
use your NT user name/acct as the db_owner, you will have to explicitly add
your NT acct to sql sysadmin role.
e.g.
create login [domain\nt_acct] from windows;
exec sp_addsrvrolemember 'domain\nt_acct', 'sysadmin'
then you can change dbowner
exec <the_database_name>..sp_changedbowner 'domain\nt_acct'
-oj
"Sandy" <Sandy@.discussions.microsoft.com> wrote in message
news:CCFAE0DB-7208-4189-B9B4-F5A3B1EDCD0B@.microsoft.com...
> Hello -
> I just installed Sql Server 2005 on a company server. I copied and
> attached
> database mdf and ldf files. The database runs okay with my application on
> my developer machine. I just started setting up security on the server
> and
> it is indicating the owner of the database is "MyOrganization"\MyName. My
> login name (user name) on the network is MyName. I tried to change to
> change
> the Owner of the database under Files and I'm getting the message:
> ...The login 'MyName' does not exist on this server.
> How can I fix this?
> Any help will be greatly appreciated!
> --
> Sandy