restore master database: negative

Showing posts with label negative. Show all posts

Wednesday, March 21, 2012

Restore shows negative file size

Tuesday, March 20, 2012

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...
> > 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.
>
>|||Please lookup in the BOL
"ctpersonus" <ctpersonus@.discussions.microsoft.com> wrote in message
news:17290896-0443-4BC3-8177-EA47C76DD96F@.microsoft.com...
>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...
>> > 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.
>>|||> 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...
>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...
>> > 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 ran the command in the Query Analyzer... What am I looking for?
"Tibor Karaszi" 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...
> >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...
> >> > 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.
> >>
> >>
> >>
>|||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...
>I ran the command in the Query Analyzer... What am I looking for?
> "Tibor Karaszi" 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...
>> >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...
>> >> > 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.
>> >>
>> >>
>> >>
>>|||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...
> >I ran the command in the Query Analyzer... What am I looking for?
> >
> > "Tibor Karaszi" 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...
> >> >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...
> >> >> > 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.
> >> >>
> >> >>
> >> >>
> >>
> >>
>
>|||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...
> 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...
>> >I ran the command in the Query Analyzer... What am I looking for?
>> >
>> > "Tibor Karaszi" 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...
>> >> >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...
>> >> >> > 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.
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>>|||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...
>>I ran the command in the Query Analyzer... What am I looking for?
>> "Tibor Karaszi" 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...
>> >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...
>> >> > 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 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@.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...
>>I ran the command in the Query Analyzer... What am I looking for?
>> "Tibor Karaszi" 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...
>> >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...
>> >> > 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.
>> >>
>> >>
>> >>
>>
>>
>

Restore shows negative file size

Restore Set has a Negative File Size

Any ideas what would cause a file size to be negative?
We ship backups to our dev server, and they usually take an hour or so, but
they have recently been running for around 4 hours.
The first file in the restore set has a negative size. What's up with that?
Screenshot: http://home.comcast.net/~mcahrenfamily/SNAG-0008.gifUI overflow perhaps? What does RESTORE HEADERONLY and RESTORE FILELISTONLY s
ay?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"JM" <JM@.nospam.com> wrote in message news:OYFELykqFHA.2604@.TK2MSFTNGP14.phx.gbl...agreen">
> Any ideas what would cause a file size to be negative?
> We ship backups to our dev server, and they usually take an hour or so, bu
t
> they have recently been running for around 4 hours.
> The first file in the restore set has a negative size. What's up with tha
t?
> Screenshot: http://home.comcast.net/~mcahrenfamily/SNAG-0008.gif
>

Restore Set has a Negative File Size

Any ideas what would cause a file size to be negative?
We ship backups to our dev server, and they usually take an hour or so, but
they have recently been running for around 4 hours.
The first file in the restore set has a negative size. What's up with that?
Screenshot: http://home.comcast.net/~mcahrenfamily/SNAG-0008.gif
UI overflow perhaps? What does RESTORE HEADERONLY and RESTORE FILELISTONLY say?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"JM" <JM@.nospam.com> wrote in message news:OYFELykqFHA.2604@.TK2MSFTNGP14.phx.gbl...
> Any ideas what would cause a file size to be negative?
> We ship backups to our dev server, and they usually take an hour or so, but
> they have recently been running for around 4 hours.
> The first file in the restore set has a negative size. What's up with that?
> Screenshot: http://home.comcast.net/~mcahrenfamily/SNAG-0008.gif
>

Restore Set has a Negative File Size

Any ideas what would cause a file size to be negative?
We ship backups to our dev server, and they usually take an hour or so, but
they have recently been running for around 4 hours.
The first file in the restore set has a negative size. What's up with that?
Screenshot: http://home.comcast.net/~mcahrenfamily/SNAG-0008.gifUI overflow perhaps? What does RESTORE HEADERONLY and RESTORE FILELISTONLY say?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"JM" <JM@.nospam.com> wrote in message news:OYFELykqFHA.2604@.TK2MSFTNGP14.phx.gbl...
> Any ideas what would cause a file size to be negative?
> We ship backups to our dev server, and they usually take an hour or so, but
> they have recently been running for around 4 hours.
> The first file in the restore set has a negative size. What's up with that?
> Screenshot: http://home.comcast.net/~mcahrenfamily/SNAG-0008.gif
>

Wednesday, March 21, 2012

Restore shows negative file size

Tuesday, March 20, 2012

Restore shows negative file size

Restore shows negative file size

Restore Set has a Negative File Size

Restore Set has a Negative File Size

Restore Set has a Negative File Size

restore master database

Blog Archive

About Me