Showing posts with label point. Show all posts
Showing posts with label point. Show all posts

Thursday, March 29, 2012

Database name with point in it (mail.archive.mdf) not recognised in query analyser of SQL

Apparently the query analyser of sql server does not recognise a
database with a point in it, like
mail.archive.mdf

I receive the following error when I use it:

Server: Msg 911, Level 16, State 1, Line 1
Could not locate entry in sysdatabases for database 'mail'. No entry
found with that name. Make sure that the name is entered correctly.

Please help, thanks
Premselect * from master..sysdatabases
where name ='mail.archive'

mdf is not part of the name

Denis the SQL Menace
http://sqlservercode.blogspot.com/

Prem wrote:
> Apparently the query analyser of sql server does not recognise a
> database with a point in it, like
> mail.archive.mdf
> I receive the following error when I use it:
> Server: Msg 911, Level 16, State 1, Line 1
> Could not locate entry in sysdatabases for database 'mail'. No entry
> found with that name. Make sure that the name is entered correctly.
> Please help, thanks
> Prem|||Prem (premmetje@.zonnet.nl) writes:
> Apparently the query analyser of sql server does not recognise a
> database with a point in it, like
> mail.archive.mdf
> I receive the following error when I use it:
> Server: Msg 911, Level 16, State 1, Line 1
> Could not locate entry in sysdatabases for database 'mail'. No entry
> found with that name. Make sure that the name is entered correctly.

Need to use brackets or double quotes for identifiers with characters
that are not identifier characters normally:

USE [mail.archive.mdf]

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Thursday, March 22, 2012

Database Mirroring

Hi All
Can anyone point me in the right direction to any references or step by step
instructions for installing database mirroring?
ThanksBooks On-Line is the best starting point. I would download the latest
version first.
http://www.microsoft.com/technet/pr...oads/books.mspx
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"David" <David@.discussions.microsoft.com> wrote in message
news:F2F5AAA2-785B-45DA-A1D6-C5BFB3A69C67@.microsoft.com...
> Hi All
> Can anyone point me in the right direction to any references or step by
> step
> instructions for installing database mirroring?
> Thanks
>|||Take a look at this paper by Ron Talmage
http://www.microsoft.com/technet/pr...5/dbmirror.mspx
Ben Nevarez, MCDBA, OCP
Database Administrator
"David" wrote:

> Hi All
> Can anyone point me in the right direction to any references or step by st
ep
> instructions for installing database mirroring?
> Thanks
>

Wednesday, March 21, 2012

Database Mirroring

Hi All
Can anyone point me in the right direction to any references or step by step
instructions for installing database mirroring?
ThanksBooks On-Line is the best starting point. I would download the latest
version first.
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"David" <David@.discussions.microsoft.com> wrote in message
news:F2F5AAA2-785B-45DA-A1D6-C5BFB3A69C67@.microsoft.com...
> Hi All
> Can anyone point me in the right direction to any references or step by
> step
> instructions for installing database mirroring?
> Thanks
>|||Take a look at this paper by Ron Talmage
http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx
Ben Nevarez, MCDBA, OCP
Database Administrator
"David" wrote:
> Hi All
> Can anyone point me in the right direction to any references or step by step
> instructions for installing database mirroring?
> Thanks
>

Wednesday, March 7, 2012

Database maintenance and Database Administration?

I need some help...
Can someone please, in point blank form tell me the difference between
Database maintenance and Database Administration? This might seem
obvious, however apparently I am not certain.
thxDatabase Administration is the task you undertake when agreeing to administe
r a database for your
company (typically). It can involve tasks such as:
Planning, implementing and managing permissions
Writing stored procedures
Performance tuning
Import/export of data
...
Among the things a dba typically is responsible for is database maintenance
(things you typically
does at a regular schedule):
Backup
Defragmentation
Integrity check of the database
...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<angela.solorzano@.ca.wunderman.com> wrote in message
news:1123182460.104320.150300@.f14g2000cwb.googlegroups.com...
>I need some help...
>
> Can someone please, in point blank form tell me the difference between
> Database maintenance and Database Administration? This might seem
> obvious, however apparently I am not certain.
>
> thx
>|||I guess that the terms are often used interchangeably, though intuitively,
I'd say that maintenance is a private case of administration.
That is, "administrating" involves both setting up the environment, creating
objects, etc., and also taking care of already existing environment/objects,
while "maintaining" refers to only the latter.
Nothing formal, just something that seems intuitive.
BG, SQL Server MVP
www.SolidQualityLearning.com
<angela.solorzano@.ca.wunderman.com> wrote in message
news:1123182460.104320.150300@.f14g2000cwb.googlegroups.com...
>I need some help...
>
> Can someone please, in point blank form tell me the difference between
> Database maintenance and Database Administration? This might seem
> obvious, however apparently I am not certain.
>
> thx
>

Sunday, February 19, 2012

Database losing changes

I have a SQL Server 2000 SP2 database. I can work on it all day, and everything is fine. Backups run at 7:00pm successfully. At some point after that, usually about midnight, all changes are rolled back. I can restore from the 7:00pm backup, but overnight every change (including those restored) will again disappear.

I have tinkered for two weeks, checking every setting and running every automated job (there are three) interactively. Nothing seems to cause or cure this problem. But every morning when I come in, my database is back to where it was on or about March 15.

One possible clue: there is a SQL log entry stating "Transaction Log Truncated" that appears to happen about the same time - midnight. I do not know why this is happening or whether it is significatnt; I truncated the transaction log interactively, with no negative effect. Also, the problems began after I installed SP2.

Any ideas?Probably best to leave the profiler running - logging t a text file to find out whats happenning.

It sounds like something is restoring a backup.
If your backup restore does hold the data then it gets lost again at midnight then there must be a task that is deleting everything that has been added after march 15 or a backup is being restored from that date.

Try creating a new table - if that disappears then you will now that it isn't just a task that deleted data.

Check with the network people that they aren't trying to backup the disk. This will probably lock the database files and crash the server. If you are holding open transactions then all changes in those transactions would be lost.