Hi Guru's,
It takes me a long time to view in EM under Mangement/SQL Server Logs/current file. Is there a way I can shorten that file so it won't take so long to view the current file?
Thanks in advance. :eek:
Hi all
Just now a BCK job failed I have only one way to find out the cause of failure fromLOG,but log file is not opening
what is the cause may be?
I have Developed ETL Package Which Supplying the CSV File, if I run the package Next time if Same File name is there I need to Rename the that File with Currentdatetime need to move in to Archive Folder. if that File is not exist in that location no need to move the file into Archive file.
View 4 Replies View RelatedHi,
My replication application need to be able to skip the from-last-stop remaining logs (that means to skip the logs generated from the last stop time of my replication application), how can i realize it? thanks.
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
I am wondering if it is possible to archive records out of a SQL Server Database. The records would then be removed from the original database. This process should be able to be run multiple times (with user interface).
View 2 Replies View RelatedI am using SQL 2012 SE. I have 2 databases say A and B with same structure and relationships. There are 65 tables in each database. A is already replicating data to database C for 35 tables. Now I need to move data from A to B which is greater than getdate()-1 everyday for all the tables and once the move is done I need to delete this data from A. And the same thing the next day and everyday. Since this is for 65 tables its challenging to identify the insert order. Once the insert order is identified the delete order will be the reverse of it.
Is there a tool or any SP that could generate the insert order script? The generate scripts data only is generating the entire data and these databases are almost 400GB. Some tables have 200Mil+ rows. So it takes forever.
I'm looking for a process to archive data through replication. I have nightly job that purge records in few source tables(publisher) retaining only 3 yrs data. I have archive database (subscriber) that contains prior 3 yrs data and current 3 yrs data.
Before nightly job DELETES records in Source table i want to STOP replication so that the delete is not replicated in archive database. After the job completes i would like to TURN ON replication so that any new inserts and updates in Source will ONLY be replicated in archive database.
My DBA tested this but after last step of turning replication back ON archive database is sync'd with source table.
There are around 70 tables where 30 of them are transactional tables that needs record purge. Developing ETL process is possible but tedious.
I wrote code to archive Data.I created a table that set the maximum number of records to archive and delete and loop until finished or a set a flag in a table to stop archiving. I was able to limit the number of records to commit.
View 9 Replies View RelatedI have some table that need to be partitioned and archive one of the partitions.
I did this in Oracle several years ago but not in SQL Server.
I'm looking for a basic example on how to do this.
I know the basic steps but the examples that I found on the Web were not quite what I'm looking for.
[url][/
Partition an existing SQL Server Table
url]
I have these two tables Log and CategoryLog, I need to archive records older than 13 months in these two tables to two separate tables and then delete the archived records from Log and CategoryLog tables. The problem is that only 'Log' table has a date column, the other table CategoryLog does not have any date column. But the two tables are connected by a column(LogID). How to archive the data and then delete the archive data from both tables.
View 9 Replies View RelatedOS: 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.
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
I've this query
SELECT
t1.ID, t1.Date, t1.Time,
t1.VALUE
FROM RESULT WHERE t1.Date>=CONVERT(VARCHAR(10),DATEADD(d,-7,GETDATE()),101) AND
t1.Date<CONVERT(VARCHAR(10), GETDATE(), 101)
Let's say, current date is 8 AUG 2005 and current time is 2045
So, i will get
ID | Date (this is datetime) | Time (this is integer) | Value
--------------------------------------------------
204 | 8/1/2005| 2359 | 90
205 | 8/1/2005| 2250 | 99
206 | 8/1/2005| 1950 | 88
...
...
207 | 8/7/2005| 1845 | 77
208 | 8/7/2005| 2255 | 77
209 | 8/7/2005| 2140 | 77
Can someone can show me to filter data between
t1.Date>=CONVERT(VARCHAR(10),DATEADD(d,-7,GETDATE()),101) AND TIME>=CurrentTime
t1.Date<CONVERT(VARCHAR(10), GETDATE(), 101) AND TIME<=CurrentTime
If current date is 8 AUG 2005 and current time is 2045, so the result shown as follow
ID | Date (this is datetime) | Time (this is integer) | Value
--------------------------------------------------
204 | 8/1/2005| 2359 | 90
205 | 8/1/2005| 2250 | 99
...
...
207 | 8/7/2005| 1845 | 77
I only have this query,
SELECT
t1.ID, t1.Date, t1.Time,
t1.VALUE
FROM RESULT WHERE t1.Date>=CONVERT(VARCHAR(10),DATEADD(d,-7,GETDATE()),101) AND
t1.Date<CONVERT(VARCHAR(10), GETDATE(), 101)
lack of idea to put the TIME condition.
Plz help me..
In Enterprise Manager, Management and then SQL Server Logs, when I clicked on Current or Archive#1 or 2 etc, nothing happens. This has been going on for the past 3 weeks does any one knows what is causing such problems?
View 1 Replies View RelatedIs there any way we can log in the info like this in SQL Server
Who logged in
What date
OS Name
Ipaddress
SQL Login Name
Hi
I'm very novice when it comes to SQL Server Administration.
I have been asked if the SQL Server Log can trace information on whether data supplied to an individual has been tampered with, or if it is the full data set provided.
Apologies for this vague description, but that is what I have to go on also.
I am trying to find an article which details what the purpose of SQL Server logs are and if I can extract this sort of information from them.
Any idea if the SQL server log can provide tracing/editing/exporting information?
Thanks!!
We are using sql server 2000. I checked the sql server logs and noticed that everytime a user logs into sql an error log gets created stating, "starting up database 'CORT'". This db has nothing to do with users logging in as far as I can tell. What can check to find out what's causing this error log?
View 3 Replies View RelatedI have a question that I hope someone can help with. I am attempting to load my IIS logs into SQL Server using DTS. I have done this sucessfully by manually specifying the source file. I would like to automate this process but, I have been unable to figure out how to do this. The IIS logs changes daily and the file name changes. How do I configure DTS to grab the log for the previous day?
I believe that the solution is to first copy the log to an alternate location then let DTS do it's thing. How do I programatically accomplish this ?
Thanks
kevin
I've been digging for a while to try to find something, even had a consultant looking for me, but came up empty haned.
What I want to do is this:
I activated the Security Audit level for all logins. I want to be able to report last login date for every user from the log, and all login events for SA or any other defined super users.
Is it possible to Query the SQL Server Logs to report this information?
This is for proposed Sarbox Database Security settings.
not sure if this is by default or restricted,
but I can't view the sql server logs using ctp
an error is generated saying the tsql could not be retrieved or something, very long message to post here
is this normal?
TIA
--------------------
keeping it simple...
I just installed the SSMS for 2005 Express and cannot view any SQL Server Logs. I see Current and Archive #1,#2 etc but the right pane is blank.
View 7 Replies View RelatedI recently performed an SQL server 2000 installation. Other thanplacing the program files on C: and data on D:, I saw no option toinstall transaction logs in an alternate location.What is the best practice with SQL server 2000 for location oftransaction logs? I remember that Microsoft used to take the positionthat transaction logs should be placed on their own FAT partition.
View 3 Replies View RelatedI have SQL Server 2005 Express on a Windows XP SP2 machine. Everything works fine and I have several dbs running. How ever I was wanting to optimize some programs and needed to watch the server and see what it is processing. I log into SQL Management Studio Express and when I go to Management->Server Logs I see the logs and the Activity Monitor. If I right click on the log all I see is Refresh. If I doule click nothing happens. I can view the Activity Monitor and the processes going.
I am sure it is a permission thing or something along those lines. I can not for the life of me figure it and have spent a couple days on google and these forums. I have tried with the SA, my defined users, and the local windows administrator. Is log viewing not allowed in SQL Server Express?
Thanks!
Michael
Hi,
I understand that there is a SQL Server Logs section in Enterprise Manager 2000 where we can view SQL Server activity. Is it possible that we can get those logs by using query? I had been searching over the Internet, system databases, system SP and still have no idea how to achieve it.
Thanks in advance.
Regards,
maxChin
how i can clear sql server logs by run xp_cmdshell stored procedure.
(my user in sql server is a admin).
i don't want use enterprise manager . i want write a query and use at xp_cmdshell .
befor thx.
Hi,
Can any one suggest me how to find a error log when SQL Server Agent is down. I did not find it in NT error log when my SQL Server Agent was shut down. Is it known problem and pls also suggest me for the remedy to this problem.
thanks in advance.
regards,
Narayanan.
Unable to view the server logs via EM. sp_cycle_errorlog tried, no help. The physical errorlog file is in c:mssql7log. A server reboot doesn't help either.
View 1 Replies View RelatedHi,
I have an issue with an application, and i want to know what sql queries are done by this application. So i need to read the .ldf file, i have do some search on google, but i find nothing thant can be relevant.
I am trying to setup 2 SQL servers (ver 6.5) - A live server and a standby server. The plan is to have regular transaction logs dumps from the Live server databases to the standby server and then have these logs automatically applied.
I have managed to get the logs dumping automatically but when I tried to apply them I keep getting synchronisation/sequence errors.
Has anyone done/tried anything similar. Any advice on this would be very useful.
Thanks
Samir
P.S I can't do this via replications as most tables in the database do not have primary keys.
Dear All,
We have recently moved our NT boxes with SQL Server to
a new computer room 10 minutes walk away.
Is it possible to examine the NT error logs from a SQL
Server client using perhaps an xp command?
Many Thanks in Advance,
Andrew
friend can i ask something like this
what query that can i truncate the transaction logs or shrink it into
2mb.
Please response to this. I need help
Thanks
Hey Geeks,
I have found in the SQL Server Logs under Management Menu that says something like this :
Login failed for user 'sa'. [CLIENT: 59.144.69.233], Time : 3/9/2006 3:41:53 PM
And for every second there is addition in the messages.
Why is it happening? Can anyone tell me?
Thanks in Advance.
Snehal