Sunday, March 25, 2012
can't attach 2 sample files can attach other files
appears to be configured correctly. I am trying to attach the
Northwind and Pubs example files from SQL Server 2000. I have tried
more than several times to attach them. I have them in the data file
of SQL Server 2007 express. The files are not read only. I looked
in the permissions and they were but I changed it to writeable and
checked the other files the log file and such.
When I try to attach the files I get the error message "Database
Northwind cannot be upgraded because it is read only or has read only
files. Make the files writeable and re-run recovery".
What is recovery? Do the files have to be upgraded from SQL SErver
2000?
thanks,Hi Janis,
Is that SQL Server 2005? (There is no SQL Server 2007). Have you changed the
permissions of both data and log files?
You could also try this
Northwind and pubs Sample Databases for SQL Server 2000
http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en
Hope this helps,
Ben Nevarez
"Janis Rough" wrote:
> I got SQL Server 2007 Express configured and I ran a few queries. It
> appears to be configured correctly. I am trying to attach the
> Northwind and Pubs example files from SQL Server 2000. I have tried
> more than several times to attach them. I have them in the data file
> of SQL Server 2007 express. The files are not read only. I looked
> in the permissions and they were but I changed it to writeable and
> checked the other files the log file and such.
> When I try to attach the files I get the error message "Database
> Northwind cannot be upgraded because it is read only or has read only
> files. Make the files writeable and re-run recovery".
> What is recovery? Do the files have to be upgraded from SQL SErver
> 2000?
> thanks,
>|||On Jan 30, 7:10 pm, Ben Nevarez
<bneva...@.no.spam.please.sunamerica.com> wrote:
> Hi Janis,
> Is that SQL Server 2005? (There is no SQL Server 2007). Have you changed the
> permissions of both data and log files?
> You could also try this
> Northwind and pubs Sample Databases for SQL Server 2000http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-035...
> Hope this helps,
> Ben Nevarez
> "Janis Rough" wrote:
> > I got SQL Server 2007 Express configured and I ran a few queries. It
> > appears to be configured correctly. I am trying to attach the
> > Northwind and Pubs example files from SQL Server 2000. I have tried
> > more than several times to attach them. I have them in the data file
> > of SQL Server 2007 express. The files are not read only. I looked
> > in the permissions and they were but I changed it to writeable and
> > checked the other files the log file and such.
> > When I try to attach the files I get the error message "Database
> > Northwind cannot be upgraded because it is read only or has read only
> > files. Make the files writeable and re-run recovery".
> > What is recovery? Do the files have to be upgraded from SQL SErver
> > 2000?
> > thanks,
sorry, it didn't help, I got the Northwind 2000 sample file. I didn't
know the latest version was 2005, so that was helpful, however, I did
change the permissions for all the files, the log file and the mdf
files. They still won't attach.|||On Jan 31, 8:16=A0am, Janis Rough <jlro...@.yahoo.com> wrote:
> On Jan 30, 7:10 pm, Ben Nevarez
>
>
> <bneva...@.no.spam.please.sunamerica.com> wrote:
> > Hi Janis,
> > Is that SQL Server 2005? (There is no SQL Server 2007). Have you changed= the
> > permissions of both data and log files?
> > You could also try this
> > Northwind and pubs Sample Databases for SQL Server 2000http://www.micros=
oft.com/downloads/details.aspx?FamilyID=3D06616212-035...
> > Hope this helps,
> > Ben Nevarez
> > "Janis Rough" wrote:
> > > I got SQL Server 2007 Express configured and I ran a few queries. It
> > > appears to be configured correctly. =A0 I am trying to attach the
> > > Northwind and Pubs example files from SQL Server 2000. =A0 I have trie=d
> > > more than several times to attach them. =A0I have them in the data fil=e
> > > of SQL Server 2007 express. =A0 The files are not read only. =A0I look=ed
> > > in the permissions and they were but I changed it to writeable and
> > > checked the other files the log file and such.
> > > When I try to attach the files I get the error message "Database
> > > Northwind cannot be upgraded because it is read only or has read only
> > > files. Make the files writeable and re-run recovery".
> > > What is recovery? =A0Do the files have to be upgraded from SQL SErver
> > > 2000?
> > > thanks,
> sorry, it didn't help, I got the Northwind 2000 sample file. =A0I didn't
> know the latest version was 2005, so that was helpful, however, I did
> change the permissions for all the files, the log file and the mdf
> files. =A0They still won't attach.- Hide quoted text -
> - Show quoted text -
Hi Janis,
There is no need to attach the northwind or pubs dbs . There are
scripts like instnwnd.sql which will configure the northwind db for
you . Just execute the script.
and don't try to attach the db from higher version to lower
version...!
Thanks
Ajay|||On Jan 30, 11:10 pm, Ajay Rengunthwar <aju...@.gmail.com> wrote:
> On Jan 31, 8:16 am, Janis Rough <jlro...@.yahoo.com> wrote:
>
> > On Jan 30, 7:10 pm, Ben Nevarez
> > <bneva...@.no.spam.please.sunamerica.com> wrote:
> > > Hi Janis,
> > > Is that SQL Server 2005? (There is no SQL Server 2007). Have you changed the
> > > permissions of both data and log files?
> > > You could also try this
> > > Northwind and pubs Sample Databases for SQL Server 2000http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-035...
> > > Hope this helps,
> > > Ben Nevarez
> > > "Janis Rough" wrote:
> > > > I got SQL Server 2007 Express configured and I ran a few queries. It
> > > > appears to be configured correctly. I am trying to attach the
> > > > Northwind and Pubs example files from SQL Server 2000. I have tried
> > > > more than several times to attach them. I have them in the data file
> > > > of SQL Server 2007 express. The files are not read only. I looked
> > > > in the permissions and they were but I changed it to writeable and
> > > > checked the other files the log file and such.
> > > > When I try to attach the files I get the error message "Database
> > > > Northwind cannot be upgraded because it is read only or has read only
> > > > files. Make the files writeable and re-run recovery".
> > > > What is recovery? Do the files have to be upgraded from SQL SErver
> > > > 2000?
> > > > thanks,
> > sorry, it didn't help, I got the Northwind 2000 sample file. I didn't
> > know the latest version was 2005, so that was helpful, however, I did
> > change the permissions for all the files, the log file and the mdf
> > files. They still won't attach.- Hide quoted text -
> > - Show quoted text -
> Hi Janis,
> There is no need to attach the northwind or pubs dbs . There are
> scripts like instnwnd.sql which will configure the northwind db for
> you . Just execute the script.
> and don't try to attach the db from higher version to lower
> version...!
> Thanks
> Ajay
Thanks,|||On Jan 30, 11:10 pm, Ajay Rengunthwar <aju...@.gmail.com> wrote:
> On Jan 31, 8:16 am, Janis Rough <jlro...@.yahoo.com> wrote:
>
> > On Jan 30, 7:10 pm, Ben Nevarez
> > <bneva...@.no.spam.please.sunamerica.com> wrote:
> > > Hi Janis,
> > > Is that SQL Server 2005? (There is no SQL Server 2007). Have you changed the
> > > permissions of both data and log files?
> > > You could also try this
> > > Northwind and pubs Sample Databases for SQL Server 2000http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-035...
> > > Hope this helps,
> > > Ben Nevarez
> > > "Janis Rough" wrote:
> > > > I got SQL Server 2007 Express configured and I ran a few queries. It
> > > > appears to be configured correctly. I am trying to attach the
> > > > Northwind and Pubs example files from SQL Server 2000. I have tried
> > > > more than several times to attach them. I have them in the data file
> > > > of SQL Server 2007 express. The files are not read only. I looked
> > > > in the permissions and they were but I changed it to writeable and
> > > > checked the other files the log file and such.
> > > > When I try to attach the files I get the error message "Database
> > > > Northwind cannot be upgraded because it is read only or has read only
> > > > files. Make the files writeable and re-run recovery".
> > > > What is recovery? Do the files have to be upgraded from SQL SErver
> > > > 2000?
> > > > thanks,
> > sorry, it didn't help, I got the Northwind 2000 sample file. I didn't
> > know the latest version was 2005, so that was helpful, however, I did
> > change the permissions for all the files, the log file and the mdf
> > files. They still won't attach.- Hide quoted text -
> > - Show quoted text -
> Hi Janis,
> There is no need to attach the northwind or pubs dbs . There are
> scripts like instnwnd.sql which will configure the northwind db for
> you . Just execute the script.
> and don't try to attach the db from higher version to lower
> version...!
> Thanks
> Ajay
It worked I created Northwind and Pubs successfully. I have one
question if you happen to see this. Why don't the two databases now
show up in the Object Explorer?|||> It worked I created Northwind and Pubs successfully. I have one
> question if you happen to see this. Why don't the two databases now
> show up in the Object Explorer?
Did you refresh? Or even disconnect and re-connect?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Janis Rough" <jlrough@.yahoo.com> wrote in message
news:f4fc0c53-e93a-47ff-8a94-561e04fb773a@.h11g2000prf.googlegroups.com...
> On Jan 30, 11:10 pm, Ajay Rengunthwar <aju...@.gmail.com> wrote:
>> On Jan 31, 8:16 am, Janis Rough <jlro...@.yahoo.com> wrote:
>>
>> > On Jan 30, 7:10 pm, Ben Nevarez
>> > <bneva...@.no.spam.please.sunamerica.com> wrote:
>> > > Hi Janis,
>> > > Is that SQL Server 2005? (There is no SQL Server 2007). Have you changed the
>> > > permissions of both data and log files?
>> > > You could also try this
>> > > Northwind and pubs Sample Databases for SQL Server
>> > > 2000http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-035...
>> > > Hope this helps,
>> > > Ben Nevarez
>> > > "Janis Rough" wrote:
>> > > > I got SQL Server 2007 Express configured and I ran a few queries. It
>> > > > appears to be configured correctly. I am trying to attach the
>> > > > Northwind and Pubs example files from SQL Server 2000. I have tried
>> > > > more than several times to attach them. I have them in the data file
>> > > > of SQL Server 2007 express. The files are not read only. I looked
>> > > > in the permissions and they were but I changed it to writeable and
>> > > > checked the other files the log file and such.
>> > > > When I try to attach the files I get the error message "Database
>> > > > Northwind cannot be upgraded because it is read only or has read only
>> > > > files. Make the files writeable and re-run recovery".
>> > > > What is recovery? Do the files have to be upgraded from SQL SErver
>> > > > 2000?
>> > > > thanks,
>> > sorry, it didn't help, I got the Northwind 2000 sample file. I didn't
>> > know the latest version was 2005, so that was helpful, however, I did
>> > change the permissions for all the files, the log file and the mdf
>> > files. They still won't attach.- Hide quoted text -
>> > - Show quoted text -
>> Hi Janis,
>> There is no need to attach the northwind or pubs dbs . There are
>> scripts like instnwnd.sql which will configure the northwind db for
>> you . Just execute the script.
>> and don't try to attach the db from higher version to lower
>> version...!
>> Thanks
>> Ajay
> It worked I created Northwind and Pubs successfully. I have one
> question if you happen to see this. Why don't the two databases now
> show up in the Object Explorer?sql
Sunday, March 11, 2012
Cannot view log data
the log and ran it for a few minutes and then decided to view the log file
that I created ( .blg) . I could not see anything. Did i do it right ? I
created the log and was viewing it from the same perfmon toolHassan
Did you add the same counters to perfom monitor.
BTW , what is version of the server? (NT or Windows 2000 Server ,etc)
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:O3nV6n0eDHA.2364@.TK2MSFTNGP09.phx.gbl...
> I created a perfmon counter log with some SQL server counters and started
> the log and ran it for a few minutes and then decided to view the log file
> that I created ( .blg) . I could not see anything. Did i do it right ? I
> created the log and was viewing it from the same perfmon tool
>
>
Friday, February 24, 2012
Cannot shrink tempdb
HI There
I have a strange problem.
This is on Sql Server 2005 Standard Edition X64.
Tempdb ran out of space, ok cool no problem i know why we fixed it.
However temodb grew to the size of the disk when this happened. So now i just need to shrink the tempdb file on disk.
But no matter what i try it wont shrink.
The temodb data file is 29Gigs on disk. When i right click on th DB and you to tasks and go to shrink file, the GUI says that the file is 15 Gigs with 15 Gig free space available, i select the option to shrink to 15Gig. I click ok. Afterwards the file is still 29Gig on disk.
SO i ran sp_spaceused , it reports that tempdb has 29Gig free space, so i ran DBCC SHRINKFILE for the tempdb data file to 15 Gig, the command completely successfully , however afterwards the file is still 29Gig on disk.
My first problem is that management studio, thinks the file 15 gig not 29 gig, and i cannot shrink the file with management studio or tsql, even though they report that there is plenty of free space.
PLEASE HELP?
Thanx
You can start here.http://support.microsoft.com/kb/307487|||...and don't forget to read up on this excellent whitepaper on tempdb.
http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx
Tuesday, February 14, 2012
Cannot see network drive when doing restore from disk
Hello, I recently had the PC replaced where I ran SQL Server 2005.
On the old PC I was able to backup and restore DB on a network drive L: w/o any trouble. On the new PC I reinstalled SQL Server making sure that all the settings are exactly as before. However, when I tried to restore the database, I go to "From device" -> Add file, but I do not see L: drive on the list anymore.
However, I seem to have an access to the network in general, as I can open and run sql queries that are stored on the same network drive.
I am spending the whole day comparing 2 machine setting by setting, and cannot find anything different except that the old system was running Win2000, and new one is WinXP, but I doubt that it has anything to do with it.
I also did not see any similar problem reported elsewhere.
Does anyone have any idea what to look for?
Make sure you have the drive mapped correctly on your system.
you may need to copy and paste the UNC location.
I'm not sure how it works on a local machine, but you may want to make sure the login running the SQL service has access to that network drive as well.
It would probably work better for you to just copy a backup file down from that drive to a local drive and restore from there.
Friday, February 10, 2012
Cannot restore a copy of SQL2000 to SQL2005
database into the new SQL2005 server. I copied the backup file
"databasename.bak" to the backup folder of the new SQL2005 server but cannot
see it using browse in restore function.
help!!!
BillI would say that was not exactly the same directory or there is a
permissions issue. Verify the complete path or try some other location.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Bill Nguyen" wrote:
> I ran into a weird problem trying to restore a backup copy of SQL2000
> database into the new SQL2005 server. I copied the backup file
> "databasename.bak" to the backup folder of the new SQL2005 server but cann
ot
> see it using browse in restore function.
> help!!!
> Bill
>
>|||Ben;
You're correct. I looked into the wrong folder.
After that, I ran into a different problem though:
I upgraded the SQLserver 2005 to SP1 ans tried to restore a copy of SQL2000
from another server to it. SQL 05 refused to restore saying that the backup
is for another SQLserver instance! I don't remember running into this
problem last time I did the same task.
Any idea why?
Thanks again.
Bill
Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:B1063714-ACF3-461D-885C-FCE372E210D4@.microsoft.com...[vbcol=seagreen]
> I would say that was not exactly the same directory or there is a
> permissions issue. Verify the complete path or try some other location.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Bill Nguyen" wrote:
>
Cannot restore a copy of SQL2000 to SQL2005
database into the new SQL2005 server. I copied the backup file
"databasename.bak" to the backup folder of the new SQL2005 server but cannot
see it using browse in restore function.
help!!!
BillI would say that was not exactly the same directory or there is a
permissions issue. Verify the complete path or try some other location.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Bill Nguyen" wrote:
> I ran into a weird problem trying to restore a backup copy of SQL2000
> database into the new SQL2005 server. I copied the backup file
> "databasename.bak" to the backup folder of the new SQL2005 server but cannot
> see it using browse in restore function.
> help!!!
> Bill
>
>|||Ben;
You're correct. I looked into the wrong folder.
After that, I ran into a different problem though:
I upgraded the SQLserver 2005 to SP1 ans tried to restore a copy of SQL2000
from another server to it. SQL 05 refused to restore saying that the backup
is for another SQLserver instance! I don't remember running into this
problem last time I did the same task.
Any idea why?
Thanks again.
Bill
Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:B1063714-ACF3-461D-885C-FCE372E210D4@.microsoft.com...
> I would say that was not exactly the same directory or there is a
> permissions issue. Verify the complete path or try some other location.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Bill Nguyen" wrote:
>> I ran into a weird problem trying to restore a backup copy of SQL2000
>> database into the new SQL2005 server. I copied the backup file
>> "databasename.bak" to the backup folder of the new SQL2005 server but
>> cannot
>> see it using browse in restore function.
>> help!!!
>> Bill
>>
Cannot Restart SQL Server Agent
d that the SQL Server Agent was stopped. I tried to restart it several time
s to no avail. I even stopped the SQL Server and restarted it, but the Agen
t will not start. The erro
r log has the following message in it: [241] Startup error: Unable to i
nitialize error reporting system (reason: Access is denied). The setup of t
he database has not changed (Windows 2000 Server/SQL Server 2000). The agen
t and MSSQLServer both login us
ing the same domain account which is in the administrator's group on the box
. The account role is System Administrator in SQL Server.Hi,
Try to change the start up account for SQL Agent to
"Local system account" and try starting the service.
Thanks
Hari
MCDBA
"James_Privett" <anonymous@.discussions.microsoft.com> wrote in message
news:F6066C48-9689-44DA-BA5B-6585E20B7C99@.microsoft.com...
> This morning when I checked to see if my weekend database jobs ran, I
noticed that the SQL Server Agent was stopped. I tried to restart it
several times to no avail. I even stopped the SQL Server and restarted it,
but the Agent will not start. The error log has the following message in
it: [241] Startup error: Unable to initialize error reporting system
(reason: Access is denied). The setup of the database has not changed
(Windows 2000 Server/SQL Server 2000). The agent and MSSQLServer both login
using the same domain account which is in the administrator's group on the
box. The account role is System Administrator in SQL Server.|||Thanks Hari! That worked...but I have no clue why it stopped working after
3 months with no problems...?