| Author |
Restore shows negative file size
|
|
| ctpersonus 2006-03-05, 8:23 pm |
| When I try to restore a database, the backup shows a negative file size. When
I try to go ahead and restore, it hangs and does nothing until it is
cancelled.. The database is about 25 gig in size. If I do a restore on a
small database (about 100 meg) it restores just fine.
| |
| Uri Dimant 2006-03-05, 8:23 pm |
| Try run RESTORE FILELISTONLY commad and see what is going on. Are you still
having negative numbers?
"ctpersonus" < ctpersonus@discussio
ns.microsoft.com> wrote in message
news:7F29A9DC-1B53-487F-A5D7- 35F6C3FDB9CB@microso
ft.com...
> When I try to restore a database, the backup shows a negative file size.
> When
> I try to go ahead and restore, it hangs and does nothing until it is
> cancelled.. The database is about 25 gig in size. If I do a restore on a
> small database (about 100 meg) it restores just fine.
| |
| ctpersonus 2006-03-05, 8:23 pm |
| I have been using the Enterprise Manager for my adminstration. Where would I
run the RESTORE FILELISTONLY command?
Sorry for my ingnorance on this...
"Uri Dimant" wrote:
> Try run RESTORE FILELISTONLY commad and see what is going on. Are you still
> having negative numbers?
>
> "ctpersonus" < ctpersonus@discussio
ns.microsoft.com> wrote in message
> news:7F29A9DC-1B53-487F-A5D7- 35F6C3FDB9CB@microso
ft.com...
>
>
>
| |
| Uri Dimant 2006-03-05, 8:23 pm |
| Please lookup in the BOL
"ctpersonus" < ctpersonus@discussio
ns.microsoft.com> wrote in message
news:17290896-0443-4BC3-8177- EA47C76DD96F@microso
ft.com...[color=darkred]
>I have been using the Enterprise Manager for my adminstration. Where would
>I
> run the RESTORE FILELISTONLY command?
>
> Sorry for my ingnorance on this...
>
> "Uri Dimant" wrote:
>
| |
|
|
|
|
| Tibor Karaszi 2006-03-14, 9:23 am |
| The file size, is it still negative?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"ctpersonus" < ctpersonus@discussio
ns.microsoft.com> wrote in message
news:483E21CC-B349-4270-9F95- 07CE4EC23AC4@microso
ft.com...[color=darkred]
>I ran the command in the Query Analyzer... What am I looking for?
>
> "Tibor Karaszi" wrote:
>
| |
|
|
| Tibor Karaszi 2006-03-15, 3:23 am |
| Then it seems that EM incorrectly reports a negative file size for the database files.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"ctpersonus" < ctpersonus@discussio
ns.microsoft.com> wrote in message
news:F836A6AF-42F3-49FA-8C7E- 28F77F405201@microso
ft.com...[color=darkred]
> No it is not negative.
>
> "Tibor Karaszi" wrote:
>
| |
| Microsoft SQL 2006-03-15, 8:23 pm |
| The file shows negative in the restored but not in the RESTORE FILELISTONLY
command?
"Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com> wrote in
message news:uwt3L42RGHA.336@TK2MSFTNGP12.phx.gbl...
> The file size, is it still negative?
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
>
>
> "ctpersonus" < ctpersonus@discussio
ns.microsoft.com> wrote in message
> news:483E21CC-B349-4270-9F95- 07CE4EC23AC4@microso
ft.com...
>
>
| |
| Tibor Karaszi 2006-03-16, 7:23 am |
| I don't know what you mean by "the restored".
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"Microsoft SQL" <kross@dot.ca.gov> wrote in message news:O3Zp%23nHSGHA.1728@TK2MSFTNGP11.phx.gbl...
> The file shows negative in the restored but not in the RESTORE FILELISTONLY command?
> "Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com> wrote in message
> news:uwt3L42RGHA.336@TK2MSFTNGP12.phx.gbl...
>
>
|
|
|
|