Database Overwritten: databse

Showing posts with label databse. Show all posts

Thursday, March 29, 2012

Database Name

Can you have Databse names that contain spaces such as Intanet Content
Databse? Will this cause any issues in SQL 2000?You can, but you need to delimit the names with brackets:
[Intanet Content Databse]
In my opinion it's not a good practice. Do the spaces really add anything
extra to the name? Furthermore, why do you need to add the "Database" (or
"Databse" in your case) identifier? Do your client tools merge databases
and other types of objects in the same views, such that you need the
additional text to differentiate between them in a list?
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"George Schneider" <georgedschneider@.news.postalias> wrote in message
news:294E9BC0-5A7A-490E-B678-63242CCA6B3D@.microsoft.com...
> Can you have Databse names that contain spaces such as Intanet Content
> Databse? Will this cause any issues in SQL 2000?|||Its froma Admin. stanpoint. These databses are created my Sharepoitn
Services. I'm assuming the brackets are required when I reference them. I
don't actual name them [Intanet Databse] do I?
"Adam Machanic" wrote:
> You can, but you need to delimit the names with brackets:
> [Intanet Content Databse]
> In my opinion it's not a good practice. Do the spaces really add anything
> extra to the name? Furthermore, why do you need to add the "Database" (or
> "Databse" in your case) identifier? Do your client tools merge databases
> and other types of objects in the same views, such that you need the
> additional text to differentiate between them in a list?
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "George Schneider" <georgedschneider@.news.postalias> wrote in message
> news:294E9BC0-5A7A-490E-B678-63242CCA6B3D@.microsoft.com...
> > Can you have Databse names that contain spaces such as Intanet Content
> > Databse? Will this cause any issues in SQL 2000?
>
>|||Brackets are required both when creating them and when referencing them. I
assume Sharepoint does that automatically for you...
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"George Schneider" <georgedschneider@.news.postalias> wrote in message
news:BF29447B-189F-4E4F-B531-0D1E43522A55@.microsoft.com...
> Its froma Admin. stanpoint. These databses are created my Sharepoitn
> Services. I'm assuming the brackets are required when I reference them.
> I
> don't actual name them [Intanet Databse] do I?
> "Adam Machanic" wrote:
>> You can, but you need to delimit the names with brackets:
>> [Intanet Content Databse]
>> In my opinion it's not a good practice. Do the spaces really add
>> anything
>> extra to the name? Furthermore, why do you need to add the "Database"
>> (or
>> "Databse" in your case) identifier? Do your client tools merge databases
>> and other types of objects in the same views, such that you need the
>> additional text to differentiate between them in a list?
>>
>> --
>> Adam Machanic
>> Pro SQL Server 2005, available now
>> http://www.apress.com/book/bookDisplay.html?bID=457
>> --
>>
>> "George Schneider" <georgedschneider@.news.postalias> wrote in message
>> news:294E9BC0-5A7A-490E-B678-63242CCA6B3D@.microsoft.com...
>> > Can you have Databse names that contain spaces such as Intanet Content
>> > Databse? Will this cause any issues in SQL 2000?
>>|||And you can also use double-quotes, "Intanet Databse", which is the ANSI SQL way to delimit
identifiers.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:OzwT9DeKGHA.964@.tk2msftngp13.phx.gbl...
> Brackets are required both when creating them and when referencing them. I assume Sharepoint does
> that automatically for you...
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "George Schneider" <georgedschneider@.news.postalias> wrote in message
> news:BF29447B-189F-4E4F-B531-0D1E43522A55@.microsoft.com...
>> Its froma Admin. stanpoint. These databses are created my Sharepoitn
>> Services. I'm assuming the brackets are required when I reference them. I
>> don't actual name them [Intanet Databse] do I?
>> "Adam Machanic" wrote:
>> You can, but you need to delimit the names with brackets:
>> [Intanet Content Databse]
>> In my opinion it's not a good practice. Do the spaces really add anything
>> extra to the name? Furthermore, why do you need to add the "Database" (or
>> "Databse" in your case) identifier? Do your client tools merge databases
>> and other types of objects in the same views, such that you need the
>> additional text to differentiate between them in a list?
>>
>> --
>> Adam Machanic
>> Pro SQL Server 2005, available now
>> http://www.apress.com/book/bookDisplay.html?bID=457
>> --
>>
>> "George Schneider" <georgedschneider@.news.postalias> wrote in message
>> news:294E9BC0-5A7A-490E-B678-63242CCA6B3D@.microsoft.com...
>> > Can you have Databse names that contain spaces such as Intanet Content
>> > Databse? Will this cause any issues in SQL 2000?
>>
>|||Sharepoint doesn't create it with Brackets. It shows up in EM as Inranet
Company Content.
"Tibor Karaszi" wrote:
> And you can also use double-quotes, "Intanet Databse", which is the ANSI SQL way to delimit
> identifiers.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
> news:OzwT9DeKGHA.964@.tk2msftngp13.phx.gbl...
> > Brackets are required both when creating them and when referencing them. I assume Sharepoint does
> > that automatically for you...
> >
> >
> > --
> > Adam Machanic
> > Pro SQL Server 2005, available now
> > http://www.apress.com/book/bookDisplay.html?bID=457
> > --
> >
> >
> > "George Schneider" <georgedschneider@.news.postalias> wrote in message
> > news:BF29447B-189F-4E4F-B531-0D1E43522A55@.microsoft.com...
> >> Its froma Admin. stanpoint. These databses are created my Sharepoitn
> >> Services. I'm assuming the brackets are required when I reference them. I
> >> don't actual name them [Intanet Databse] do I?
> >>
> >> "Adam Machanic" wrote:
> >>
> >> You can, but you need to delimit the names with brackets:
> >>
> >> [Intanet Content Databse]
> >>
> >> In my opinion it's not a good practice. Do the spaces really add anything
> >> extra to the name? Furthermore, why do you need to add the "Database" (or
> >> "Databse" in your case) identifier? Do your client tools merge databases
> >> and other types of objects in the same views, such that you need the
> >> additional text to differentiate between them in a list?
> >>
> >>
> >> --
> >> Adam Machanic
> >> Pro SQL Server 2005, available now
> >> http://www.apress.com/book/bookDisplay.html?bID=457
> >> --
> >>
> >>
> >> "George Schneider" <georgedschneider@.news.postalias> wrote in message
> >> news:294E9BC0-5A7A-490E-B678-63242CCA6B3D@.microsoft.com...
> >> > Can you have Databse names that contain spaces such as Intanet Content
> >> > Databse? Will this cause any issues in SQL 2000?
> >>
> >>
> >>
> >
> >
>|||The brackets (or double-quotes) are used when referencing the database.
They are not part of the string -- just there to delimit it.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"George Schneider" <georgedschneider@.news.postalias> wrote in message
news:A782969A-728B-44E5-98C2-8BB105BFC421@.microsoft.com...
> Sharepoint doesn't create it with Brackets. It shows up in EM as Inranet
> Company Content.
> "Tibor Karaszi" wrote:
>> And you can also use double-quotes, "Intanet Databse", which is the ANSI
>> SQL way to delimit
>> identifiers.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
>> news:OzwT9DeKGHA.964@.tk2msftngp13.phx.gbl...
>> > Brackets are required both when creating them and when referencing
>> > them. I assume Sharepoint does
>> > that automatically for you...
>> >
>> >
>> > --
>> > Adam Machanic
>> > Pro SQL Server 2005, available now
>> > http://www.apress.com/book/bookDisplay.html?bID=457
>> > --
>> >
>> >
>> > "George Schneider" <georgedschneider@.news.postalias> wrote in message
>> > news:BF29447B-189F-4E4F-B531-0D1E43522A55@.microsoft.com...
>> >> Its froma Admin. stanpoint. These databses are created my Sharepoitn
>> >> Services. I'm assuming the brackets are required when I reference
>> >> them. I
>> >> don't actual name them [Intanet Databse] do I?
>> >>
>> >> "Adam Machanic" wrote:
>> >>
>> >> You can, but you need to delimit the names with brackets:
>> >>
>> >> [Intanet Content Databse]
>> >>
>> >> In my opinion it's not a good practice. Do the spaces really add
>> >> anything
>> >> extra to the name? Furthermore, why do you need to add the
>> >> "Database" (or
>> >> "Databse" in your case) identifier? Do your client tools merge
>> >> databases
>> >> and other types of objects in the same views, such that you need the
>> >> additional text to differentiate between them in a list?
>> >>
>> >>
>> >> --
>> >> Adam Machanic
>> >> Pro SQL Server 2005, available now
>> >> http://www.apress.com/book/bookDisplay.html?bID=457
>> >> --
>> >>
>> >>
>> >> "George Schneider" <georgedschneider@.news.postalias> wrote in message
>> >> news:294E9BC0-5A7A-490E-B678-63242CCA6B3D@.microsoft.com...
>> >> > Can you have Databse names that contain spaces such as Intanet
>> >> > Content
>> >> > Databse? Will this cause any issues in SQL 2000?
>> >>
>> >>
>> >>
>> >
>> >
>>

Friday, February 17, 2012

DataBase Log error.

Hi guys,

Toda i try to insert one row in my databse product table.....that time i got this kind of error.....

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]The log file for database 'testDatabase' is full. Back up the transaction log for the database to free up some log space.

the transaction log for the database to free up some log space.

/xxxx/yyyy/zzzzzzzzzzzz.asp, line 109

any one know about this kind of error .......pls help me......

thanks in advanseHave a look at this:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx#EYRAE|||ever since they changed the default recovery mode from 7 to 2000 I wish they had added a screen to the setup with big flashing letters about the implications.|||Can i use following command for this one,

dbcc shrinkfile ([dbname_log])|||well you could do a dbcc shrinkfile ([dbname_log],1) but the real issue you need to address here is your recovery model and what I suspect is your non-existent disaster recovery plan.

sql2k defaults to full recovery. which means you can recover to any point in time as long as you are performing database and transaction log backups. I suspect you are either not doing this or not doing it frequently enough because if you had been your transaction log would not have filled up your drive. unless of course you have your ldf and mdf on the same drive god forbid. In which case you are just straight running out of space and you do not really care what happens if you lose a drive or a machine which will eventually happen.

Thursday, March 29, 2012

Database Name

Database Name

Database Name

Friday, February 17, 2012

DataBase Log error.

Database Overwritten

Blog Archive

About Me