I'm trying to do a Full Backup on a filegroup but
everytime I try to run it I get this error:
[SQLSTATE 01000] (Message 4035) BACKUP
DATABASE...FILE=<name> successfully processed 1625664
pages in 625.900 seconds (21.277 MB/sec). [SQLSTATE 01000]
(Message 3014) The value '0' is not within range for the
FILE parameter. [SQLSTATE 42000] (Error 3250) VERIFY
DATABASE is terminating abnormally. [SQLSTATE 42000]
(Error 3013). The step failed.
Does anyone have any idea as to why this is happening?
I'm running SQL2000 on a Win2K Server. SQL Books Online
is no help.
Thanks
JeroockoAs Jasper says you need to post the command the part of
your error 'The value '0' is not within range for the
FILE parameter', usually means an error in the code, wrong
file name, running against the wrong database, something
like that.
Regards
John
Showing posts with label message. Show all posts
Showing posts with label message. Show all posts
Friday, March 9, 2012
Filegroup & .NDF Question
This is a multi-part message in MIME format.
--=_NextPart_000_0008_01C68EFB.3FF73960
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
How can I change the FILEGROUP on database properties?
SQL Server 2000
I restored one database to create a new database, but the .ndf filegroup = of the restored db has the name of the restored db.
For example;
DB 1 =3D TestDB1.mdf TestINDX1.ndf TestLog1.ldf
Backup this db & restore as Test2
DB 2 =3D TestDB2.mdf TestINDX2.ndf (BUT in EM Properties under = filegroup it has "TestINDX1"
I tried dbcc shrinkfile(TestIndx2, emptyfile), so that I could just = delete the .NDF & recreate it in EM with the correct filegroup name, but = it keeps telling me I can't drop the .ndf because it is NOT empty.
Where am I going wrong?
Also, am I missing something in my restore? Is there T-Sql in the = restore that designates the .ndf filegroup name & I am missing it?
Any instruction/suggestions will be appreciated!!!
thanx!
--=_NextPart_000_0008_01C68EFB.3FF73960
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
How can I change the FILEGROUP on database properties?
SQL Server 2000
I restored one database to create a new = database, but the .ndf filegroup of the restored db has the name of the restored db.
For example;
DB 1 =3D TestDB1.mdf TestINDX1.ndf TestLog1.ldf
Backup this db & restore as = Test2
DB 2 =3D TestDB2.mdf = TestINDX2.ndf (BUT in EM Properties under filegroup it has "TestINDX1"
I tried dbcc shrinkfile(TestIndx2, = emptyfile), so that I could just delete the .NDF & recreate it in EM with the correct = filegroup name, but it keeps telling me I can't drop the .ndf because it is NOT empty.
Where am I going wrong?
Also, am I missing something in my = restore? Is there T-Sql in the restore that designates the .ndf filegroup name = & I am missing it?
Any instruction/suggestions will be appreciated!!!
thanx!
--=_NextPart_000_0008_01C68EFB.3FF73960--Jude,
1 - You can change the name of the physical files during restore operation
using "with move" option.
2 - You can change the logical name of the files, using the statement "alter
database".
alter database northwind
modify file (name = 'northwind', newname = 'northwind1')
exec sp_helpdb northwind
go
See BOL for more info.
AMB
"Jude" wrote:
> How can I change the FILEGROUP on database properties?
> SQL Server 2000
> I restored one database to create a new database, but the .ndf filegroup of the restored db has the name of the restored db.
> For example;
> DB 1 = TestDB1.mdf TestINDX1.ndf TestLog1.ldf
> Backup this db & restore as Test2
> DB 2 = TestDB2.mdf TestINDX2.ndf (BUT in EM Properties under filegroup it has "TestINDX1"
> I tried dbcc shrinkfile(TestIndx2, emptyfile), so that I could just delete the .NDF & recreate it in EM with the correct filegroup name, but it keeps telling me I can't drop the .ndf because it is NOT empty.
> Where am I going wrong?
> Also, am I missing something in my restore? Is there T-Sql in the restore that designates the .ndf filegroup name & I am missing it?
> Any instruction/suggestions will be appreciated!!!
> thanx!
>|||"With Move", I'll look it up in BOL.
thanx!
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:509ED16F-2201-4D31-835E-B5EAE48C53B0@.microsoft.com...
> Jude,
> 1 - You can change the name of the physical files during restore operation
> using "with move" option.
> 2 - You can change the logical name of the files, using the statement
> "alter
> database".
> alter database northwind
> modify file (name = 'northwind', newname = 'northwind1')
> exec sp_helpdb northwind
> go
> See BOL for more info.
>
> AMB
> "Jude" wrote:
>> How can I change the FILEGROUP on database properties?
>> SQL Server 2000
>> I restored one database to create a new database, but the .ndf filegroup
>> of the restored db has the name of the restored db.
>> For example;
>> DB 1 = TestDB1.mdf TestINDX1.ndf TestLog1.ldf
>> Backup this db & restore as Test2
>> DB 2 = TestDB2.mdf TestINDX2.ndf (BUT in EM Properties under filegroup
>> it has "TestINDX1"
>> I tried dbcc shrinkfile(TestIndx2, emptyfile), so that I could just
>> delete the .NDF & recreate it in EM with the correct filegroup name, but
>> it keeps telling me I can't drop the .ndf because it is NOT empty.
>> Where am I going wrong?
>> Also, am I missing something in my restore? Is there T-Sql in the
>> restore that designates the .ndf filegroup name & I am missing it?
>> Any instruction/suggestions will be appreciated!!!
>> thanx!
>>
--=_NextPart_000_0008_01C68EFB.3FF73960
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
How can I change the FILEGROUP on database properties?
SQL Server 2000
I restored one database to create a new database, but the .ndf filegroup = of the restored db has the name of the restored db.
For example;
DB 1 =3D TestDB1.mdf TestINDX1.ndf TestLog1.ldf
Backup this db & restore as Test2
DB 2 =3D TestDB2.mdf TestINDX2.ndf (BUT in EM Properties under = filegroup it has "TestINDX1"
I tried dbcc shrinkfile(TestIndx2, emptyfile), so that I could just = delete the .NDF & recreate it in EM with the correct filegroup name, but = it keeps telling me I can't drop the .ndf because it is NOT empty.
Where am I going wrong?
Also, am I missing something in my restore? Is there T-Sql in the = restore that designates the .ndf filegroup name & I am missing it?
Any instruction/suggestions will be appreciated!!!
thanx!
--=_NextPart_000_0008_01C68EFB.3FF73960
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
How can I change the FILEGROUP on database properties?
SQL Server 2000
I restored one database to create a new = database, but the .ndf filegroup of the restored db has the name of the restored db.
For example;
DB 1 =3D TestDB1.mdf TestINDX1.ndf TestLog1.ldf
Backup this db & restore as = Test2
DB 2 =3D TestDB2.mdf = TestINDX2.ndf (BUT in EM Properties under filegroup it has "TestINDX1"
I tried dbcc shrinkfile(TestIndx2, = emptyfile), so that I could just delete the .NDF & recreate it in EM with the correct = filegroup name, but it keeps telling me I can't drop the .ndf because it is NOT empty.
Where am I going wrong?
Also, am I missing something in my = restore? Is there T-Sql in the restore that designates the .ndf filegroup name = & I am missing it?
Any instruction/suggestions will be appreciated!!!
thanx!
--=_NextPart_000_0008_01C68EFB.3FF73960--Jude,
1 - You can change the name of the physical files during restore operation
using "with move" option.
2 - You can change the logical name of the files, using the statement "alter
database".
alter database northwind
modify file (name = 'northwind', newname = 'northwind1')
exec sp_helpdb northwind
go
See BOL for more info.
AMB
"Jude" wrote:
> How can I change the FILEGROUP on database properties?
> SQL Server 2000
> I restored one database to create a new database, but the .ndf filegroup of the restored db has the name of the restored db.
> For example;
> DB 1 = TestDB1.mdf TestINDX1.ndf TestLog1.ldf
> Backup this db & restore as Test2
> DB 2 = TestDB2.mdf TestINDX2.ndf (BUT in EM Properties under filegroup it has "TestINDX1"
> I tried dbcc shrinkfile(TestIndx2, emptyfile), so that I could just delete the .NDF & recreate it in EM with the correct filegroup name, but it keeps telling me I can't drop the .ndf because it is NOT empty.
> Where am I going wrong?
> Also, am I missing something in my restore? Is there T-Sql in the restore that designates the .ndf filegroup name & I am missing it?
> Any instruction/suggestions will be appreciated!!!
> thanx!
>|||"With Move", I'll look it up in BOL.
thanx!
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:509ED16F-2201-4D31-835E-B5EAE48C53B0@.microsoft.com...
> Jude,
> 1 - You can change the name of the physical files during restore operation
> using "with move" option.
> 2 - You can change the logical name of the files, using the statement
> "alter
> database".
> alter database northwind
> modify file (name = 'northwind', newname = 'northwind1')
> exec sp_helpdb northwind
> go
> See BOL for more info.
>
> AMB
> "Jude" wrote:
>> How can I change the FILEGROUP on database properties?
>> SQL Server 2000
>> I restored one database to create a new database, but the .ndf filegroup
>> of the restored db has the name of the restored db.
>> For example;
>> DB 1 = TestDB1.mdf TestINDX1.ndf TestLog1.ldf
>> Backup this db & restore as Test2
>> DB 2 = TestDB2.mdf TestINDX2.ndf (BUT in EM Properties under filegroup
>> it has "TestINDX1"
>> I tried dbcc shrinkfile(TestIndx2, emptyfile), so that I could just
>> delete the .NDF & recreate it in EM with the correct filegroup name, but
>> it keeps telling me I can't drop the .ndf because it is NOT empty.
>> Where am I going wrong?
>> Also, am I missing something in my restore? Is there T-Sql in the
>> restore that designates the .ndf filegroup name & I am missing it?
>> Any instruction/suggestions will be appreciated!!!
>> thanx!
>>
Sunday, February 26, 2012
File Size Limitation
Hi,
I'm trying to upload word documet to report server. I got an error message
that maximum size exceeded. Can anyone tell what's the limitation of size of
the file to be uploaded?
--
Thanks,
IDYou may want to check this related thread:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=74513284-1467-4a32-b711-bdd7598292e0&sloc=en-us
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"exkievan" <exkievan@.discussions.microsoft.com> wrote in message
news:5E3FA1CA-1C7D-45AB-9F3D-668D26899239@.microsoft.com...
> Hi,
> I'm trying to upload word documet to report server. I got an error message
> that maximum size exceeded. Can anyone tell what's the limitation of size
> of
> the file to be uploaded?
> --
> Thanks,
> ID|||Thanks
"Robert Bruckner [MSFT]" wrote:
> You may want to check this related thread:
> http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=74513284-1467-4a32-b711-bdd7598292e0&sloc=en-us
>
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "exkievan" <exkievan@.discussions.microsoft.com> wrote in message
> news:5E3FA1CA-1C7D-45AB-9F3D-668D26899239@.microsoft.com...
> > Hi,
> >
> > I'm trying to upload word documet to report server. I got an error message
> > that maximum size exceeded. Can anyone tell what's the limitation of size
> > of
> > the file to be uploaded?
> > --
> > Thanks,
> >
> > ID
>
>
I'm trying to upload word documet to report server. I got an error message
that maximum size exceeded. Can anyone tell what's the limitation of size of
the file to be uploaded?
--
Thanks,
IDYou may want to check this related thread:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=74513284-1467-4a32-b711-bdd7598292e0&sloc=en-us
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"exkievan" <exkievan@.discussions.microsoft.com> wrote in message
news:5E3FA1CA-1C7D-45AB-9F3D-668D26899239@.microsoft.com...
> Hi,
> I'm trying to upload word documet to report server. I got an error message
> that maximum size exceeded. Can anyone tell what's the limitation of size
> of
> the file to be uploaded?
> --
> Thanks,
> ID|||Thanks
"Robert Bruckner [MSFT]" wrote:
> You may want to check this related thread:
> http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=74513284-1467-4a32-b711-bdd7598292e0&sloc=en-us
>
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "exkievan" <exkievan@.discussions.microsoft.com> wrote in message
> news:5E3FA1CA-1C7D-45AB-9F3D-668D26899239@.microsoft.com...
> > Hi,
> >
> > I'm trying to upload word documet to report server. I got an error message
> > that maximum size exceeded. Can anyone tell what's the limitation of size
> > of
> > the file to be uploaded?
> > --
> > Thanks,
> >
> > ID
>
>
Friday, February 24, 2012
file name or extension is too long
Hi All,
I am receiving the following message when I run Dts package which is
creating a cube.
Error Source : Microsoft Data transmission Services (DTS)
Package
Error Description: File name or extension is too long
Any help will be appreciated!
Thanks in advance,
Mohammed Sarwar
Ocp dba oracle 9i,8i,8.0
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Mohammed Sarwar <msarwar@.ubid.com> wrote in message news:<3fb3f814$0$193$75868355@.news.frii.net>...
> Hi All,
> I am receiving the following message when I run Dts package which is
> creating a cube.
> Error Source : Microsoft Data transmission Services (DTS)
> Package
> Error Description: File name or extension is too long
> Any help will be appreciated!
> Thanks in advance,
> Mohammed Sarwar
> Ocp dba oracle 9i,8i,8.0
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
You didn't mention which version of SQL Server you have, but if it's
7, then this KB article may apply to you:
http://support.microsoft.com/defaul...kb;en-us;243545
If the article isn't helpful, then you should post some more
information - your version of SQL Server, which step the package is
failing on etc. You might also want to post to
microsoft.public.sqlserver.dts.
Simon
Subscribe to:
Posts (Atom)