restore master database: size

Showing posts with label size. Show all posts

Wednesday, March 28, 2012

RESTORE VERIFYONLY - Disk space

What is the disk space required for RESTORE VERIFYONLY ?
Could it be the size of the database ?
I got a backup of 11.8 GB and only 11.3 GB free.
If I run RESTORE VERIFYONLY, it does not return anything (no 'The
backup set is valid.').
After that I always get MS Windows 'Device full' errors whenever I try to
save any
file even if I still have 11 GB free.
I may not event start the MS Windows event viewer
I have to reboot my server.
Could it be that RESTORE VERIFYONLY restores the DB in some temporary
file and that the space is not actually released after RESTORE
VERIFYONLY failed ?
If this is the case is there a way to specify a directory for RESTORE
VERIFYONLY ?
Thanks in advance.
PS I am using MS SQL Server 2000 (8.00.760 SP3) on Windows 2000 Server
5.00.2195 SP4.
Hi, Eric
RESTORE VERIFYONLY only reads the backup, without writing anything in
any database (not even a temporary file), so free space is not an issue
when you use RESTORE VERIFYONLY (i.e. you can have only 1GB of free
space, and it would still work for a 11GB backup).
Razvan
|||VERIFYONLY simply reads the backup. In SQL Server 2000, it essentially read
the header. In SQL Server 2005, it reads the header, checksums, and page
chain. It doesn't write the backup back out anywhere.
What else is happening on your server when this runs?
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Paesmans Eric" <epa@.missioncriticalit.com> wrote in message
news:43c3c8d5$0$440$6c56d894@.reader0.news.be.easyn et.net...
> What is the disk space required for RESTORE VERIFYONLY ?
>
> Could it be the size of the database ?
>
> I got a backup of 11.8 GB and only 11.3 GB free.
>
> If I run RESTORE VERIFYONLY, it does not return anything (no 'The
> backup set is valid.').
>
> After that I always get MS Windows 'Device full' errors whenever I try to
> save any
> file even if I still have 11 GB free.
> I may not event start the MS Windows event viewer
> I have to reboot my server.
>
> Could it be that RESTORE VERIFYONLY restores the DB in some temporary
> file and that the space is not actually released after RESTORE
> VERIFYONLY failed ?
>
> If this is the case is there a way to specify a directory for RESTORE
> VERIFYONLY ?
>
> Thanks in advance.
>
> PS I am using MS SQL Server 2000 (8.00.760 SP3) on Windows 2000 Server
> 5.00.2195 SP4.
>
|||The command is executed via a Bash script that is started by the SQL Agent
as a DTS Package.
"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:%233w7T9fFGHA.3172@.TK2MSFTNGP10.phx.gbl...
> VERIFYONLY simply reads the backup. In SQL Server 2000, it essentially
read[vbcol=seagreen]
> the header. In SQL Server 2005, it reads the header, checksums, and page
> chain. It doesn't write the backup back out anywhere.
> What else is happening on your server when this runs?
> --
> Mike
> Mentor
> Solid Quality Learning
> http://www.solidqualitylearning.com
>
> "Paesmans Eric" <epa@.missioncriticalit.com> wrote in message
> news:43c3c8d5$0$440$6c56d894@.reader0.news.be.easyn et.net...
to
>

RESTORE VERIFYONLY - Disk space

What is the disk space required for RESTORE VERIFYONLY ?
Could it be the size of the database ?
I got a backup of 11.8 GB and only 11.3 GB free.
If I run RESTORE VERIFYONLY, it does not return anything (no 'The
backup set is valid.').
After that I always get MS Windows 'Device full' errors whenever I try to
save any
file even if I still have 11 GB free.
I may not event start the MS Windows event viewer
I have to reboot my server.
Could it be that RESTORE VERIFYONLY restores the DB in some temporary
file and that the space is not actually released after RESTORE
VERIFYONLY failed ?
If this is the case is there a way to specify a directory for RESTORE
VERIFYONLY ?
Thanks in advance.
PS I am using MS SQL Server 2000 (8.00.760 SP3) on Windows 2000 Server
5.00.2195 SP4.Hi, Eric
RESTORE VERIFYONLY only reads the backup, without writing anything in
any database (not even a temporary file), so free space is not an issue
when you use RESTORE VERIFYONLY (i.e. you can have only 1GB of free
space, and it would still work for a 11GB backup).
Razvan|||VERIFYONLY simply reads the backup. In SQL Server 2000, it essentially read
the header. In SQL Server 2005, it reads the header, checksums, and page
chain. It doesn't write the backup back out anywhere.
What else is happening on your server when this runs?
--
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Paesmans Eric" <epa@.missioncriticalit.com> wrote in message
news:43c3c8d5$0$440$6c56d894@.reader0.news.be.easynet.net...
> What is the disk space required for RESTORE VERIFYONLY ?
>
> Could it be the size of the database ?
>
> I got a backup of 11.8 GB and only 11.3 GB free.
>
> If I run RESTORE VERIFYONLY, it does not return anything (no 'The
> backup set is valid.').
>
> After that I always get MS Windows 'Device full' errors whenever I try to
> save any
> file even if I still have 11 GB free.
> I may not event start the MS Windows event viewer
> I have to reboot my server.
>
> Could it be that RESTORE VERIFYONLY restores the DB in some temporary
> file and that the space is not actually released after RESTORE
> VERIFYONLY failed ?
>
> If this is the case is there a way to specify a directory for RESTORE
> VERIFYONLY ?
>
> Thanks in advance.
>
> PS I am using MS SQL Server 2000 (8.00.760 SP3) on Windows 2000 Server
> 5.00.2195 SP4.
>|||The command is executed via a Bash script that is started by the SQL Agent
as a DTS Package.
"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:%233w7T9fFGHA.3172@.TK2MSFTNGP10.phx.gbl...
> VERIFYONLY simply reads the backup. In SQL Server 2000, it essentially
read
> the header. In SQL Server 2005, it reads the header, checksums, and page
> chain. It doesn't write the backup back out anywhere.
> What else is happening on your server when this runs?
> --
> Mike
> Mentor
> Solid Quality Learning
> http://www.solidqualitylearning.com
>
> "Paesmans Eric" <epa@.missioncriticalit.com> wrote in message
> news:43c3c8d5$0$440$6c56d894@.reader0.news.be.easynet.net...
> > What is the disk space required for RESTORE VERIFYONLY ?
> >
> >
> > Could it be the size of the database ?
> >
> >
> > I got a backup of 11.8 GB and only 11.3 GB free.
> >
> >
> > If I run RESTORE VERIFYONLY, it does not return anything (no 'The
> > backup set is valid.').
> >
> >
> > After that I always get MS Windows 'Device full' errors whenever I try
to
> > save any
> > file even if I still have 11 GB free.
> > I may not event start the MS Windows event viewer
> > I have to reboot my server.
> >
> >
> > Could it be that RESTORE VERIFYONLY restores the DB in some temporary
> > file and that the space is not actually released after RESTORE
> > VERIFYONLY failed ?
> >
> >
> > If this is the case is there a way to specify a directory for RESTORE
> > VERIFYONLY ?
> >
> >
> > Thanks in advance.
> >
> >
> > PS I am using MS SQL Server 2000 (8.00.760 SP3) on Windows 2000 Server
> > 5.00.2195 SP4.
> >
> >
>

RESTORE VERIFYONLY - Disk space

What is the disk space required for RESTORE VERIFYONLY ?
Could it be the size of the database ?
I got a backup of 11.8 GB and only 11.3 GB free.
If I run RESTORE VERIFYONLY, it does not return anything (no 'The
backup set is valid.').
After that I always get MS Windows 'Device full' errors whenever I try to
save any
file even if I still have 11 GB free.
I may not event start the MS Windows event viewer
I have to reboot my server.
Could it be that RESTORE VERIFYONLY restores the DB in some temporary
file and that the space is not actually released after RESTORE
VERIFYONLY failed ?
If this is the case is there a way to specify a directory for RESTORE
VERIFYONLY ?
Thanks in advance.
PS I am using MS SQL Server 2000 (8.00.760 SP3) on Windows 2000 Server
5.00.2195 SP4.Hi, Eric
RESTORE VERIFYONLY only reads the backup, without writing anything in
any database (not even a temporary file), so free space is not an issue
when you use RESTORE VERIFYONLY (i.e. you can have only 1GB of free
space, and it would still work for a 11GB backup).
Razvan|||VERIFYONLY simply reads the backup. In SQL Server 2000, it essentially read
the header. In SQL Server 2005, it reads the header, checksums, and page
chain. It doesn't write the backup back out anywhere.
What else is happening on your server when this runs?
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Paesmans Eric" <epa@.missioncriticalit.com> wrote in message
news:43c3c8d5$0$440$6c56d894@.reader0.news.be.easynet.net...
> What is the disk space required for RESTORE VERIFYONLY ?
>
> Could it be the size of the database ?
>
> I got a backup of 11.8 GB and only 11.3 GB free.
>
> If I run RESTORE VERIFYONLY, it does not return anything (no 'The
> backup set is valid.').
>
> After that I always get MS Windows 'Device full' errors whenever I try to
> save any
> file even if I still have 11 GB free.
> I may not event start the MS Windows event viewer
> I have to reboot my server.
>
> Could it be that RESTORE VERIFYONLY restores the DB in some temporary
> file and that the space is not actually released after RESTORE
> VERIFYONLY failed ?
>
> If this is the case is there a way to specify a directory for RESTORE
> VERIFYONLY ?
>
> Thanks in advance.
>
> PS I am using MS SQL Server 2000 (8.00.760 SP3) on Windows 2000 Server
> 5.00.2195 SP4.
>|||The command is executed via a Bash script that is started by the SQL Agent
as a DTS Package.
"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:%233w7T9fFGHA.3172@.TK2MSFTNGP10.phx.gbl...
> VERIFYONLY simply reads the backup. In SQL Server 2000, it essentially
read
> the header. In SQL Server 2005, it reads the header, checksums, and page
> chain. It doesn't write the backup back out anywhere.
> What else is happening on your server when this runs?
> --
> Mike
> Mentor
> Solid Quality Learning
> http://www.solidqualitylearning.com
>
> "Paesmans Eric" <epa@.missioncriticalit.com> wrote in message
> news:43c3c8d5$0$440$6c56d894@.reader0.news.be.easynet.net...
to[vbcol=seagreen]
>

Monday, March 26, 2012

Restore to different file size

My production database files total about 100GB, of which about 35GB is used.
My test machine has about 60GB available, so has plenty of room to
accommodate the entire database. When I try to restore a full backup though,
it screams at me that there is not enough disk space.
I created a new database with 40GB of data files, and that should be enough
to hold all the data. How can I keep the restore process from trying to
create exactly the same file configuration as the original database?
You can't.
The SQL restore process requires the creation of exactly the same file sizes
on the target system as existed on the originating system. I suggest
purchasing an external HDD, restorign to that, shrinking, then moving the
data files.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Daniel Rimmelzwaan (MVP - Dynamics NAV)" <daniel@.nadaspam.risplus.com>
wrote in message news:Ow$oUoH0HHA.1168@.TK2MSFTNGP02.phx.gbl...
> My production database files total about 100GB, of which about 35GB is
> used. My test machine has about 60GB available, so has plenty of room to
> accommodate the entire database. When I try to restore a full backup
> though, it screams at me that there is not enough disk space.
> I created a new database with 40GB of data files, and that should be
> enough to hold all the data. How can I keep the restore process from
> trying to create exactly the same file configuration as the original
> database?
|||I was afraid of that. Thanks Geoff.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OcDFQuH0HHA.1208@.TK2MSFTNGP03.phx.gbl...
> You can't.
> The SQL restore process requires the creation of exactly the same file
> sizes on the target system as existed on the originating system. I
> suggest purchasing an external HDD, restorign to that, shrinking, then
> moving the data files.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Daniel Rimmelzwaan (MVP - Dynamics NAV)" <daniel@.nadaspam.risplus.com>
> wrote in message news:Ow$oUoH0HHA.1168@.TK2MSFTNGP02.phx.gbl...
>

Restore to different file size

My production database files total about 100GB, of which about 35GB is used.
My test machine has about 60GB available, so has plenty of room to
accommodate the entire database. When I try to restore a full backup though,
it screams at me that there is not enough disk space.
I created a new database with 40GB of data files, and that should be enough
to hold all the data. How can I keep the restore process from trying to
create exactly the same file configuration as the original database?You can't.
The SQL restore process requires the creation of exactly the same file sizes
on the target system as existed on the originating system. I suggest
purchasing an external HDD, restorign to that, shrinking, then moving the
data files.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Daniel Rimmelzwaan (MVP - Dynamics NAV)" <daniel@.nadaspam.risplus.com>
wrote in message news:Ow$oUoH0HHA.1168@.TK2MSFTNGP02.phx.gbl...
> My production database files total about 100GB, of which about 35GB is
> used. My test machine has about 60GB available, so has plenty of room to
> accommodate the entire database. When I try to restore a full backup
> though, it screams at me that there is not enough disk space.
> I created a new database with 40GB of data files, and that should be
> enough to hold all the data. How can I keep the restore process from
> trying to create exactly the same file configuration as the original
> database?|||I was afraid of that. Thanks Geoff.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OcDFQuH0HHA.1208@.TK2MSFTNGP03.phx.gbl...
> You can't.
> The SQL restore process requires the creation of exactly the same file
> sizes on the target system as existed on the originating system. I
> suggest purchasing an external HDD, restorign to that, shrinking, then
> moving the data files.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Daniel Rimmelzwaan (MVP - Dynamics NAV)" <daniel@.nadaspam.risplus.com>
> wrote in message news:Ow$oUoH0HHA.1168@.TK2MSFTNGP02.phx.gbl...
>> My production database files total about 100GB, of which about 35GB is
>> used. My test machine has about 60GB available, so has plenty of room to
>> accommodate the entire database. When I try to restore a full backup
>> though, it screams at me that there is not enough disk space.
>> I created a new database with 40GB of data files, and that should be
>> enough to hold all the data. How can I keep the restore process from
>> trying to create exactly the same file configuration as the original
>> database?
>

Restore to different file size

My production database files total about 100GB, of which about 35GB is used.
My test machine has about 60GB available, so has plenty of room to
accommodate the entire database. When I try to restore a full backup though,
it screams at me that there is not enough disk space.
I created a new database with 40GB of data files, and that should be enough
to hold all the data. How can I keep the restore process from trying to
create exactly the same file configuration as the original database?You can't.
The SQL restore process requires the creation of exactly the same file sizes
on the target system as existed on the originating system. I suggest
purchasing an external HDD, restorign to that, shrinking, then moving the
data files.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Daniel Rimmelzwaan (MVP - Dynamics NAV)" <daniel@.nadaspam.risplus.com>
wrote in message news:Ow$oUoH0HHA.1168@.TK2MSFTNGP02.phx.gbl...
> My production database files total about 100GB, of which about 35GB is
> used. My test machine has about 60GB available, so has plenty of room to
> accommodate the entire database. When I try to restore a full backup
> though, it screams at me that there is not enough disk space.
> I created a new database with 40GB of data files, and that should be
> enough to hold all the data. How can I keep the restore process from
> trying to create exactly the same file configuration as the original
> database?|||I was afraid of that. Thanks Geoff.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OcDFQuH0HHA.1208@.TK2MSFTNGP03.phx.gbl...
> You can't.
> The SQL restore process requires the creation of exactly the same file
> sizes on the target system as existed on the originating system. I
> suggest purchasing an external HDD, restorign to that, shrinking, then
> moving the data files.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Daniel Rimmelzwaan (MVP - Dynamics NAV)" <daniel@.nadaspam.risplus.com>
> wrote in message news:Ow$oUoH0HHA.1168@.TK2MSFTNGP02.phx.gbl...
>

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 28, 2012

RESTORE VERIFYONLY - Disk space

RESTORE VERIFYONLY - Disk space

RESTORE VERIFYONLY - Disk space

Monday, March 26, 2012

Restore to different file size

Restore to different file size

Restore to different file size

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