Can't shrink database or files

I can't shrink my data file using either DBCC SHRINKDATABASE or DBCC
SHRINKFILE.
SHRINKDATABASE appears to complete okay but there is still a lot of excess
space in the database (more than half).
SHRINKFILE gives the error "Could not locate file '<filename>' in sysfiles"
but the filename is the correct logical file name of my data file and I
checked in sysfiles that it exists and the data file location is correct.
Can anyone tell me what the problem might be? Is there another way to shrink
the database?
Thanks
Are you in the right database when you issue the DBCC SHRINKFILE command?
DBCC SHRINKDATABASE takes the db name as a parameter, but SHRINKFILE does
not. It works on the current database.
If you are in the right database, can you show us the output of sp_helpfile,
and show us the exact command you are trying to run?
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"J Jetson" <JJetson@.discussions.microsoft.com> wrote in message
news:C065C200-4C54-4AF9-91AB-6EF1C320D66E@.microsoft.com...
>I can't shrink my data file using either DBCC SHRINKDATABASE or DBCC
> SHRINKFILE.
> SHRINKDATABASE appears to complete okay but there is still a lot of excess
> space in the database (more than half).
> SHRINKFILE gives the error "Could not locate file '<filename>' in
> sysfiles"
> but the filename is the correct logical file name of my data file and I
> checked in sysfiles that it exists and the data file location is correct.
> Can anyone tell me what the problem might be? Is there another way to
> shrink
> the database?
> Thanks
|||Hi,
SHRINKDATABASE command will not shrink the file if there is any active open
transactions. Execute the command DBCC OPENTRAN(DBNAME)
to identify if there is any actiove open tran. Wait for those tranasctions
to close or kill the SPID which is open.
If you still face issues in shrinking then set the database to Single user
and shrink:-
Steps you can do to shrink the transaction log file:-
1. Backup the transaction log using the below command.
backup log <dbname> to disk='c:\backup\dbname.trn'
2. Bring the database to single user
Alter database <dbname> set single_user with rollback immediate
3. Shrink the database log file
dbcc shrinkdatabase(DBNAME) -- See books online for usage
4. Bring the database to multi user
alter database <dbname> set multi_user
WyHY SHRINK FILE is giving error:-
As Kalen pointed, you are not in the right database
Steps:-
use <dbname>
go
sp_helpfile
Based on the name column for the transaction log file execute the dbcc
shrinkfile
dbcc shrinkfile('name_given_by_sp_hXelpfile','truncateo nly')
(Execute the DBCC SQLPERF(LOGSPACE) to identify that the log is shrink)
Thanks
Hari
SQL Server MVP
"J Jetson" <JJetson@.discussions.microsoft.com> wrote in message
news:C065C200-4C54-4AF9-91AB-6EF1C320D66E@.microsoft.com...
> I can't shrink my data file using either DBCC SHRINKDATABASE or DBCC
> SHRINKFILE.
> SHRINKDATABASE appears to complete okay but there is still a lot of excess
> space in the database (more than half).
> SHRINKFILE gives the error "Could not locate file '<filename>' in
sysfiles"
> but the filename is the correct logical file name of my data file and I
> checked in sysfiles that it exists and the data file location is correct.
> Can anyone tell me what the problem might be? Is there another way to
shrink
> the database?
> Thanks
|||Nonsense. Shrink will happily wait for any locks it requires and then
continue - that's the whole point of it being online.
Do you have LOB columns in the database (select * from sysindexes where
indid=255)? If you've deleted a bunch of LOB data, this cannot be reclaimed
without bcp out/in or using select/into. This is fixed in SQL Server 2005.
Thanks
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OLwbMHhVFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Hi,
> SHRINKDATABASE command will not shrink the file if there is any active
open[vbcol=seagreen]
> transactions. Execute the command DBCC OPENTRAN(DBNAME)
> to identify if there is any actiove open tran. Wait for those tranasctions
> to close or kill the SPID which is open.
> If you still face issues in shrinking then set the database to Single user
> and shrink:-
> Steps you can do to shrink the transaction log file:-
>
> 1. Backup the transaction log using the below command.
> backup log <dbname> to disk='c:\backup\dbname.trn'
> 2. Bring the database to single user
> Alter database <dbname> set single_user with rollback immediate
> 3. Shrink the database log file
> dbcc shrinkdatabase(DBNAME) -- See books online for usage
> 4. Bring the database to multi user
> alter database <dbname> set multi_user
> ----
> WyHY SHRINK FILE is giving error:-
> As Kalen pointed, you are not in the right database
> Steps:-
> use <dbname>
> go
> sp_helpfile
> Based on the name column for the transaction log file execute the dbcc
> shrinkfile
>
> dbcc shrinkfile('name_given_by_sp_hXelpfile','truncateo nly')
>
> (Execute the DBCC SQLPERF(LOGSPACE) to identify that the log is shrink)
>
> Thanks
> Hari
> SQL Server MVP
>
>
> "J Jetson" <JJetson@.discussions.microsoft.com> wrote in message
> news:C065C200-4C54-4AF9-91AB-6EF1C320D66E@.microsoft.com...
excess[vbcol=seagreen]
> sysfiles"
correct.
> shrink
>

Can't shrink database or files

I can't shrink my data file using either DBCC SHRINKDATABASE or DBCC
SHRINKFILE.
SHRINKDATABASE appears to complete okay but there is still a lot of excess
space in the database (more than half).
SHRINKFILE gives the error "Could not locate file '<filename>' in sysfiles"
but the filename is the correct logical file name of my data file and I
checked in sysfiles that it exists and the data file location is correct.
Can anyone tell me what the problem might be? Is there another way to shrink
the database?
ThanksAre you in the right database when you issue the DBCC SHRINKFILE command?
DBCC SHRINKDATABASE takes the db name as a parameter, but SHRINKFILE does
not. It works on the current database.
If you are in the right database, can you show us the output of sp_helpfile,
and show us the exact command you are trying to run?
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"J Jetson" <JJetson@.discussions.microsoft.com> wrote in message
news:C065C200-4C54-4AF9-91AB-6EF1C320D66E@.microsoft.com...
>I can't shrink my data file using either DBCC SHRINKDATABASE or DBCC
> SHRINKFILE.
> SHRINKDATABASE appears to complete okay but there is still a lot of excess
> space in the database (more than half).
> SHRINKFILE gives the error "Could not locate file '<filename>' in
> sysfiles"
> but the filename is the correct logical file name of my data file and I
> checked in sysfiles that it exists and the data file location is correct.
> Can anyone tell me what the problem might be? Is there another way to
> shrink
> the database?
> Thanks|||Hi,
SHRINKDATABASE command will not shrink the file if there is any active open
transactions. Execute the command DBCC OPENTRAN(DBNAME)
to identify if there is any actiove open tran. Wait for those tranasctions
to close or kill the SPID which is open.
If you still face issues in shrinking then set the database to Single user
and shrink:-
Steps you can do to shrink the transaction log file:-
1. Backup the transaction log using the below command.
backup log <dbname> to disk='c:\backup\dbname.trn'
2. Bring the database to single user
Alter database <dbname> set single_user with rollback immediate
3. Shrink the database log file
dbcc shrinkdatabase(DBNAME) -- See books online for usage
4. Bring the database to multi user
alter database <dbname> set multi_user
----
WyHY SHRINK FILE is giving error:-
As Kalen pointed, you are not in the right database
Steps:-
use <dbname>
go
sp_helpfile
Based on the name column for the transaction log file execute the dbcc
shrinkfile
dbcc shrinkfile('name_given_by_sp_h­elpfile','truncateonly')
(Execute the DBCC SQLPERF(LOGSPACE) to identify that the log is shrink)
Thanks
Hari
SQL Server MVP
"J Jetson" <JJetson@.discussions.microsoft.com> wrote in message
news:C065C200-4C54-4AF9-91AB-6EF1C320D66E@.microsoft.com...
> I can't shrink my data file using either DBCC SHRINKDATABASE or DBCC
> SHRINKFILE.
> SHRINKDATABASE appears to complete okay but there is still a lot of excess
> space in the database (more than half).
> SHRINKFILE gives the error "Could not locate file '<filename>' in
sysfiles"
> but the filename is the correct logical file name of my data file and I
> checked in sysfiles that it exists and the data file location is correct.
> Can anyone tell me what the problem might be? Is there another way to
shrink
> the database?
> Thanks|||Nonsense. Shrink will happily wait for any locks it requires and then
continue - that's the whole point of it being online.
Do you have LOB columns in the database (select * from sysindexes where
indid=255)? If you've deleted a bunch of LOB data, this cannot be reclaimed
without bcp out/in or using select/into. This is fixed in SQL Server 2005.
Thanks
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OLwbMHhVFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Hi,
> SHRINKDATABASE command will not shrink the file if there is any active
open
> transactions. Execute the command DBCC OPENTRAN(DBNAME)
> to identify if there is any actiove open tran. Wait for those tranasctions
> to close or kill the SPID which is open.
> If you still face issues in shrinking then set the database to Single user
> and shrink:-
> Steps you can do to shrink the transaction log file:-
>
> 1. Backup the transaction log using the below command.
> backup log <dbname> to disk='c:\backup\dbname.trn'
> 2. Bring the database to single user
> Alter database <dbname> set single_user with rollback immediate
> 3. Shrink the database log file
> dbcc shrinkdatabase(DBNAME) -- See books online for usage
> 4. Bring the database to multi user
> alter database <dbname> set multi_user
> ----
> WyHY SHRINK FILE is giving error:-
> As Kalen pointed, you are not in the right database
> Steps:-
> use <dbname>
> go
> sp_helpfile
> Based on the name column for the transaction log file execute the dbcc
> shrinkfile
>
> dbcc shrinkfile('name_given_by_sp_h­elpfile','truncateonly')
>
> (Execute the DBCC SQLPERF(LOGSPACE) to identify that the log is shrink)
>
> Thanks
> Hari
> SQL Server MVP
>
>
> "J Jetson" <JJetson@.discussions.microsoft.com> wrote in message
> news:C065C200-4C54-4AF9-91AB-6EF1C320D66E@.microsoft.com...
> > I can't shrink my data file using either DBCC SHRINKDATABASE or DBCC
> > SHRINKFILE.
> >
> > SHRINKDATABASE appears to complete okay but there is still a lot of
excess
> > space in the database (more than half).
> >
> > SHRINKFILE gives the error "Could not locate file '<filename>' in
> sysfiles"
> > but the filename is the correct logical file name of my data file and I
> > checked in sysfiles that it exists and the data file location is
correct.
> >
> > Can anyone tell me what the problem might be? Is there another way to
> shrink
> > the database?
> >
> > Thanks
>sql

Can't shrink database or files

I can't shrink my data file using either DBCC SHRINKDATABASE or DBCC
SHRINKFILE.
SHRINKDATABASE appears to complete okay but there is still a lot of excess
space in the database (more than half).
SHRINKFILE gives the error "Could not locate file '<filename>' in sysfiles"
but the filename is the correct logical file name of my data file and I
checked in sysfiles that it exists and the data file location is correct.
Can anyone tell me what the problem might be? Is there another way to shrink
the database?
ThanksAre you in the right database when you issue the DBCC SHRINKFILE command?
DBCC SHRINKDATABASE takes the db name as a parameter, but SHRINKFILE does
not. It works on the current database.
If you are in the right database, can you show us the output of sp_helpfile,
and show us the exact command you are trying to run?
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"J Jetson" <JJetson@.discussions.microsoft.com> wrote in message
news:C065C200-4C54-4AF9-91AB-6EF1C320D66E@.microsoft.com...
>I can't shrink my data file using either DBCC SHRINKDATABASE or DBCC
> SHRINKFILE.
> SHRINKDATABASE appears to complete okay but there is still a lot of excess
> space in the database (more than half).
> SHRINKFILE gives the error "Could not locate file '<filename>' in
> sysfiles"
> but the filename is the correct logical file name of my data file and I
> checked in sysfiles that it exists and the data file location is correct.
> Can anyone tell me what the problem might be? Is there another way to
> shrink
> the database?
> Thanks|||Hi,
SHRINKDATABASE command will not shrink the file if there is any active open
transactions. Execute the command DBCC OPENTRAN(DBNAME)
to identify if there is any actiove open tran. Wait for those tranasctions
to close or kill the SPID which is open.
If you still face issues in shrinking then set the database to Single user
and shrink:-
Steps you can do to shrink the transaction log file:-
1. Backup the transaction log using the below command.
backup log <dbname> to disk='c:\backup\dbname.trn'
2. Bring the database to single user
Alter database <dbname> set single_user with rollback immediate
3. Shrink the database log file
dbcc shrinkdatabase(DBNAME) -- See books online for usage
4. Bring the database to multi user
alter database <dbname> set multi_user
----
WyHY SHRINK FILE is giving error:-
As Kalen pointed, you are not in the right database
Steps:-
use <dbname>
go
sp_helpfile
Based on the name column for the transaction log file execute the dbcc
shrinkfile
dbcc shrinkfile('name_given_by_sp_h_elpfile',
'truncateonly')
(Execute the DBCC SQLPERF(LOGSPACE) to identify that the log is shrink)
Thanks
Hari
SQL Server MVP
"J Jetson" <JJetson@.discussions.microsoft.com> wrote in message
news:C065C200-4C54-4AF9-91AB-6EF1C320D66E@.microsoft.com...
> I can't shrink my data file using either DBCC SHRINKDATABASE or DBCC
> SHRINKFILE.
> SHRINKDATABASE appears to complete okay but there is still a lot of excess
> space in the database (more than half).
> SHRINKFILE gives the error "Could not locate file '<filename>' in
sysfiles"
> but the filename is the correct logical file name of my data file and I
> checked in sysfiles that it exists and the data file location is correct.
> Can anyone tell me what the problem might be? Is there another way to
shrink
> the database?
> Thanks|||Nonsense. Shrink will happily wait for any locks it requires and then
continue - that's the whole point of it being online.
Do you have LOB columns in the database (select * from sysindexes where
indid=255)? If you've deleted a bunch of LOB data, this cannot be reclaimed
without bcp out/in or using select/into. This is fixed in SQL Server 2005.
Thanks
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OLwbMHhVFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Hi,
> SHRINKDATABASE command will not shrink the file if there is any active
open
> transactions. Execute the command DBCC OPENTRAN(DBNAME)
> to identify if there is any actiove open tran. Wait for those tranasctions
> to close or kill the SPID which is open.
> If you still face issues in shrinking then set the database to Single user
> and shrink:-
> Steps you can do to shrink the transaction log file:-
>
> 1. Backup the transaction log using the below command.
> backup log <dbname> to disk='c:\backup\dbname.trn'
> 2. Bring the database to single user
> Alter database <dbname> set single_user with rollback immediate
> 3. Shrink the database log file
> dbcc shrinkdatabase(DBNAME) -- See books online for usage
> 4. Bring the database to multi user
> alter database <dbname> set multi_user
> ----
> WyHY SHRINK FILE is giving error:-
> As Kalen pointed, you are not in the right database
> Steps:-
> use <dbname>
> go
> sp_helpfile
> Based on the name column for the transaction log file execute the dbcc
> shrinkfile
>
> dbcc shrinkfile('name_given_by_sp_h_elpfile',
'truncateonly')
>
> (Execute the DBCC SQLPERF(LOGSPACE) to identify that the log is shrink)
>
> Thanks
> Hari
> SQL Server MVP
>
>
> "J Jetson" <JJetson@.discussions.microsoft.com> wrote in message
> news:C065C200-4C54-4AF9-91AB-6EF1C320D66E@.microsoft.com...
excess[vbcol=seagreen]
> sysfiles"
correct.[vbcol=seagreen]
> shrink
>

can't set backup retention

We have a SQL 2000 MSDE when I use maintenance plan to set up
backups, Remove files older than window, when I click on the screw down lit
for the options (minutes, hours, days, weeks, months), there is nothing to
choose.
I remember there is an msde table or something needs to add. I forgot about
it...
Any advice from Microsoft...
I have searched on google, nothing showing up except talking about SQL
2005...This is only for SQL 2000 MSDE.Hi everybody,
Can I get answer for this today'
"renhai" wrote:

> We have a SQL 2000 MSDE when I use maintenance plan to set up
> backups, Remove files older than window, when I click on the screw down li
t
> for the options (minutes, hours, days, weeks, months), there is nothing t
o
> choose.
> I remember there is an msde table or something needs to add. I forgot abou
t
> it...
> Any advice from Microsoft...
> I have searched on google, nothing showing up except talking about SQL
> 2005...This is only for SQL 2000 MSDE.
>|||I think maybe your are thinking about the missing registry
key. That process executes:
xp_instance_regread N'HKEY_LOCAL_MACHINE',
N'SOFTWARE\Microsoft\MSSQLServer\MSSQLSe
rver',
N'BackupDirectory'
If there is no BackupDirectory string value in the key
HKLM\Software\Microsoft\MSSQLServer\MSSQ
LServer, you get an
error and nothing is displayed for the time increments.
-Sue
On Fri, 19 May 2006 14:58:01 -0700, renhai
<renhai@.discussions.microsoft.com> wrote:

>We have a SQL 2000 MSDE when I use maintenance plan to set up
>backups, Remove files older than window, when I click on the screw down lit
>for the options (minutes, hours, days, weeks, months), there is nothing to
>choose.
>I remember there is an msde table or something needs to add. I forgot about
>it...
>Any advice from Microsoft...
>I have searched on google, nothing showing up except talking about SQL
>2005...This is only for SQL 2000 MSDE.sql

can't set backup retention

We have a SQL 2000 MSDE when I use maintenance plan to set up
backups, Remove files older than window, when I click on the screw down lit
for the options (minutes, hours, days, weeks, months), there is nothing to
choose.
I remember there is an msde table or something needs to add. I forgot about
it...
Any advice from Microsoft...
I have searched on google, nothing showing up except talking about SQL
2005...This is only for SQL 2000 MSDE.Hi everybody,
Can I get answer for this today'
"renhai" wrote:
> We have a SQL 2000 MSDE when I use maintenance plan to set up
> backups, Remove files older than window, when I click on the screw down lit
> for the options (minutes, hours, days, weeks, months), there is nothing to
> choose.
> I remember there is an msde table or something needs to add. I forgot about
> it...
> Any advice from Microsoft...
> I have searched on google, nothing showing up except talking about SQL
> 2005...This is only for SQL 2000 MSDE.
>|||I think maybe your are thinking about the missing registry
key. That process executes:
xp_instance_regread N'HKEY_LOCAL_MACHINE',
N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer',
N'BackupDirectory'
If there is no BackupDirectory string value in the key
HKLM\Software\Microsoft\MSSQLServer\MSSQLServer, you get an
error and nothing is displayed for the time increments.
-Sue
On Fri, 19 May 2006 14:58:01 -0700, renhai
<renhai@.discussions.microsoft.com> wrote:
>We have a SQL 2000 MSDE when I use maintenance plan to set up
>backups, Remove files older than window, when I click on the screw down lit
>for the options (minutes, hours, days, weeks, months), there is nothing to
>choose.
>I remember there is an msde table or something needs to add. I forgot about
>it...
>Any advice from Microsoft...
>I have searched on google, nothing showing up except talking about SQL
>2005...This is only for SQL 2000 MSDE.

Can't see Designer view in Asp.net 2005

Hi All,

I am using VS2005 Trial version, In my website project i can't able to see Designer View of all .aspx files but i can able to view code part. Earlier days i can able to see Designer page but now i can't do why? This problem occurs even new website project also.

Can any one help me?

Thanks in advance

Regards

Nat Raja

This forum is dedicated to SQL/e, not to ASP.Net. Please post to relevant forum or news group instead:

http://forums.asp.net/

http://support.microsoft.com/newsgroups/default.aspx

Closing as off topic.

Can't remove empty file group - no files in sysfiles

Hi,
I've dropped all the files in my index filegroup (not default) but I
get this message when I try to remove the filegroup itself.
Server: Msg 5042, Level 16, State 8, Line 1
The filegroup 'xxxxx' cannot be removed because it is not empty.
Sysfiles isnt' listing the deleted files and sysfilegroups is showing
that there are 0 files in the filegroup. I've confirmed this by
looking at the properties of the database through EM. I've tried
cycling the services but I still can't drop the filegroup. Does anyone
know why I can't remove the filegroup? Any help would be greatly
appreciated.
I'm running SQL Server 2000 sp3
Thanks!
TelaanIs this the primary filegroup? If so, you can't remove it.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"telaan" <telaan@.hotmail.com> wrote in message
news:1127245241.370186.158990@.g47g2000cwa.googlegroups.com...
Hi,
I've dropped all the files in my index filegroup (not default) but I
get this message when I try to remove the filegroup itself.
Server: Msg 5042, Level 16, State 8, Line 1
The filegroup 'xxxxx' cannot be removed because it is not empty.
Sysfiles isnt' listing the deleted files and sysfilegroups is showing
that there are 0 files in the filegroup. I've confirmed this by
looking at the properties of the database through EM. I've tried
cycling the services but I still can't drop the filegroup. Does anyone
know why I can't remove the filegroup? Any help would be greatly
appreciated.
I'm running SQL Server 2000 sp3
Thanks!
Telaan|||Nope. Just an additional filegroup I used to put indexes in.|||When you emptied the files, did you use the EMPTYFILE option with DBCC
SHRINKFILE?
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"telaan" <telaan@.hotmail.com> wrote in message
news:1127245751.943569.313230@.g44g2000cwa.googlegroups.com...
Nope. Just an additional filegroup I used to put indexes in.|||does the file group is is a default file group?.|||If you are going to drop a filegroup, then you should make another group the
default.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Praveen" <apveen@.gmail.com> wrote in message
news:1127295464.994452.116930@.o13g2000cwo.googlegroups.com...
does the file group is is a default file group?.|||Thanks for the replies. The filegroup wasn't default but I've found
the problem by running the profiler to find out what system table still
had the filegroup referenced. It was the sysindexes table holding old
stats. You can find by running this query.
select name,id from dbo.sysindexes where groupid = 2 --id of filegroup
you want to drop.
I dropped the stats and was able to drop the filegroup.

Can't remove empty file group - no files in sysfiles

Hi,
I've dropped all the files in my index filegroup (not default) but I
get this message when I try to remove the filegroup itself.
Server: Msg 5042, Level 16, State 8, Line 1
The filegroup 'xxxxx' cannot be removed because it is not empty.
Sysfiles isnt' listing the deleted files and sysfilegroups is showing
that there are 0 files in the filegroup. I've confirmed this by
looking at the properties of the database through EM. I've tried
cycling the services but I still can't drop the filegroup. Does anyone
know why I can't remove the filegroup? Any help would be greatly
appreciated.
I'm running SQL Server 2000 sp3
Thanks!
TelaanIs this the primary filegroup? If so, you can't remove it.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"telaan" <telaan@.hotmail.com> wrote in message
news:1127245241.370186.158990@.g47g2000cwa.googlegroups.com...
Hi,
I've dropped all the files in my index filegroup (not default) but I
get this message when I try to remove the filegroup itself.
Server: Msg 5042, Level 16, State 8, Line 1
The filegroup 'xxxxx' cannot be removed because it is not empty.
Sysfiles isnt' listing the deleted files and sysfilegroups is showing
that there are 0 files in the filegroup. I've confirmed this by
looking at the properties of the database through EM. I've tried
cycling the services but I still can't drop the filegroup. Does anyone
know why I can't remove the filegroup? Any help would be greatly
appreciated.
I'm running SQL Server 2000 sp3
Thanks!
Telaan|||Nope. Just an additional filegroup I used to put indexes in.|||When you emptied the files, did you use the EMPTYFILE option with DBCC
SHRINKFILE?
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"telaan" <telaan@.hotmail.com> wrote in message
news:1127245751.943569.313230@.g44g2000cwa.googlegroups.com...
Nope. Just an additional filegroup I used to put indexes in.|||does the file group is is a default file group?.|||If you are going to drop a filegroup, then you should make another group the
default.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Praveen" <apveen@.gmail.com> wrote in message
news:1127295464.994452.116930@.o13g2000cwo.googlegroups.com...
does the file group is is a default file group?.|||Thanks for the replies. The filegroup wasn't default but I've found
the problem by running the profiler to find out what system table still
had the filegroup referenced. It was the sysindexes table holding old
stats. You can find by running this query.
select name,id from dbo.sysindexes where groupid = 2 --id of filegroup
you want to drop.
I dropped the stats and was able to drop the filegroup.

Can't play files: Video Series: SQL Server 2005 Express Edition for Beginners

I cannot play any of these video files in RealPlayer or in Windows Media Player. Any suggestions? Anyone else having this problem?

Thanks,

Brian

Video Series: SQL Server 2005 Express Edition for Beginners

C00D1199: Cannot play the file

Could you give me a pointer to where you got this file?

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.

|||

Sorry, this was my own fault. I solved the issue by removing a freeware download manager and re-downloading the videos. All the videos play fine now.

Here is the page with the videos reached by SQL Server Express-->Learning Resources:
http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx

And here is the pointer to the first video:

http://wm.microsoft.com/ms/msdn/vstudio/express/sql/beginner_videos/sql_01_fix2.wmv

Thanks for your help!

|||

Glad to hear you got things up and running.

- Mike

|||

For the last few weeks all the avi, mpg music files I have pop up this following error messages in WMPlayer.

Windows Media Player cannot play the file. The Player might not support the file type or might not support the codec that was used to compress the file.
When trying to get more information I get this:
C00D1199: Cannot play the file

This information is very unhelpful, borders on useless, especially since ALL of these files were playing just fine BEFORE MS decided to "fix" Media player! I've tried playing it on WMPlayer, Apple iTunes and even divx, nothing!!!

Is there anyway to fix it back so the WMplayer will know exactly what to do instead of sending us off on wild goosechases to find some codes that were created that messed up something that was working perfectly fine, until the last update?!

I am not a programmer just a user and these type of error messages are so infuriating when they don't tell you precisely what to do to FIX the problem. Already uninstalled WMPlayer, nothing. Don't know what the heck to do!! HELP PLEASE! Thanks!

|||i can not play og se all files

Can't play files: Video Series: SQL Server 2005 Express Edition for Beginners

I cannot play any of these video files in RealPlayer or in Windows Media Player. Any suggestions? Anyone else having this problem?

Thanks,

Brian

Video Series: SQL Server 2005 Express Edition for Beginners

C00D1199: Cannot play the file

Could you give me a pointer to where you got this file?

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.

|||

Sorry, this was my own fault. I solved the issue by removing a freeware download manager and re-downloading the videos. All the videos play fine now.

Here is the page with the videos reached by SQL Server Express-->Learning Resources:
http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx

And here is the pointer to the first video:

http://wm.microsoft.com/ms/msdn/vstudio/express/sql/beginner_videos/sql_01_fix2.wmv

Thanks for your help!

|||

Glad to hear you got things up and running.

- Mike

|||

For the last few weeks all the avi, mpg music files I have pop up this following error messages in WMPlayer.

Windows Media Player cannot play the file. The Player might not support the file type or might not support the codec that was used to compress the file.
When trying to get more information I get this:
C00D1199: Cannot play the file

This information is very unhelpful, borders on useless, especially since ALL of these files were playing just fine BEFORE MS decided to "fix" Media player! I've tried playing it on WMPlayer, Apple iTunes and even divx, nothing!!!

Is there anyway to fix it back so the WMplayer will know exactly what to do instead of sending us off on wild goosechases to find some codes that were created that messed up something that was working perfectly fine, until the last update?!

I am not a programmer just a user and these type of error messages are so infuriating when they don't tell you precisely what to do to FIX the problem. Already uninstalled WMPlayer, nothing. Don't know what the heck to do!! HELP PLEASE! Thanks!

|||i can not play og se all files

Can't play files: Video Series: SQL Server 2005 Express Edition for Beginners

I cannot play any of these video files in RealPlayer or in Windows Media Player. Any suggestions? Anyone else having this problem?

Thanks,

Brian

Video Series: SQL Server 2005 Express Edition for Beginners

C00D1199: Cannot play the file

Could you give me a pointer to where you got this file?

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.

|||

Sorry, this was my own fault. I solved the issue by removing a freeware download manager and re-downloading the videos. All the videos play fine now.

Here is the page with the videos reached by SQL Server Express-->Learning Resources:
http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx

And here is the pointer to the first video:

http://wm.microsoft.com/ms/msdn/vstudio/express/sql/beginner_videos/sql_01_fix2.wmv

Thanks for your help!

|||

Glad to hear you got things up and running.

- Mike

|||

For the last few weeks all the avi, mpg music files I have pop up this following error messages in WMPlayer.

Windows Media Player cannot play the file. The Player might not support the file type or might not support the codec that was used to compress the file.
When trying to get more information I get this:
C00D1199: Cannot play the file

This information is very unhelpful, borders on useless, especially since ALL of these files were playing just fine BEFORE MS decided to "fix" Media player! I've tried playing it on WMPlayer, Apple iTunes and even divx, nothing!!!

Is there anyway to fix it back so the WMplayer will know exactly what to do instead of sending us off on wild goosechases to find some codes that were created that messed up something that was working perfectly fine, until the last update?!

I am not a programmer just a user and these type of error messages are so infuriating when they don't tell you precisely what to do to FIX the problem. Already uninstalled WMPlayer, nothing. Don't know what the heck to do!! HELP PLEASE! Thanks!

|||i can not play og se all files

can't open adventure works example

after running msi, can't open this solution

C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Analysis Services Project\Standard, select the file Adventure Works DW.sln

error msg
Microsoft Visual Studio

The application for project 'C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Analysis Services Project\standard\Adventure Works DW Standard Edition.dwproj' is not installed.

Make sure the application for the project type (.dwproj) is installed.

error msg

Did you install it some other folder than the one stated below ? Or did you not install the samples libarary ? Then you won′t find the information in this folder. You can install the samples from disks afterwards, juzst launch the explorer and use the custom installation type.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||It's installed exactly where shown, but there are no instructions on how to install .dwproj|||ARe you installing SQL Server Express ? SQL Server Analysis Services isn′t shipped with Express so you should get the project files from another edition than express.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||yes I'm using sql express the advanced edition which is supposed to support the adventureworks sample|||Express does not support Analysis Services, you are trying to open the analysis services sample for adventure works, try one of the others.

Cant' log in anymore

Hi,
I pulled down all the files from my live
database which is running remotely.
When I did this, I overwrote my Web Page
connection string, which I used to log into a
local production instance of this database.
After a few weeks I got around to recreating
my connection string, but it won't work.
Neither does my partner's login info work and
we are both admins. I am the dbo. Now I am
wondering if coincidentally somehow my machine
was compromised. Is there someway I could be
kept out? I can still log onto the machine/server
which runs SQL Server for access to the drives.
I am running Windows/2000
and SQL 2000. My authentication
is set to Windows only. I run my network
as a workgroup and there is no "Active Directory".
Logging into the server to access the drives is
no problem. The login is of course the same, since
I am using Windows only authentication.
Is there anyplace I can look to see if there
is some way to get this working again?
It is not making sense to me that I can
log in to the HDs on the LAN but cannot
log into SQL databases via a webpage.
The folders are in folder needed a Windows
login, but the SQL server logs just keep showing
that access is denied because the login is not
a trusted login, which is not true, but I cannot
prove that to the server.
Could I have been compromised or does
this sound like some other confusion?
Thanks for anyone's feedback,
FoxIf the authentication is set to Windows Authentication and you're not in a
domain, then you're basically using Workgroup security to connect. The
same username and password must exists on both machines.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

cant load DB files from SQL2005 Beta2

I was using SQL 2005 Beta2 in my lab boxes, which I have now upgraded
to the RTM release of SQL Server 2005, however it wont let me load the
DB files from databases I created on the Beta version...I am in bad
shape because I no longer have any Beta2 installations or
media....how can I load the DB files into the RTM version' help!!TechMasters wrote:
> I was using SQL 2005 Beta2 in my lab boxes, which I have now upgraded
> to the RTM release of SQL Server 2005, however it wont let me load the
> DB files from databases I created on the Beta version...I am in bad
> shape because I no longer have any Beta2 installations or
> media....how can I load the DB files into the RTM version' help!!
What do you mean by "can't load"? What are you trying to do and which
error messages do you get?
Regards
Steen|||On Thu, 18 May 2006 10:19:56 +0200, "Steen Persson (DK)"
<spe@.REMOVEdatea.dk> wrote:
>TechMasters wrote:
>> I was using SQL 2005 Beta2 in my lab boxes, which I have now upgraded
>> to the RTM release of SQL Server 2005, however it wont let me load the
>> DB files from databases I created on the Beta version...I am in bad
>> shape because I no longer have any Beta2 installations or
>> media....how can I load the DB files into the RTM version' help!!
>What do you mean by "can't load"? What are you trying to do and which
>error messages do you get?
>Regards
>Steen
I meant when I go to attach the database files (mdf file) whcih where
created in the beta version I get the following
--
Database 'Report' cannot be upgraded because its non-release version
(587) is not supported by this version of SQL Server. You cannot open
a database that is incompatible with this version of sqlservr.exe. You
must re-create the database.
Could not open new database 'Report'. CREATE DATABASE is aborted.
(Microsoft SQL Server, Error: 950)|||On Thu, 18 May 2006 10:19:56 +0200, "Steen Persson (DK)"
<spe@.REMOVEdatea.dk> wrote:
>TechMasters wrote:
>> I was using SQL 2005 Beta2 in my lab boxes, which I have now upgraded
>> to the RTM release of SQL Server 2005, however it wont let me load the
>> DB files from databases I created on the Beta version...I am in bad
>> shape because I no longer have any Beta2 installations or
>> media....how can I load the DB files into the RTM version' help!!
>What do you mean by "can't load"? What are you trying to do and which
>error messages do you get?
>Regards
>Steen
What I mean is I get the error below when I try to attach the database
files (.mdf) which were created in the Beta version
--
Database 'Report' cannot be upgraded because its non-release version
(587) is not supported by this version of SQL Server. You cannot open
a database that is incompatible with this version of sqlservr.exe. You
must re-create the database.
Could not open new database 'Report'. CREATE DATABASE is aborted.
(Microsoft SQL Server, Error: 950)|||I have the same problem. Is there a way to get the beta2 mdf's loaded
into the RTM version?
Gans
TechMasters wrote:
> On Thu, 18 May 2006 10:19:56 +0200, "Steen Persson (DK)"
> <spe@.REMOVEdatea.dk> wrote:
> >TechMasters wrote:
> >> I was using SQL 2005 Beta2 in my lab boxes, which I have now upgraded
> >> to the RTM release of SQL Server 2005, however it wont let me load the
> >> DB files from databases I created on the Beta version...I am in bad
> >> shape because I no longer have any Beta2 installations or
> >> media....how can I load the DB files into the RTM version' help!!
> >
> >What do you mean by "can't load"? What are you trying to do and which
> >error messages do you get?
> >
> >Regards
> >Steen
> What I mean is I get the error below when I try to attach the database
> files (.mdf) which were created in the Beta version
> --
> Database 'Report' cannot be upgraded because its non-release version
> (587) is not supported by this version of SQL Server. You cannot open
> a database that is incompatible with this version of sqlservr.exe. You
> must re-create the database.
> Could not open new database 'Report'. CREATE DATABASE is aborted.
> (Microsoft SQL Server, Error: 950)

cant load DB files from SQL2005 Beta2

I was using SQL 2005 Beta2 in my lab boxes, which I have now upgraded
to the RTM release of SQL Server 2005, however it wont let me load the
DB files from databases I created on the Beta version...I am in bad
shape because I no longer have any Beta2 installations or
media....how can I load the DB files into the RTM version' help!!TechMasters wrote:
> I was using SQL 2005 Beta2 in my lab boxes, which I have now upgraded
> to the RTM release of SQL Server 2005, however it wont let me load the
> DB files from databases I created on the Beta version...I am in bad
> shape because I no longer have any Beta2 installations or
> media....how can I load the DB files into the RTM version' help!!
What do you mean by "can't load"? What are you trying to do and which
error messages do you get?
Regards
Steen|||On Thu, 18 May 2006 10:19:56 +0200, "Steen Persson (DK)"
<spe@.REMOVEdatea.dk> wrote:

>TechMasters wrote:
>What do you mean by "can't load"? What are you trying to do and which
>error messages do you get?
>Regards
>Steen
I meant when I go to attach the database files (mdf file) whcih where
created in the beta version I get the following
Database 'Report' cannot be upgraded because its non-release version
(587) is not supported by this version of SQL Server. You cannot open
a database that is incompatible with this version of sqlservr.exe. You
must re-create the database.
Could not open new database 'Report'. CREATE DATABASE is aborted.
(Microsoft SQL Server, Error: 950)|||On Thu, 18 May 2006 10:19:56 +0200, "Steen Persson (DK)"
<spe@.REMOVEdatea.dk> wrote:

>TechMasters wrote:
>What do you mean by "can't load"? What are you trying to do and which
>error messages do you get?
>Regards
>Steen
What I mean is I get the error below when I try to attach the database
files (.mdf) which were created in the Beta version
Database 'Report' cannot be upgraded because its non-release version
(587) is not supported by this version of SQL Server. You cannot open
a database that is incompatible with this version of sqlservr.exe. You
must re-create the database.
Could not open new database 'Report'. CREATE DATABASE is aborted.
(Microsoft SQL Server, Error: 950)|||I have the same problem. Is there a way to get the beta2 mdf's loaded
into the RTM version?
Gans
TechMasters wrote:
> On Thu, 18 May 2006 10:19:56 +0200, "Steen Persson (DK)"
> <spe@.REMOVEdatea.dk> wrote:
>
> What I mean is I get the error below when I try to attach the database
> files (.mdf) which were created in the Beta version
> --
> Database 'Report' cannot be upgraded because its non-release version
> (587) is not supported by this version of SQL Server. You cannot open
> a database that is incompatible with this version of sqlservr.exe. You
> must re-create the database.
> Could not open new database 'Report'. CREATE DATABASE is aborted.
> (Microsoft SQL Server, Error: 950)|||I have the same problem. Is there a way to get the beta2 mdf's loaded
into the RTM version?
Gans
TechMasters wrote:
> On Thu, 18 May 2006 10:19:56 +0200, "Steen Persson (DK)"
> <spe@.REMOVEdatea.dk> wrote:
>
> What I mean is I get the error below when I try to attach the database
> files (.mdf) which were created in the Beta version
> --
> Database 'Report' cannot be upgraded because its non-release version
> (587) is not supported by this version of SQL Server. You cannot open
> a database that is incompatible with this version of sqlservr.exe. You
> must re-create the database.
> Could not open new database 'Report'. CREATE DATABASE is aborted.
> (Microsoft SQL Server, Error: 950)

Can't Install SQL 2000 service pack 4

We are having trouble installing SQL2000 service pack 4 on our server. The package runs through and looks like it installs files to c:\, but the install never asks us for any of the questions regarding the install of service pack 4. One issue we were thinking about was that MSDE was installed on the server also. We have a 2003 server with SQL 2000 sp3 (8.00.760)

Are you running this through a command line or through the UI? If it is command line, can you supply the command line you are running?

Thanks,
Sam Lester (MSFT)

Cant get SQL Server 2005 to work

Hello ia m trying to install SQL Server 2005 but i am unable to run it. I installed Net Framework 2.0
Then i have tried the following files:
SQLEXPR.EXE
SQLEXPR_ADV.EXE
Then i installed Service PAck 1 for that but an error occoured during the install.

Basiclly i have no idea what i am doing here. It creates a configuration tools start menu item but it seems just like configuration. In C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn there is a file called sqlservr.exe but all it does is create a black console window and does nothing.

OS: XP Pro + SP2

How to get it to work?

Thank You

SQLEXPR.EXE is the installer for the edition SQL Express. SQLEXPR_ADV.exe is the installer for SQL Express Advanced. So if you ran both installers, you will now have two different editions on your machine. SQL Express Advanced comes with the option of installing Management Studio Express, a set of client tools available to view/edit/manage your database on your machine (or on remote machines). I'd suggest going through the Getting Started section of Books Online (the SQL documentation) for some suggested exercises.

Thanks,
Sam Lester (MSFT)

|||Thank You for Your reply.
I did not install them at the same time, i tried them both. I could not find the exe file to run the program. Is there such a thing. Ill read the getting started section also.|||

Which one did you fully install? If you installed Express, then it has no client tools (I think that's what you are searching for). If you installed Express Advanced, you have the option of installing Management Studio Express. Once this is installed, it will launch the UI-based tool that will allow you to browse through your instance.

Thanks,
Sam