|
|
You're in the
sql server programming
group:sp_helpdb & sysaltfiles
sql server programming:
This is with reference with to my previous post with same subject. Hello All, My database name is hriscomp. I wanted to increase the FILEGROWTH parameter of the database using EM. It failed saying that : Error 5041: MODIFY FILE failed. File 'comp_Data' does not exist (Eventhough the property of the database shows 'comp_Data' and 'comp_Log' as the Logical Name). Then I tried using ALTER DATABASE hriscomp MODIFY FILE (Name=comp_Data, FILEGROWTH=50%) But If I try ALTER DATABASE hriscomp MODIFY FILE (Name=hriscomp_Data, FILEGROWTH=50%), it works. Then I queried the following, sp_helpdb hriscomp name fileName filegroup Growth comp_Data d:\apps\Microsoft SQL Server\MSSQL\data\hriscomp_Data.MDF PRIMARY 30% comp_Log d:\apps\Microsoft SQL Server\MSSQL\data\hriscomp_Log.LDF NULL 10% SELECT * FROM sysfiles1 status fileid name filename 32770 1 comp_Data d:\apps\Microsoft SQL Server\MSSQL\data\hriscomp_Data.MDF 32834 2 comp_Log d:\apps\Microsoft SQL Server\MSSQL\data\hriscomp_Log.LDF SELECT * FROM sysFiles status name filename 1081346 comp_Data d:\apps\Microsoft SQL Server\MSSQL\data\hriscomp_Data.MDF 1081410 comp_Log d:\apps\Microsoft SQL Server\MSSQL\data\hriscomp_Log.LDF master.dbo.sysaltfiles WHERE DBID=7 Growth dbid name filename 30 7 hriscomp_Data d:\apps\Microsoft SQL Server\MSSQL\data\hriscomp_Data.MDF 10 7 hriscomp_Log d:\apps\Microsoft SQL Server\MSSQL\data\hriscomp_Log.LDF If you note that sysaltfiles system table different name than other system tables. Can anyone tell me how it could have happened? And how to deal with this problem? Thanks in advance
Hi,
I restarted SQL Server also, but it did not help. Also I tried using QA(I have mentioned in the post), but it fails. Thanks anand [quoted text, click to view] >-----Original Message-----
>Anand >Try stop and start EM but I'd recommend you to use QA rather than EM. > >"Anand" <anonymous@discussions.microsoft.com> wrote in message >news:06e101c39de0$f077e410$a501280a@phx.gbl... >> Hi all, >> This is with reference with to my previous post with >> same subject. >> >> Hello All, >> My database name is hriscomp. >> I wanted to increase the FILEGROWTH parameter of the >> database using EM. It failed saying that : >> Error 5041: MODIFY FILE failed. File 'comp_Data' does not >> exist (Eventhough the property of the database >> shows 'comp_Data' >> and 'comp_Log' as the Logical Name). >> Then I tried using ALTER DATABASE hriscomp MODIFY FILE >> (Name=comp_Data, FILEGROWTH=50%) >> >> But If I try ALTER DATABASE hriscomp MODIFY FILE >> (Name=hriscomp_Data, FILEGROWTH=50%), it works. >> >> Then I queried the following, >> >> sp_helpdb hriscomp >> name fileName >> filegroup Growth >> comp_Data d:\apps\Microsoft SQL >> Server\MSSQL\data\hriscomp_Data.MDF PRIMARY 30% >> comp_Log d:\apps\Microsoft SQL >> Server\MSSQL\data\hriscomp_Log.LDF NULL 10% >> >> SELECT * FROM sysfiles1 >> >> status fileid name filename >> 32770 1 comp_Data d:\apps\Microsoft SQL >> Server\MSSQL\data\hriscomp_Data.MDF >> >> 32834 2 comp_Log d:\apps\Microsoft SQL >> Server\MSSQL\data\hriscomp_Log.LDF >> >> >> >> >> >> >> >> SELECT * FROM sysFiles >> >> status name filename >> 1081346 comp_Data d:\apps\Microsoft SQL >> Server\MSSQL\data\hriscomp_Data.MDF >> >> 1081410 comp_Log d:\apps\Microsoft SQL >> Server\MSSQL\data\hriscomp_Log.LDF >> >> >> >> master.dbo.sysaltfiles WHERE DBID=7 >> >> Growth dbid name filename >> 30 7 hriscomp_Data d:\apps\Microsoft SQL >> Server\MSSQL\data\hriscomp_Data.MDF >> 10 7 hriscomp_Log d:\apps\Microsoft SQL >> Server\MSSQL\data\hriscomp_Log.LDF >> >> >> If you note that sysaltfiles system table different name >> than other system tables. Can anyone tell me how it could >> have happened? And how to deal with this problem? >> >> Thanks in advance >> >> Anand > > >.
Hi,
Yea it is true, but this statement fails: ALTER DATABASE hriscomp MODIFY FILE (Name=comp_Data, FILEGROWTH=50%) Note: I am using Name='comp_Data'. sp_helpdb hrisComp and other system tables except sysaltfiles gave the logical name has 'comp_Data'. So naturally we tend to use the above Alter Database statement with 'comp_data' instead of 'hriscomp_data' Regards Anand [quoted text, click to view] >-----Original Message-----
>Anand >You said : >"But If I try ALTER DATABASE hriscomp MODIFY FILE >(Name=hriscomp_Data, FILEGROWTH=50%), it works." > > > > > >"Anand" <anonymous@discussions.microsoft.com> wrote in message >news:012501c39de8$e8fbdea0$a001280a@phx.gbl... >> Hi, >> I restarted SQL Server also, but it did not help. Also >> I tried using QA(I have mentioned in the post), but it >> fails. >> >> Thanks >> anand >> >> >-----Original Message----- >> >Anand >> >Try stop and start EM but I'd recommend you to use QA >> rather than EM. >> > >> >"Anand" <anonymous@discussions.microsoft.com> wrote in >> message >> >news:06e101c39de0$f077e410$a501280a@phx.gbl... >> >> Hi all, >> >> This is with reference with to my previous post with >> >> same subject. >> >> >> >> Hello All, >> >> My database name is hriscomp. >> >> I wanted to increase the FILEGROWTH parameter of >> the >> >> database using EM. It failed saying that : >> >> Error 5041: MODIFY FILE failed. File 'comp_Data' does >> not >> >> exist (Eventhough the property of the database >> >> shows 'comp_Data' >> >> and 'comp_Log' as the Logical Name). >> >> Then I tried using ALTER DATABASE hriscomp MODIFY FILE >> >> (Name=comp_Data, FILEGROWTH=50%) >> >> >> >> But If I try ALTER DATABASE hriscomp MODIFY FILE >> >> (Name=hriscomp_Data, FILEGROWTH=50%), it works. >> >> >> >> Then I queried the following, >> >> >> >> sp_helpdb hriscomp >> >> name fileName >> >> filegroup Growth >> >> comp_Data d:\apps\Microsoft SQL >> >> Server\MSSQL\data\hriscomp_Data.MDF PRIMARY 30% >> >> comp_Log d:\apps\Microsoft SQL >> >> Server\MSSQL\data\hriscomp_Log.LDF NULL 10% >> >> >> >> SELECT * FROM sysfiles1 >> >> >> >> status fileid name filename >> >> 32770 1 comp_Data d:\apps\Microsoft SQL >> >> Server\MSSQL\data\hriscomp_Data.MDF >> >> >> >> 32834 2 comp_Log d:\apps\Microsoft SQL >> >> Server\MSSQL\data\hriscomp_Log.LDF >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> SELECT * FROM sysFiles >> >> >> >> status name filename >> >> 1081346 comp_Data d:\apps\Microsoft SQL >> >> Server\MSSQL\data\hriscomp_Data.MDF >> >> >> >> 1081410 comp_Log d:\apps\Microsoft SQL >> >> Server\MSSQL\data\hriscomp_Log.LDF >> >> >> >> >> >> >> >> master.dbo.sysaltfiles WHERE DBID=7 >> >> >> >> Growth dbid name filename >> >> 30 7 hriscomp_Data d:\apps\Microsoft SQL >> >> Server\MSSQL\data\hriscomp_Data.MDF >> >> 10 7 hriscomp_Log d:\apps\Microsoft SQL >> >> Server\MSSQL\data\hriscomp_Log.LDF >> >> >> >> >> >> If you note that sysaltfiles system table different name >> >> than other system tables. Can anyone tell me how it >> could >> >> have happened? And how to deal with this problem? >> >> >> >> Thanks in advance >> >> >> >> Anand >> > >> > >> >. >> > > > >.
Anand
Try stop and start EM but I'd recommend you to use QA rather than EM. [quoted text, click to view] "Anand" <anonymous@discussions.microsoft.com> wrote in message news:06e101c39de0$f077e410$a501280a@phx.gbl... > Hi all, > This is with reference with to my previous post with > same subject. > > Hello All, > My database name is hriscomp. > I wanted to increase the FILEGROWTH parameter of the > database using EM. It failed saying that : > Error 5041: MODIFY FILE failed. File 'comp_Data' does not > exist (Eventhough the property of the database > shows 'comp_Data' > and 'comp_Log' as the Logical Name). > Then I tried using ALTER DATABASE hriscomp MODIFY FILE > (Name=comp_Data, FILEGROWTH=50%) > > But If I try ALTER DATABASE hriscomp MODIFY FILE > (Name=hriscomp_Data, FILEGROWTH=50%), it works. > > Then I queried the following, > > sp_helpdb hriscomp > name fileName > filegroup Growth > comp_Data d:\apps\Microsoft SQL > Server\MSSQL\data\hriscomp_Data.MDF PRIMARY 30% > comp_Log d:\apps\Microsoft SQL > Server\MSSQL\data\hriscomp_Log.LDF NULL 10% > > SELECT * FROM sysfiles1 > > status fileid name filename > 32770 1 comp_Data d:\apps\Microsoft SQL > Server\MSSQL\data\hriscomp_Data.MDF > > 32834 2 comp_Log d:\apps\Microsoft SQL > Server\MSSQL\data\hriscomp_Log.LDF > > > > > > > > SELECT * FROM sysFiles > > status name filename > 1081346 comp_Data d:\apps\Microsoft SQL > Server\MSSQL\data\hriscomp_Data.MDF > > 1081410 comp_Log d:\apps\Microsoft SQL > Server\MSSQL\data\hriscomp_Log.LDF > > > > master.dbo.sysaltfiles WHERE DBID=7 > > Growth dbid name filename > 30 7 hriscomp_Data d:\apps\Microsoft SQL > Server\MSSQL\data\hriscomp_Data.MDF > 10 7 hriscomp_Log d:\apps\Microsoft SQL > Server\MSSQL\data\hriscomp_Log.LDF > > > If you note that sysaltfiles system table different name > than other system tables. Can anyone tell me how it could > have happened? And how to deal with this problem? > > Thanks in advance > > Anand
Anand
You said : "But If I try ALTER DATABASE hriscomp MODIFY FILE (Name=hriscomp_Data, FILEGROWTH=50%), it works." [quoted text, click to view] "Anand" <anonymous@discussions.microsoft.com> wrote in message news:012501c39de8$e8fbdea0$a001280a@phx.gbl... > Hi, > I restarted SQL Server also, but it did not help. Also > I tried using QA(I have mentioned in the post), but it > fails. > > Thanks > anand > > >-----Original Message----- > >Anand > >Try stop and start EM but I'd recommend you to use QA > rather than EM. > > > >"Anand" <anonymous@discussions.microsoft.com> wrote in > message > >news:06e101c39de0$f077e410$a501280a@phx.gbl... > >> Hi all, > >> This is with reference with to my previous post with > >> same subject. > >> > >> Hello All, > >> My database name is hriscomp. > >> I wanted to increase the FILEGROWTH parameter of > the > >> database using EM. It failed saying that : > >> Error 5041: MODIFY FILE failed. File 'comp_Data' does > not > >> exist (Eventhough the property of the database > >> shows 'comp_Data' > >> and 'comp_Log' as the Logical Name). > >> Then I tried using ALTER DATABASE hriscomp MODIFY FILE > >> (Name=comp_Data, FILEGROWTH=50%) > >> > >> But If I try ALTER DATABASE hriscomp MODIFY FILE > >> (Name=hriscomp_Data, FILEGROWTH=50%), it works. > >> > >> Then I queried the following, > >> > >> sp_helpdb hriscomp > >> name fileName > >> filegroup Growth > >> comp_Data d:\apps\Microsoft SQL > >> Server\MSSQL\data\hriscomp_Data.MDF PRIMARY 30% > >> comp_Log d:\apps\Microsoft SQL > >> Server\MSSQL\data\hriscomp_Log.LDF NULL 10% > >> > >> SELECT * FROM sysfiles1 > >> > >> status fileid name filename > >> 32770 1 comp_Data d:\apps\Microsoft SQL > >> Server\MSSQL\data\hriscomp_Data.MDF > >> > >> 32834 2 comp_Log d:\apps\Microsoft SQL > >> Server\MSSQL\data\hriscomp_Log.LDF > >> > >> > >> > >> > >> > >> > >> > >> SELECT * FROM sysFiles > >> > >> status name filename > >> 1081346 comp_Data d:\apps\Microsoft SQL > >> Server\MSSQL\data\hriscomp_Data.MDF > >> > >> 1081410 comp_Log d:\apps\Microsoft SQL > >> Server\MSSQL\data\hriscomp_Log.LDF > >> > >> > >> > >> master.dbo.sysaltfiles WHERE DBID=7 > >> > >> Growth dbid name filename > >> 30 7 hriscomp_Data d:\apps\Microsoft SQL > >> Server\MSSQL\data\hriscomp_Data.MDF > >> 10 7 hriscomp_Log d:\apps\Microsoft SQL > >> Server\MSSQL\data\hriscomp_Log.LDF > >> > >> > >> If you note that sysaltfiles system table different name > >> than other system tables. Can anyone tell me how it > could > >> have happened? And how to deal with this problem? > >> > >> Thanks in advance > >> > >> Anand > > > > > >. > >
Anand,
try to change Logical Name to other alter database hriscomp modify file ( name=comp_Data, newname=newcomp_Data) I hope this will correct you DB Andrew [quoted text, click to view] "Anand" <anonymous@discussions.microsoft.com> wrote in message news:0ae901c39df5$f49f3a10$a101280a@phx.gbl... > Hi, > Yea it is true, but this statement fails: > > ALTER DATABASE hriscomp MODIFY FILE > (Name=comp_Data, FILEGROWTH=50%) > > Note: I am using Name='comp_Data'. > sp_helpdb hrisComp and > other system tables except sysaltfiles gave the logical > name has 'comp_Data'. > So naturally we tend to use the above Alter Database > statement with 'comp_data' instead of 'hriscomp_data' > > Regards > Anand > > >-----Original Message----- > >Anand > >You said : > >"But If I try ALTER DATABASE hriscomp MODIFY FILE > >(Name=hriscomp_Data, FILEGROWTH=50%), it works." > > > > > > > > > > > >"Anand" <anonymous@discussions.microsoft.com> wrote in > message > >news:012501c39de8$e8fbdea0$a001280a@phx.gbl... > >> Hi, > >> I restarted SQL Server also, but it did not help. > Also > >> I tried using QA(I have mentioned in the post), but it > >> fails. > >> > >> Thanks > >> anand > >> > >> >-----Original Message----- > >> >Anand > >> >Try stop and start EM but I'd recommend you to use QA > >> rather than EM. > >> > > >> >"Anand" <anonymous@discussions.microsoft.com> wrote in > >> message > >> >news:06e101c39de0$f077e410$a501280a@phx.gbl... > >> >> Hi all, > >> >> This is with reference with to my previous post > with > >> >> same subject. > >> >> > >> >> Hello All, > >> >> My database name is hriscomp. > >> >> I wanted to increase the FILEGROWTH parameter of > >> the > >> >> database using EM. It failed saying that : > >> >> Error 5041: MODIFY FILE failed. File 'comp_Data' > does > >> not > >> >> exist (Eventhough the property of the database > >> >> shows 'comp_Data' > >> >> and 'comp_Log' as the Logical Name). > >> >> Then I tried using ALTER DATABASE hriscomp MODIFY > FILE > >> >> (Name=comp_Data, FILEGROWTH=50%) > >> >> > >> >> But If I try ALTER DATABASE hriscomp MODIFY FILE > >> >> (Name=hriscomp_Data, FILEGROWTH=50%), it works. > >> >> > >> >> Then I queried the following, > >> >> > >> >> sp_helpdb hriscomp > >> >> name fileName > >> >> filegroup Growth > >> >> comp_Data d:\apps\Microsoft SQL > >> >> Server\MSSQL\data\hriscomp_Data.MDF PRIMARY 30% > >> >> comp_Log d:\apps\Microsoft SQL > >> >> Server\MSSQL\data\hriscomp_Log.LDF NULL 10% > >> >> > >> >> SELECT * FROM sysfiles1 > >> >> > >> >> status fileid name filename > >> >> 32770 1 comp_Data d:\apps\Microsoft SQL > >> >> Server\MSSQL\data\hriscomp_Data.MDF > >> >> > >> >> 32834 2 comp_Log d:\apps\Microsoft SQL > >> >> Server\MSSQL\data\hriscomp_Log.LDF > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> SELECT * FROM sysFiles > >> >> > >> >> status name filename > >> >> 1081346 comp_Data d:\apps\Microsoft SQL > >> >> Server\MSSQL\data\hriscomp_Data.MDF > >> >> > >> >> 1081410 comp_Log d:\apps\Microsoft SQL > >> >> Server\MSSQL\data\hriscomp_Log.LDF > >> >> > >> >> > >> >> > >> >> master.dbo.sysaltfiles WHERE DBID=7 > >> >> > >> >> Growth dbid name filename > >> >> 30 7 hriscomp_Data d:\apps\Microsoft SQL > >> >> Server\MSSQL\data\hriscomp_Data.MDF > >> >> 10 7 hriscomp_Log d:\apps\Microsoft SQL > >> >> Server\MSSQL\data\hriscomp_Log.LDF > >> >> > >> >> > >> >> If you note that sysaltfiles system table different > name > >> >> than other system tables. Can anyone tell me how it > >> could > >> >> have happened? And how to deal with this problem? > >> >> > >> >> Thanks in advance > >> >> > >> >> Anand > >> > > >> > > >> >. > >> > > > > > > >. > >
Don't see what you're looking for? Try a search.
|
January 2003
March 2003
April 2003
May 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
April 2008
| home · blog · groups | Questions? Comments? Contact the dn |