Starting Database 'XXXXX' Often In Logs

Aug 26, 2004

Hi,

I've got a sitatuation where one of our sql databases appears to be frequently "starting". The log entry looks like:

Starting up database 'Database'.

And seems to occur at irregular intervals and does not seem to be inline with any other db activity....i.e. transaction log backups, insertions or reads.

This DB is fairly busy receving inserts from our PBX CTI software almost constantly.

Note this is the only DB on the server displaying this behaviour (we've got two named instances running with several databases in each).

Any help / pointers appreciated.

Rgds,
SLE

View 10 Replies


ADVERTISEMENT

18483 COULD NOT CONNECT TO SERVER Xxxxx

Oct 8, 2004

I have to registered remote server at each one other and going to configure publisher on of them got following error-

SQL SERVER ENTERPRISE MANAGER-

SQL SERVER ENTERPRISE MANAGER COULD NOT CONFIGURE 192.168.0.246SQLIND AS THE DISTRIBUTOR FOR 192.168.0.246SQLIND

ERROR - 18483 COULD NOT CONNECT TO SERVER PRSTGINDSQLIND BECAUSE 'distributor admin' is not defined as a remote login at the server.

Thanks to all of you

View 2 Replies View Related

Placed File Xxxxx On Cabinet Yyyyy (was Please Help Me !!!!)

Apr 25, 2006

Please help me on this error :---
Executed as user: ACS1255SYSTEM. ...binet 'ABED_R2.CAB_' placed file 'ABED_R2Application.dimcr_' (size 30) on cabinet 'ABED_R2.CAB_' placed file 'ABED_R2Application.dimprop_' (size 34981) on cabinet 'ABED_R2.CAB_' placed file 'ABED_R2Application.dimtree_' (size 57829) on cabinet 'ABED_R2.CAB_' placed file 'ABED_R2ABCD_' (size 113) on cabinet 'ABED_R2.CAB_' placed file 'ABED_R2Business Area.dim_' (size 2817) on cabinet 'ABED_R2.CAB_' placed file 'ABED_R2Business Area.dimcr_' (size 30) on cabinet 'ABED_R2.CAB_' placed file 'ABED_R2Business Area.dimprop_' (size 2429) on cabinet 'ABED_R2.CAB_' placed file 'ABED_R2Business Area.dimtree_' (size 7411) on cabinet 'ABED_R2.CAB_' placed file 'ABED_R2Calendar.Calendar.dim_' (size 2221) on cabinet 'ABED_R2.CAB_' placed file 'ABED_R2Calendar.Calendar.dimcr_' (size 30) on cabinet 'ABED_R2.CAB_' placed file 'ABED_R2Calendar.Calendar.dimprop_' (size 829) on cabine... Process Exit Code 1. The step failed.

Regards,
sumit

View 2 Replies View Related

I Had Set My Windows Service's Startup Type As Automatic But It Is Not Starting Up Automatically When The System Is Starting.

May 18, 2007

Hello,



I had created a windows service using C#. I set its Startup Type as Automatic but it is not getting started automatically when my System Starts.

View 3 Replies View Related

Cannot Create A Connection To Data Source 'xxxxx' When User Runs Report

Dec 6, 2007

We have a new installation of sql server 2005 reporting services.
we can deploy reports without a problem users can connect to report server
but when they try to run reports they get this error msg.

An error has occurred during report processing.
Cannot create a connection to data source 'xxxxx'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors

in reporting services the datasource credentials are saved on the server

View 3 Replies View Related

Difference In Starting Rep Service Vs. Stopping And Starting The Rep Job?

Feb 1, 2007

When our rep distribution services time-out (several times a day) some dba's just restart the service while others restart the rep job which starts the service. Are there any differences between these two methods? Does restarting the service inherit any changes made to the job's attributes?



Thanks!

View 1 Replies View Related

Starting Up A Database????

Mar 15, 2007

OK, I've been looking and maybe there is an answer to this somewhere, but I haven't seen it.

I've got a database that has as its status "Shutdown, Normal". All the other DBs on my machine are "Normal" as status. The problem is that the one that is shutdown is the one I really need to be executing in. How do I start it?

Thanks!

Jeff

View 6 Replies View Related

Database Design Before Starting

Mar 24, 2004

Hi,

I would appreciate any help or suggesions on starting with database design for an asp.net site.
I know this question maybe sounds silly but I feel stuck and don't know where to start.

Yours sincerely
Andla

View 2 Replies View Related

Confusing Starting Up Database ....

Jul 7, 2003

Hi,
I have a SQL2k STD with SP3 installed.
Currently, only one database db_XYZ is there. The server has been started up since 07/03/2003 16:00 pm. But in the sql server current log: "Starting up database 'db_XYZ'." info is spreading from that time (16:00 pm) to this morning 10:00am at an interval from every 1 minute to 4 minutes.

Why need to 'Starting up' this database so much times?
This reminds me that this 'Starting up' is kind of 'abused' in many other servers. Any idea?

thanks
David

View 9 Replies View Related

Starting Anew Database

May 22, 2008

OK, I am experienced in VB6 but new to SQL.
And I want to use SQL for my database for some software I develop.
I have understood the basic principles how to communicate with a data base using SQL. What I have not understood is how I start a new database for SQL, subject SQL as such is installed on the server. But how to initiate a new data base?

Will really appreciate help with this.


Per Oberg

View 1 Replies View Related

DB Engine :: Write Logs To Windows Event Logs?

Aug 6, 2015

OS: Windows 2012 Enterprise

SQL Server: 2012 Enterprise

I was wondering if there is any way all SQL Server error log entries could be automatically written to Windows Event Log. 

View 3 Replies View Related

Multiple Starting Up Database Log Entries??? SQL 2000

Nov 20, 2001

The log for our SQL 2000 database shows constant "starting up database dbname" entires. Is there a option that causes the databases to constantly be starting or is this a new feature of SQL 2000.

View 1 Replies View Related

SQL Agent Is In Starting Status - But Not Starting

Mar 6, 2002

We have SQL 2000 (SP2) , Our SQL server agent showing green light as started from EM , It is succussfully restarting from NT Services too . But When I open the properties of the jobs from EM its gives error message SQL DMO error " SQl Agent is starting , try later " . And in EM Next run Date & Time not available .

MDDB database is accessable & in Log file its recovered fully

Thankx in Advance

Sha

View 1 Replies View Related

Why Is SQL 2000 Constantly Logging Starting Up Database Messages?

Nov 21, 2001

The log for our SQL 2000 database shows constant "starting up database dbname" entires. Is there a option that causes the databases to constantly be starting or is this a new feature of SQL 2000.

View 1 Replies View Related

Agent Starting Error- Waiting To Recover Database

Jun 5, 2002

SQL agent is using NT login with all permission & agent and sqlserver using the same NT username . SA password has not been changed for more than one year.

The SQL Server agent log is showing "waiting to recover database". What could be the reason ?


------------
Ray Miao at 6/5/2002 8:13:38 AM

Double check with sql service manager. Did you change sa pwd?


------------
Shaji at 6/5/2002 4:36:16 AM


Hi ,

Whenever I restart the Server , SQL server service is starting properly, but the agent is showing the green sign in EM ,agent Log also its showing its started. But in EM the jobs are not showing the next run time its showing ( Date and time not available). When I double click the jobs its showing the following error message
Micorsoft SQL - DMO ( ODBC Sql state 42000)
Error 14258 : can not perform this operation while SQL server agent is starting)
FYI :This server contain the databases of SMS too .

Thank you ,
Shaji

View 2 Replies View Related

Restoring Logs To A Database

Jul 20, 2005

Hi Gurus,i am having problems with restoring a ms sql database.i have restored the database using veritas to a different location('g:datafiles') in no recover mode.when i view the database through the Enterprise Manager, it shows thedatabase as silver icon (loading).i go to sql analyzer, and put in the restore commandrestore log myDatabasefrom 'mylog'with recoverythis produces an errorRESTORE FILELISTONLYFROM jobsServer: Msg 3206, Level 16, State 1, Line 1No entry in sysdevices for backup device 'mylog'. Update sysdevicesand rerunstatement.i look in master..sysdevices - no entry for mylog, but then no entriesfor the log files for any of the other perfectly working databaseseither.i do have a copy of the log files ('c:logfiles') in another locationi would like the following help if possible:* a way to update sysdevices with the log file i wish to apply to myrestored database so it will let my restore go through properly.* a way to specify to use apply the logs in 'c:logfiles' withouthaving to give the restore statement a logical name for the log files(which naturally won't be in sysdevices!)pls supply transact sqlmy thanksEdwina63(if wish to email please remove h from edwinah@)p.s sp_add_log_file_recover_suspect_db will not work in a partiallyrestored database

View 6 Replies View Related

Which Needs The Better Performance: Logs Or Database?

Feb 6, 2008

I have a set of disks allocated for a high performance SQL implementation that will entail lots of large queries. My question is do I allocate more IOPS to the logs or to the database?
For example, if I have a 10 disk RAID 1/0 and a 4 disk RAID 1/0 available, which do I allocate to the logs and which do I allocate to the database? Which will require the most IOPS?

Thanks!

View 3 Replies View Related

SSIS Logs Vs Custom Logs Components

Feb 12, 2007

Hi,

In my case I have to log the errors raised by any task in a package to either windows event log, text file or SQL server. Also I need to send an email notifications to a group of people telling them about the error.

Now can I use SSIS package logging for logging the errors into the required destinations. I mean right clicking on the package and selecting Logging, then adding the required log providers and enabling the events for logging into those. I think I have to upfront select the log providers to log the error, I will not have the liberty to log the error to the destination, the name of which is passed as a variable to the package. This is okay with me though.

Now what will a custom log provider help me to do in this case. Also can I somehow configure my package to call the send mail task everytime an error is raised.

Also, one more option can be developing a package that only does the error handling. It will take in the paramters or the error codes and descriptions, the destination to write to and a flag to send mail or not for that particular type of error.

What do you think? Kindly advise.

Thanks in advance for your help and time.

Regards,

$wapnil

View 3 Replies View Related

Using SSIS To Populate Database From IIS Logs

Jul 12, 2007

Hi,



I need to write a reporting app that process daily IIS logs that are averaging about 299MB a day!



I am considering using SSIS to put the log data into a sql server 2005 database.



Has anyone done this? Or does anyone know if it is possible? And without using the MS LogParser?



Thanks in advance and any help greatly appreciated!



Regards,

kitquo2.

View 4 Replies View Related

Rolling Back Transaction Logs Database

Feb 3, 2004

I have a Development database and I want to roll it back to Monday morning. I backed up the database and used the command:

RESTORE DATABASE ITTEST
FROM ITTEST20040203
WITH NORECOVERY
GO

RESTORE LOG MyNwind
FROM ITTEST20040203
WITH RECOVERY, STOPAT = 'FEBRUARY 2, 2004 09:00 AM'
GO

The transaction logs have never been truncated.

But it does not seem to have worked. It this the best way to do a roll back the database or have I missed out something.

thanks.

View 2 Replies View Related

Is There An Easy Way To Monitor (audit) Who Logs Onto A Database ??

Jul 20, 2005

Is there an easy way to monitor (audit) who logs onto a database ??Thanks for any and all help that is provided.Art

View 2 Replies View Related

Database Size Allocation - Where Other Than Tables, Logs, Etc ????

Jul 12, 2007

I have a Db that is 1.7 gigs. The table data takes approximately 200megs. The transaction logs were truncated. Where else can this large size be coming from and how can I confirm?



DB is generally small. ~25 tables, 100 SPs, 10 views, etc.



Note:



I have 4 queues using SQL Notifications, but when selecting from them results in no data.



Thanks



Scott

View 1 Replies View Related

Securing A Database When The User Logs Onto The SQL Server.

Oct 4, 2007

Hello.

Not an SQL admin. We have an SQL 2005 server that has about 5 DB's on it. One database is maintained primarily by a third party. Often when they need to do upgrades they login remotely to the desktop of our SQL server. Is there a way to apply permissions to specific databases like you would for NTFS? That way they can only backup their database and not do anything to any other databases? Thanks.

View 3 Replies View Related

Backup And Restore Database Tat Able To View All The Transaction Logs

Feb 21, 2008



Hi guys, just wanna ask about the backup and restore database method. What's the best way for database and restore which able to view all the transaction logs after the database being restored. Currently I backup my database daily for recovery purposes. However, if I restore the backup file at another server and use SQL log application for viewing the prefer database's transaction log, it shows all the previous log had been truncated.

Therefore, I want to know is there any way that able to get the transaction logs after restore from a database backup file? Hope able to get any assistance here as soon as possible. Thank you.

Best Regards,
Hans

View 1 Replies View Related

DB Engine :: Maintain All Activity Logs In Particular Database Or Server?

Nov 5, 2015

I am using SQL Server 2012. I Want To Maintain all Type Logs In Particulars database or server. I want to track all Query Which Execute in Particulars Database. and all other activity?

View 5 Replies View Related

SQL Server Logs (error Logs)

Aug 28, 2001

When looking at SQL Server error logs, I noticed that the current error
log had grown to 1MB whereas most of the files are only a few KB.

QUESTION 1: Can I set the max size for an error log file? If so, how?

QUESTION 2: If not, is there a workaround?

Thanks

View 1 Replies View Related

UDF Starting With Fn_...

Jul 20, 2005

I've read frequently how stored procedures we create shouldn't be named withsp_ since SQL Server will first check the master db before the current dbwhen trying to find the sp to execute. I always nodded and thought how Iwas glad I hadn't done that. For some reason it never clicked that UDFbehavior could be the same.I have several UDFs that start fn_... When I reference a UDF as dbo.fn_...does SQL Server check the master db for these and only upon not finding themcheck the current db? If so, is there a performance hit for this?TIA,John

View 2 Replies View Related

Starting With DM

Jul 24, 2007

Hi,

I'm quite new to this forum. I've a fair experience in Databases and Programming. Now that I want to take a stride into Data Mining and Warehousing. Experts please suggest me where I can start from and any learning path ?



Best regards,

Markish

View 1 Replies View Related

Need Help In Starting Out

Oct 25, 2006

Hi Everyone:

I am just starting out on SSIS, and have the following business challenge that I would like to solve utilizing SSIS. There are two SQL Server data stores, one would be the source, and other would be the destination. I need to grab some data from store 1, and insert that data into store 2. Here are my questions:

1) Before i move the data to store 2, i have to check some criterias by callin some sps, and then the end result would need to be inserted into the destination database. Can anyone tell me how would i setup the control flow, to accomodate that in SSIS?

2) Can someone email me a sample package that does something similar?

I just need a starting point so i can build the design of my package. Basically i need to call three sps during the process to move data. First one will compile a list of all the records to process. Second one, will pick those up, make some calls to set some other parameters, and then finally insert it into some staging tables. Third one should simply pick up the data from staging tables, to a replica of those tables in the actual destination db. I would really appreciate if I can get some response to this post soon. Also, I would appreciate if you can point me in the right direction in terms of how to design this using SSIS. Basically i need a starting point control flow design(rough) to understand what control flow items would be used in this case. Thanks.



MA



View 9 Replies View Related

SQL Agent Not Starting

Feb 12, 2002

The SQLAgent service was modified to login as a domain account. SQLAgent would not start. I made sure that the account was in the Admin group on the server, I setup the account as a System Administrator in SQL. I made sure that the network protocols in Client Network Utiliity and Server Network Utility where the same as other servers using the domain account. The message I'm getting is...

SQLServerAgent could not be started (reason: Unable to connect to server; SQLServerAgent cannot start).

I modified the properties for SQLAgent back to login as local account and I still get the same problem.

Any suggestions would be appreciated.

Sidney Ives
Database Administrator
Sentara Healthcare.

View 4 Replies View Related

SQLServerAgent Not Starting

Mar 15, 2001

When my system re-boots SQLServerAgent will no longer start. The following message is sent to the NT Event Log:

(Event ID 103) "SQLServerAgent could not be started (reason: Unable to connect to server; SQLServerAgent cannot start)."

Following this message are two messages from MSSQLServer that read:

(Event ID 19020) "RPC Net-Library listening on: ncalrpc:USBGRSYSTST1[WMSG0000009A.00000001]."

So is this a timing issues? Is MSSQLServer taking too long to completely start before SQLServerAgent is started? If so, is there a way (without hacking through the registry) to make the SQLServerAgent service dependant on the MSSQLServer service?

This startup issue did not exist until an application was installed on the machine that also has several services that auto-start. I noticed that many of these new services are starting at the same time the MSSQLServer service is starting.

Any asssistance would be most appreciated.

View 2 Replies View Related

SQL Server Not Starting

Aug 7, 2000

I am receiving the following error when I am trying to start the SQL server.Any help is appreciated.


"An error(1069 service did not start due to logon failure)while performing this service operation on MSSQLserver service"

Thanks.

View 1 Replies View Related

SQL Agent Not Starting

Oct 27, 2000

For three months I have be starting the SQL Agent using the following bat file

EXEC XP_CMDSHELL 'NET START SQLSERVERAGENT'.

Starting this week the agent is not starting. This is the error message

10/26/00 6:25:36 PM - ! [000] Password verification of the 'SQLAgentCmdExec' proxy account failed (reason: A required privilege is not held by the client)

What could have changed on the Server?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved