Restore shows negative file size

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.
Try run RESTORE FILELISTONLY commad and see what is going on. Are you still
having negative numbers?
"ctpersonus" <ctpersonus@.discussions.microsoft.com> wrote in message
news:7F29A9DC-1B53-487F-A5D7-35F6C3FDB9CB@.microsoft.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.
|||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@.discussions.microsoft.com> wrote in message
> news:7F29A9DC-1B53-487F-A5D7-35F6C3FDB9CB@.microsoft.com...
>
>
|||Please lookup in the BOL
"ctpersonus" <ctpersonus@.discussions.microsoft.com> wrote in message
news:17290896-0443-4BC3-8177-EA47C76DD96F@.microsoft.com...[vbcol=seagreen]
>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:
|||> Where would I
> run the RESTORE FILELISTONLY command?
In Query Analyzer.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ctpersonus" <ctpersonus@.discussions.microsoft.com> wrote in message
news:17290896-0443-4BC3-8177-EA47C76DD96F@.microsoft.com...[vbcol=seagreen]
>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:
|||I ran the command in the Query Analyzer... What am I looking for?
"Tibor Karaszi" wrote:

> In Query Analyzer.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "ctpersonus" <ctpersonus@.discussions.microsoft.com> wrote in message
> news:17290896-0443-4BC3-8177-EA47C76DD96F@.microsoft.com...
>
|||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@.discussions.microsoft.com> wrote in message
news:483E21CC-B349-4270-9F95-07CE4EC23AC4@.microsoft.com...[vbcol=seagreen]
>I ran the command in the Query Analyzer... What am I looking for?
> "Tibor Karaszi" wrote:
|||No it is not negative.
"Tibor Karaszi" wrote:

> 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@.discussions.microsoft.com> wrote in message
> news:483E21CC-B349-4270-9F95-07CE4EC23AC4@.microsoft.com...
>
>
|||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@.discussions.microsoft.com> wrote in message
news:F836A6AF-42F3-49FA-8C7E-28F77F405201@.microsoft.com...[vbcol=seagreen]
> No it is not negative.
> "Tibor Karaszi" wrote:
|||The file shows negative in the restored but not in the RESTORE FILELISTONLY
command?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.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@.discussions.microsoft.com> wrote in message
> news:483E21CC-B349-4270-9F95-07CE4EC23AC4@.microsoft.com...
>

Restore shows negative file size

When I try to restore a database, the backup shows a negative file size. Whe
n
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.Try run RESTORE FILELISTONLY commad and see what is going on. Are you still
having negative numbers?
"ctpersonus" <ctpersonus@.discussions.microsoft.com> wrote in message
news:7F29A9DC-1B53-487F-A5D7-35F6C3FDB9CB@.microsoft.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.|||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 sti
ll
> having negative numbers?
> "ctpersonus" <ctpersonus@.discussions.microsoft.com> wrote in message
> news:7F29A9DC-1B53-487F-A5D7-35F6C3FDB9CB@.microsoft.com...
>
>|||Please lookup in the BOL
"ctpersonus" <ctpersonus@.discussions.microsoft.com> wrote in message
news:17290896-0443-4BC3-8177-EA47C76DD96F@.microsoft.com...[vbcol=seagreen]
>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:
>|||> Where would I
> run the RESTORE FILELISTONLY command?
In Query Analyzer.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ctpersonus" <ctpersonus@.discussions.microsoft.com> wrote in message
news:17290896-0443-4BC3-8177-EA47C76DD96F@.microsoft.com...[vbcol=seagreen]
>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:
>|||I ran the command in the Query Analyzer... What am I looking for?
"Tibor Karaszi" wrote:

> In Query Analyzer.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "ctpersonus" <ctpersonus@.discussions.microsoft.com> wrote in message
> news:17290896-0443-4BC3-8177-EA47C76DD96F@.microsoft.com...
>|||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@.discussions.microsoft.com> wrote in message
news:483E21CC-B349-4270-9F95-07CE4EC23AC4@.microsoft.com...[vbcol=seagreen]
>I ran the command in the Query Analyzer... What am I looking for?
> "Tibor Karaszi" wrote:
>|||No it is not negative.
"Tibor Karaszi" wrote:

> 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@.discussions.microsoft.com> wrote in message
> news:483E21CC-B349-4270-9F95-07CE4EC23AC4@.microsoft.com...
>
>|||Then it seems that EM incorrectly reports a negative file size for the datab
ase files.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ctpersonus" <ctpersonus@.discussions.microsoft.com> wrote in message
news:F836A6AF-42F3-49FA-8C7E-28F77F405201@.microsoft.com...[vbcol=seagreen]
> No it is not negative.
> "Tibor Karaszi" wrote:
>|||The file shows negative in the restored but not in the RESTORE FILELISTONLY
command?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.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@.discussions.microsoft.com> wrote in message
> news:483E21CC-B349-4270-9F95-07CE4EC23AC4@.microsoft.com...
>