Hi All,
We have some 3 openings for SQL Server DBA in our company. Our Company name is
Tesco, if any one is interested please sent me your resumes. You should have
atleast 4 years of experience as SQL Server DBA in production environment.
With :))s
Santhosh Kumar S.J - MCTS
ReadMe @ sqlspy.blogspot.com
ReadMe @ santhoshpakkangal.blogspot.com
[Non-text portions of this message have been removed]
Hello ,
When Google, Facebook and Twitter was launched, no one thought that it will
become our necessity, I come to know a very interesting and innovative concept,
could be another miracle in coming months and hence sharing with you, Judge
yourself!!
Advertisers are paying now to the end-users to see the ads of their products and
services!!
The platform has been tested and established now and end-users are being paid
every month since Novmber'09, continuously for 7 months and now it's going to be
forever. Lacs of rupees rewards have been reached to end users and will touch 1
Crore (10 Million) in just few days.
Thousands of end-users are getting rewards by way of cheques & gift vouchers
every month, its reward to see the ads of products in their personal time, the
best part of the concept, end user see the ads of only his/her interest &
matching with the profile.
Check the list of recipients of rewards, proof of payments and testimonials of
thousands of users:
http://www.viewbestads.com/index/gallary/flag/payments
Concept
|
View Ads
|
Play Quiz
|
Advertiser's FAQ
|
Viewer's FAQ
|
Today's Positive News
Sign Up! Its free and anyone can join
*Email ID
*First Name
*Last Name
*Password
*Confirm Password
*Confirm Email ID
Middle Name
*Referred By:
By Email
By ID
None
*Refferal ID:
I agree to
Terms & Conditions.
Worth Viewing
Find any published ad, Read only positive news, See ads of
only your interest and the best part get rewarded for it, forever!!
View Ads |
News |
Published Ads
Success Story
Advertisers are paying now to the end-users to see the
ads of their products and services!!
Success Story
Contest / Games
Just spend few minutes and refresh yourself, guaranteed
relaxation for rest of the day. Be winner if you can!!
Memory Game | Quiz | Nifty
Free SMS
When it's free, no point in wasting your own earned
money; we are smart and know how to spend it wisely, right?
Free unlimited SMS
Home | Concept | Sign Up | Login
Copyright 2003-2009 ViewBestAds.Com. All Rights Reserved.
If you have received this mail from a unknown source and want to unsubscribe due
to personal reasons, please click below link as we also have 0% tolerance for
SPAMTo unsubscribe and no longer receive emails from viewbestads.com, click
here.If you received this email in Spam then Click Here
[Non-text portions of this message have been removed]
Hello ,
When Google, Facebook and Twitter was launched, no one thought that it will
become our necessity, I come to know a very interesting and innovative concept,
could be another miracle in coming months and hence sharing with you, Judge
yourself!!
Advertisers are paying now to the end-users to see the ads of their products and
services!!
The platform has been tested and established now and end-users are being paid
every month since Novmber'09, continuously for 7 months and now it's going to be
forever. Lacs of rupees rewards have been reached to end users and will touch 1
Crore (10 Million) in just few days.
Thousands of end-users are getting rewards by way of cheques & gift vouchers
every month, its reward to see the ads of products in their personal time, the
best part of the concept, end user see the ads of only his/her interest &
matching with the profile.
Check the list of recipients of rewards, proof of payments and testimonials of
thousands of users:
http://www.viewbestads.com/index/gallary/flag/payments
Concept
|
View Ads
|
Play Quiz
|
Advertiser's FAQ
|
Viewer's FAQ
|
Today's Positive News
Sign Up! Its free and anyone can join
*Email ID
*First Name
*Last Name
*Password
*Confirm Password
*Confirm Email ID
Middle Name
*Referred By:
By Email
By ID
None
*Refferal ID:
I agree to
Terms & Conditions.
Worth Viewing
Find any published ad, Read only positive news, See ads of
only your interest and the best part get rewarded for it, forever!!
View Ads |
News |
Published Ads
Success Story
Advertisers are paying now to the end-users to see the
ads of their products and services!!
Success Story
Contest / Games
Just spend few minutes and refresh yourself, guaranteed
relaxation for rest of the day. Be winner if you can!!
Memory Game | Quiz | Nifty
Free SMS
When it's free, no point in wasting your own earned
money; we are smart and know how to spend it wisely, right?
Free unlimited SMS
Home | Concept | Sign Up | Login
Copyright 2003-2009 ViewBestAds.Com. All Rights Reserved.
If you have received this mail from a unknown source and want to unsubscribe due
to personal reasons, please click below link as we also have 0% tolerance for
SPAMTo unsubscribe and no longer receive emails from viewbestads.com, click
here.If you received this email in Spam then Click Here
[Non-text portions of this message have been removed]
Hi Friends,
Please help me for this Question .
How may Tables can we use in a Join (any Join Inner,Outer,Left.....)
in SQL 2005.
10,20,50.......300 Tables ...? How many Tables .... Please help
Regds
Rakesh Dhar
[Non-text portions of this message have been removed]
There is no limitation as far as I know. Any number you prefer you can use,
the more the join, the slower the fetching of data.
From: sqlcon@yahoogroups.com [mailto:sqlcon@yahoogroups.com] On Behalf Of
rakesh dhar
Sent: Tuesday, July 20, 2010 1:59 PM
To: sqlcon@yahoogroups.com
Subject: MUGH-SQLCON Help
Hi Friends,
Please help me for this Question .
How may Tables can we use in a Join (any Join Inner,Outer,Left.....)
in SQL 2005.
10,20,50.......300 Tables ...? How many Tables .... Please help
Regds
Rakesh Dhar
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Hi All,
Here a i have a problem with in Database mirroring environment.
I have a huge unsent log in Asynchronous (high Performance mode)
Its current sending rate is @ 452 kb. Is there any way to increase this value.
What is standard sending rate ..
What are the components on which Current send rate is dependent, so that we can
modify and get the mirroring in sync asap ..
Your help is very much appreciated
Best Regards
Shyam Sunder .K
Database Administrator.
98851 33956.
[Non-text portions of this message have been removed]
Hi Shyam,
Basically the sending rate depends upon your network speed. 452 kbps looks like
bit slow. Why is it low is your network over loaded or are you doing mirroring
across geographical locations over a slow connection. Are you using the same nic
for both data and mirror traffic?
With :))s
Santhosh Kumar S.J - MCITP
ReadMe @ sqlspy.blogspot.com
ReadMe @ santhoshpakkangal.blogspot.com
________________________________
From: Shyam Sunder <shyam_k25@...>
To: sqlcon@yahoogroups.com
Sent: Thu, 22 July, 2010 2:28:07 PM
Subject: MUGH-SQLCON Database mirroring - How to increase the Current send rate
Hi All,
Here a i have a problem with in Database mirroring environment.
I have a huge unsent log in Asynchronous (high Performance mode)
Its current sending rate is @ 452 kb. Is there any way to increase this value.
What is standard sending rate ..
What are the components on which Current send rate is dependent, so that we can
modify and get the mirroring in sync asap ..
Your help is very much appreciated
Best Regards
Shyam Sunder .K
Database Administrator.
98851 33956.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Tail log backup is nothing but transaction log backup. Basically in case of
database failure the last transaction log backup taken before recovering the
database is called tail log backup. Check below
http://msdn.microsoft.com/en-us/library/ms179314.aspx
With :))s
Santhosh Kumar S.J - MCITP
ReadMe @ sqlspy.blogspot.com
ReadMe @ santhoshpakkangal.blogspot.com
________________________________
From: SARADADEVI <sv_39@...>
To: sqlcon@yahoogroups.com
Sent: Thu, 22 July, 2010 6:45:31 PM
Subject: MUGH-SQLCON How to take tail log backup in SQLServer.
How to take tail log backup in SQLServer.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Hi,
I need to set Password to expire in 80 days in SQL 2005.Can anyone help to tell
me how should i do it.
I think i also need to change the windows password policy for this.
Thanks in Advance.
Thanks & Regards
Manish Sharma
[Non-text portions of this message have been removed]
In my environment Login Auditing is currently set to "Failed Logins Only"
This is probably a carry over from the old servers were it caused excessive log
files.
However for compliance we should monitor both failed and successful logins.
Is it posible to enable "Both failed and successful logins" and monitor log file
size ?
Can log files be set to cyclic so they fill to a size then delete the oldest
entries?
Iam using SQLSERVER2008.
Iam using SQLSERVER2008.
ProductVersion : 10.0.2531.0
ProductLevel : SP1
Edition : Standard Edition
EngineEdition: 2
Dowe need to have a quick restart of the SQL Services after the changes to take
effect ?
[Non-text portions of this message have been removed]
Hi,
The solution for this would be as we cannot reset the error log based upon the
size.
1. Configure the number of error logs to say 99.
2. Create a job to reset the error log say every day (dbcc errorlog)
With :))s
Santhosh Kumar S.J - MCITP
ReadMe @ sqlspy.blogspot.com
ReadMe @ santhoshpakkangal.blogspot.com
________________________________
From: SARADADEVI <sv_39@...>
To: sqlcon@yahoogroups.com
Sent: Wed, 28 July, 2010 5:48:27 PM
Subject: MUGH-SQLCON Do we need to have a quick restart of the SQL Services
after the changes to take effect ?
In my environment Login Auditing is currently set to "Failed Logins Only"
This is probably a carry over from the old servers were it caused excessive log
files.
However for compliance we should monitor both failed and successful logins.
Is it posible to enable "Both failed and successful logins" and monitor log file
size ?
Can log files be set to cyclic so they fill to a size then delete the oldest
entries?
Iam using SQLSERVER2008.
Iam using SQLSERVER2008.
ProductVersion : 10.0.2531.0
ProductLevel : SP1
Edition : Standard Edition
EngineEdition: 2
Do we need to have a quick restart of the SQL Services after the changes to take
effect ?
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Hello ,
When Google, Facebook and Twitter was launched, no one thought that it will
become our necessity, I come to know a very interesting and innovative concept,
could be another miracle in coming months and hence sharing with you, Judge
yourself!!
Advertisers are paying now to the end-users to see the ads of their products and
services!!
The platform has been tested and established now and end-users are being paid
every month since Novmber'09, continuously for 7 months and now it's going to be
forever. Lacs of rupees rewards have been reached to end users and will touch 1
Crore (10 Million) in just few days.
Thousands of end-users are getting rewards by way of cheques & gift vouchers
every month, its reward to see the ads of products in their personal time, the
best part of the concept, end user see the ads of only his/her interest &
matching with the profile.
Check the list of recipients of rewards, proof of payments and testimonials of
thousands of users:
http://www.viewbestads.com/index/gallary/flag/payments
Concept
|
View Ads
|
Play Quiz
|
Advertiser's FAQ
|
Viewer's FAQ
|
Today's Positive News
Sign Up! Its free and anyone can join
*Email ID
*First Name
*Last Name
*Password
*Confirm Password
*Confirm Email ID
Middle Name
*Referred By:
By Email
By ID
None
*Refferal ID:
I agree to
Terms & Conditions.
Worth Viewing
Find any published ad, Read only positive news, See ads of
only your interest and the best part get rewarded for it, forever!!
View Ads |
News |
Published Ads
Success Story
Advertisers are paying now to the end-users to see the
ads of their products and services!!
Success Story
Contest / Games
Just spend few minutes and refresh yourself, guaranteed
relaxation for rest of the day. Be winner if you can!!
Memory Game | Quiz | Nifty
Free SMS
When it's free, no point in wasting your own earned
money; we are smart and know how to spend it wisely, right?
Free unlimited SMS
Home | Concept | Sign Up | Login
Copyright 2003-2009 ViewBestAds.Com. All Rights Reserved.
If you have received this mail from a unknown source and want to unsubscribe due
to personal reasons, please click below link as we also have 0% tolerance for
SPAMTo unsubscribe and no longer receive emails from viewbestads.com, click
here.If you received this email in Spam then Click Here
[Non-text portions of this message have been removed]
Hi,
I changed the “page_verify_option” set to CHECKSUM in production server.
My DR database “SAP” is in "Restoring" does this stop the setting of
Page_Verify?
If "SAP" is restored from a production copy will it inherit the Page_Verify
setting?
Regards,
kishore
[Non-text portions of this message have been removed]
Hello ,
The Concept is great, We Learn, Earn and have Fun same time & Its FREE.
No buying/selling, the website earns from advertisers and sharing profit with
us, Tested and Proven Concept. Check and if convinced; TRY, you dont loose
anything at all.
Just Click here & Judge Yourself PleaseIf you have received this mail
from a unknown source and want to unsubscribe due to personal reasons, please
click below link as we also have 0% tolerance for SPAMTo unsubscribe and no
longer receive emails from viewbestads.com, click here.If you received this
email in Spam then Click Here
[Non-text portions of this message have been removed]
I have a database with different schemas, and I was asked to restore only DBO
schema from the lightspeed backup file. Is there any way to restore a single
schema in Sql server 2005.
-Ramesh
I never did it but I think you can do it.....I copied Litespeed help content
below.
Restore Schemas in the LiteSpeed Console
Before you can recover objects or execute a SELECT statement, you must read the
backup file to create an index of restorable objects. To restore a schema,
complete the following procedures in order:
Run the Read Backup wizard
Review the backup file contents
Restore the schema
Note: This topic only covers unfamiliar information. It does not include all
step and field descriptions.
Run the Read Backup Wizard
Before you can recover objects or execute a SELECT statement, you must read the
backup file to create an index of restorable objects. The index is a .lsm file
that is saved in the same directory as the backup file.
Notes:
You cannot restore objects from tape backups or TSM files.
LiteSpeed may take a long time to read the backup file for large databases,
often with little response in the LiteSpeed Console. To prevent this, select
Optimize the object level recovery speed on the Backup wizard Options page to
create the index during the backup process.
To run the Read Backup wizard
Select the Object Level Recovery pane (CTRL+D+3).
Select Read Backup Wizard.
Complete the wizard.
Note: LiteSpeed must be installed on the server instance you select on the
Backup Source page.
Review the Backup File Contents
After you read the backup file, its contents appear in the Overview tab (click
here to see the Overview tab). The Overview tab has the following panes:
1. Objects Grid
The grid displays all of the restorable objects in backup file. You can filter
the objects that appear in the list by selecting the appropriate options in the
toolbar.
2. Script Preview
The script preview displays the DDL script. To script an object, right-click it
in the objects grid and select Generate DDL Script. For tables, you can also
include constraints, indexes, and triggers in the script by selecting the
appropriate options in the Object Level Recovery navigation pane. You can script
more than one object, and scripted objects have beside them in the objects
grid. To view all of the scripts in the script preview, click .
Note: You can save, copy, print, and search the script in LiteSpeed, but you
cannot edit or execute it in the script preview pane.
3. Table Data Preview
The table data preview displays the contents of the table. To preview a table's
data, right-click the table in the objects grid and select Preview Data. You can
only preview the data of one table at a time, and the previewed table has
beside it in the objects grid. A table that you preview and script has beside
it.
Tips: For panes that have grids, you can sort, group, move, and remove the
columns
To sort and group the results, right-click a column heading and select the
appropriate options.
To add or remove columns, right-click a column heading and select Column
Chooser. Add a column by dragging it from the list into the column headings.
Remove a column by dragging its column heading into the list.
To move a column, drag the column heading to the new location.
Restore the Schema
To restore the schema
»
Select one or more objects in the objects grid and select Recover Schema.
Thanks & Regards,
Mohd Rizwan
(¨`·.·´¨) Always
`·.¸(¨`·.·´¨) Keep
(¨`·.·´¨)¸.·´ Smiling!
`·.¸.·´
--- On Tue, 24/8/10, Ramesh <ramesh.gollapalli@...> wrote:
From: Ramesh <ramesh.gollapalli@...>
Subject: MUGH-SQLCON Is it possible to restore a single schema of a database in
sql server 2005??
To: sqlcon@yahoogroups.com
Date: Tuesday, 24 August, 2010, 12:49 PM
I have a database with different schemas, and I was asked to restore only DBO
schema from the lightspeed backup file. Is there any way to restore a single
schema in Sql server 2005.
-Ramesh
[Non-text portions of this message have been removed]
Hi,
To take log backup you need to give this command:
BACKUP DATABASE DB_NAME TO DISK='PATH\BACKUP_NAME' WITH NOTRUNCATE_ONLY
On Thu, Jul 22, 2010 at 7:24 PM, Santhosh <san_spy@...> wrote:
>
>
> Tail log backup is nothing but transaction log backup. Basically in case of
>
> database failure the last transaction log backup taken before recovering
> the
> database is called tail log backup. Check below
>
> http://msdn.microsoft.com/en-us/library/ms179314.aspx
>
>
> With :))s
> Santhosh Kumar S.J - MCITP
> ReadMe @ sqlspy.blogspot.com
> ReadMe @ santhoshpakkangal.blogspot.com
>
> ________________________________
> From: SARADADEVI <sv_39@... <sv_39%40yahoo.co.in>>
> To: sqlcon@yahoogroups.com <sqlcon%40yahoogroups.com>
> Sent: Thu, 22 July, 2010 6:45:31 PM
> Subject: MUGH-SQLCON How to take tail log backup in SQLServer.
>
>
> How to take tail log backup in SQLServer.
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
--
Thanks & Regards
Shashi Kumar Singh
Senior System Engineer
IBM India (P)Ltd.
Email:singh.shashikumar2@... <Email%3Asingh.shashikumar2@...>,
shashi_120@...
[Non-text portions of this message have been removed]
Hello ,
The Concept is great, We Learn, Earn and have Fun same time & Its FREE.
No buying/selling, the website earns from advertisers and sharing profit with
us, Tested and Proven Concept. Check and if convinced; TRY, you dont loose
anything at all.
Just Click here & Judge Yourself PleaseIf you have received this mail
from a unknown source and want to unsubscribe due to personal reasons, please
click below link as we also have 0% tolerance for SPAMTo unsubscribe and no
longer receive emails from viewbestads.com, click here.If you received this
email in Spam then Click Here
[Non-text portions of this message have been removed]
Hi
We requires that unsuccessful and successful login attempts be logged
With the excessive log files now being created is it recommended/approved to
only capture unsuccessful logins for Microsoft SQL Servers ?
For one month 141,316 entries have been added to the SQL log file on our server
Is this large number normal ?
Will the log file become unmanageable ?
There is also a significant number of logins for USA\sqlsvc - Why?
[Non-text portions of this message have been removed]
It all depends upon your requirement. If your audit requirement requires for
both successful & unsuccessful logins, you have to record it. Put a script to
recycle the error logs daily.
With :))s
Santhosh Kumar S.J - MCTS
ReadMe @ sqlspy.blogspot.com
ReadMe @ santhoshpakkangal.blogspot.com
________________________________
From: SARADADEVI <sv_39@...>
To: sqlcon@yahoogroups.com
Sent: Thu, 9 September, 2010 7:44:28 PM
Subject: MUGH-SQLCON SQL Logfile Size on our SQLServer
Hi
We requires that unsuccessful and successful login attempts be logged
With the excessive log files now being created is it recommended/approved to
only capture unsuccessful logins for Microsoft SQL Servers ?
For one month 141,316 entries have been added to the SQL log file on our server
Is this large number normal ?
Will the log file become unmanageable ?
There is also a significant number of logins for USA\sqlsvc - Why?
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Also increase the error log count to 100 or 200 as per ur audit requirements.
With :))s
Santhosh Kumar S.J - MCTS
ReadMe @ sqlspy.blogspot.com
ReadMe @ santhoshpakkangal.blogspot.com
________________________________
From: SARADADEVI <sv_39@...>
To: sqlcon@yahoogroups.com
Sent: Thu, 9 September, 2010 7:44:28 PM
Subject: MUGH-SQLCON SQL Logfile Size on our SQLServer
Hi
We requires that unsuccessful and successful login attempts be logged
With the excessive log files now being created is it recommended/approved to
only capture unsuccessful logins for Microsoft SQL Servers ?
For one month 141,316 entries have been added to the SQL log file on our server
Is this large number normal ?
Will the log file become unmanageable ?
There is also a significant number of logins for USA\sqlsvc - Why?
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Friends,
Adobe Systems (www.adobe.com ) has an open position for SQL DBA.
Location - NOIDA
Experience: 5+ years
If interested, send resume to bhavesh@...
Regards,
Bhavesh
[Non-text portions of this message have been removed]
Hi Bhavesh,
Here is my updated cv and hope it will match with your requirement.
On Sun, Sep 19, 2010 at 4:10 PM, bhavesh prajapati <
bhavesh2984groups@...> wrote:
>
>
> Friends,
>
> Adobe Systems (www.adobe.com ) has an open position for SQL DBA.
> Location - NOIDA
> Experience: 5+ years
>
> If interested, send resume to bhavesh@... <bhavesh%40adobe.com>
>
> Regards,
> Bhavesh
>
> [Non-text portions of this message have been removed]
>
>
>
--
Thanks & Regards
Shashi Kumar Singh
Senior System Engineer
IBM India (P)Ltd.
Email:singh.shashikumar2@... <Email%3Asingh.shashikumar2@...>,
shashi_120@...
[Non-text portions of this message have been removed]
Hi Friends,
I am new to SQL Server Administration.
I have created the Daily Maintenance plan as below and the Rebuild Index task
fails once in a week.
Backup Database Task - All Databases --> Maintenance Cleanup Task - Older than 1
weeks --> Check Database Integrity Task - Include Indexes --> Shrink Database
Task - All Databases --> Rebuild Index Task - Object Tables and Views --> Update
Statistics Full Scan
Now once or twice in a week the Rebuild Index Task is fails as below
Failed:(-1073548784) Executing the query "ALTER INDEX [PK_TestSet_Now] ON
[dbo].[TestSet_Now] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE =
OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE
= OFF )
" failed with the following error: "Transaction (Process ID 66) was deadlocked
on lock resources with another process and has been chosen as the deadlock
victim. Rerun the transaction.". Possible failure reasons: Problems with the
query, "ResultSet" property not set correctly, parameters not set correctly, or
connection not established correctly.
Kindly help me on this to get it resolved.
Regards
Senthil
[Non-text portions of this message have been removed]
HI Sentil,
Error itself telling that your process has been killed as a Dead Lock victim. It
means at the same time you are running some other process or jobs also, that is
creating dead lock. You can check those...or if you want to catch dead lock
information....enable the trace flag 1222 by DBCC TRACEON command. This trace
will log all dead lock information in your sql server error log.
Thanks & Regards,
Mohd Rizwan
(¨`·.·´¨) Always
`·.¸(¨`·.·´¨) Keep
(¨`·.·´¨)¸.·´ Smiling!
`·.¸.·´
--- On Thu, 23/9/10, Senthil Kumar K <mail.ksenthil@...> wrote:
From: Senthil Kumar K <mail.ksenthil@...>
Subject: MUGH-SQLCON Rebuild index Task fails in Maintenance Plan
To: sqlcon@yahoogroups.com
Cc: mail.ksenthil@...
Date: Thursday, 23 September, 2010, 1:08 PM
Hi Friends,
I am new to SQL Server Administration.
I have created the Daily Maintenance plan as below and the Rebuild Index task
fails once in a week.
Backup Database Task - All Databases --> Maintenance Cleanup Task - Older than 1
weeks --> Check Database Integrity Task - Include Indexes --> Shrink Database
Task - All Databases --> Rebuild Index Task - Object Tables and Views --> Update
Statistics Full Scan
Now once or twice in a week the Rebuild Index Task is fails as below
Failed:(-1073548784) Executing the query "ALTER INDEX [PK_TestSet_Now] ON
[dbo].[TestSet_Now] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE =
OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF,
ONLINE = OFF )
" failed with the following error: "Transaction (Process ID 66) was deadlocked
on lock resources with another process and has been chosen as the deadlock
victim. Rerun the transaction.". Possible failure reasons: Problems with the
query, "ResultSet" property not set correctly, parameters not set correctly, or
connection not established correctly.
Kindly help me on this to get it resolved.
Regards
Senthil
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Hi Mohd,
Thanks for the reply and making me to understand. Could you please tell me how
enable the trace flag 1222 by DBCC TRACEON command and in detail.
Regards
Senthil
--- On Fri, 24/9/10, mohd rizwan <mo2riz@...> wrote:
From: mohd rizwan <mo2riz@...>
Subject: Re: MUGH-SQLCON Rebuild index Task fails in Maintenance Plan
To: sqlcon@yahoogroups.com
Date: Friday, 24 September, 2010, 1:46 AM
HI Sentil,
Error itself telling that your process has been killed as a Dead Lock victim. It
means at the same time you are running some other process or jobs also, that is
creating dead lock. You can check those...or if you want to catch dead lock
information....enable the trace flag 1222 by DBCC TRACEON command. This trace
will log all dead lock information in your sql server error log.
Thanks & Regards,
Mohd Rizwan
(¨`·.·´¨) Always
`·.¸(¨`·.·´¨) Keep
(¨`·.·´¨)¸.·´ Smiling!
`·.¸.·´
--- On Thu, 23/9/10, Senthil Kumar K <mail.ksenthil@...> wrote:
From: Senthil Kumar K <mail.ksenthil@...>
Subject: MUGH-SQLCON Rebuild index Task fails in Maintenance Plan
To: sqlcon@yahoogroups.com
Cc: mail.ksenthil@...
Date: Thursday, 23 September, 2010, 1:08 PM
Hi Friends,
I am new to SQL Server Administration.
I have created the Daily Maintenance plan as below and the Rebuild Index task
fails once in a week.
Backup Database Task - All Databases --> Maintenance Cleanup Task - Older than 1
weeks --> Check Database Integrity Task - Include Indexes --> Shrink Database
Task - All Databases --> Rebuild Index Task - Object Tables and Views --> Update
Statistics Full Scan
Now once or twice in a week the Rebuild Index Task is fails as below
Failed:(-1073548784) Executing the query "ALTER INDEX [PK_TestSet_Now] ON
[dbo].[TestSet_Now] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE =
OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF,
ONLINE = OFF )
" failed with the following error: "Transaction (Process ID 66) was deadlocked
on lock resources with another process and has been chosen as the deadlock
victim. Rerun the transaction.". Possible failure reasons: Problems with the
query, "ResultSet" property not set correctly, parameters not set correctly, or
connection not established correctly.
Kindly help me on this to get it resolved.
Regards
Senthil
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
HI ,
You can enable the trace flag by running this command
dbcc traceon (1222,-1)
or add it start up parameter in SQL Server
Thanks,
Muthu
--- On Fri, 24/9/10, Senthil Kumar K <mail.ksenthil@...> wrote:
From: Senthil Kumar K <mail.ksenthil@...>
Subject: Re: MUGH-SQLCON Rebuild index Task fails in Maintenance Plan
To: sqlcon@yahoogroups.com
Date: Friday, 24 September, 2010, 11:39 AM
Hi Mohd,
Thanks for the reply and making me to understand. Could you please tell me how
enable the trace flag 1222 by DBCC TRACEON command and in detail.
Regards
Senthil
--- On Fri, 24/9/10, mohd rizwan <mo2riz@...> wrote:
From: mohd rizwan <mo2riz@...>
Subject: Re: MUGH-SQLCON Rebuild index Task fails in Maintenance Plan
To: sqlcon@yahoogroups.com
Date: Friday, 24 September, 2010, 1:46 AM
HI Sentil,
Error itself telling that your process has been killed as a Dead Lock victim. It
means at the same time you are running some other process or jobs also, that is
creating dead lock. You can check those...or if you want to catch dead lock
information....enable the trace flag 1222 by DBCC TRACEON command. This trace
will log all dead lock information in your sql server error log.
Thanks & Regards,
Mohd Rizwan
(¨`·.·´¨) Always
`·.¸(¨`·.·´¨) Keep
(¨`·.·´¨)¸.·´ Smiling!
`·.¸.·´
--- On Thu, 23/9/10, Senthil Kumar K <mail.ksenthil@...> wrote:
From: Senthil Kumar K <mail.ksenthil@...>
Subject: MUGH-SQLCON Rebuild index Task fails in Maintenance Plan
To: sqlcon@yahoogroups.com
Cc: mail.ksenthil@...
Date: Thursday, 23 September, 2010, 1:08 PM
Hi Friends,
I am new to SQL Server Administration.
I have created the Daily Maintenance plan as below and the Rebuild Index task
fails once in a week.
Backup Database Task - All Databases --> Maintenance Cleanup Task - Older than 1
weeks --> Check Database Integrity Task - Include Indexes --> Shrink Database
Task - All Databases --> Rebuild Index Task - Object Tables and Views --> Update
Statistics Full Scan
Now once or twice in a week the Rebuild Index Task is fails as below
Failed:(-1073548784) Executing the query "ALTER INDEX [PK_TestSet_Now] ON
[dbo].[TestSet_Now] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE =
OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF,
ONLINE = OFF )
" failed with the following error: "Transaction (Process ID 66) was deadlocked
on lock resources with another process and has been chosen as the deadlock
victim. Rerun the transaction.". Possible failure reasons: Problems with the
query, "ResultSet" property not set correctly, parameters not set correctly, or
connection not established correctly.
Kindly help me on this to get it resolved.
Regards
Senthil
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
This error comes when other process run or other user trying to run or execute
command when index rebuild is going to start or on the activation time.Also when
you start the index already the process doing something in the same database /
table and hold the page ...
Take the database into the single user mode run the index rebuild and then agin
back to the multi user mode
This is the standard procedure to rebuild index in the production
Radhye..
--- On Fri, 9/24/10, muthu narayanan <avm_narayanan@...> wrote:
From: muthu narayanan <avm_narayanan@...>
Subject: Re: MUGH-SQLCON Rebuild index Task fails in Maintenance Plan
To: sqlcon@yahoogroups.com
Date: Friday, September 24, 2010, 2:21 PM
HI ,
You can enable the trace flag by running this command
dbcc traceon (1222,-1)
or add it start up parameter in SQL Server
Thanks,
Muthu
--- On Fri, 24/9/10, Senthil Kumar K <mail.ksenthil@...> wrote:
From: Senthil Kumar K <mail.ksenthil@...>
Subject: Re: MUGH-SQLCON Rebuild index Task fails in Maintenance Plan
To: sqlcon@yahoogroups.com
Date: Friday, 24 September, 2010, 11:39 AM
Hi Mohd,
Thanks for the reply and making me to understand. Could you please tell me how
enable the trace flag 1222 by DBCC TRACEON command and in detail.
Regards
Senthil
--- On Fri, 24/9/10, mohd rizwan <mo2riz@...> wrote:
From: mohd rizwan <mo2riz@...>
Subject: Re: MUGH-SQLCON Rebuild index Task fails in Maintenance Plan
To: sqlcon@yahoogroups.com
Date: Friday, 24 September, 2010, 1:46 AM
HI Sentil,
Error itself telling that your process has been killed as a Dead Lock victim. It
means at the same time you are running some other process or jobs also, that is
creating dead lock. You can check those...or if you want to catch dead lock
information....enable the trace flag 1222 by DBCC TRACEON command. This trace
will log all dead lock information in your sql server error log.
Thanks & Regards,
Mohd Rizwan
(¨`·.·´¨) Always
`·.¸(¨`·.·´¨) Keep
(¨`·.·´¨)¸.·´ Smiling!
`·.¸.·´
--- On Thu, 23/9/10, Senthil Kumar K <mail.ksenthil@...> wrote:
From: Senthil Kumar K <mail.ksenthil@...>
Subject: MUGH-SQLCON Rebuild index Task fails in Maintenance Plan
To: sqlcon@yahoogroups.com
Cc: mail.ksenthil@...
Date: Thursday, 23 September, 2010, 1:08 PM
Hi Friends,
I am new to SQL Server Administration.
I have created the Daily Maintenance plan as below and the Rebuild Index task
fails once in a week.
Backup Database Task - All Databases --> Maintenance Cleanup Task - Older than 1
weeks --> Check Database Integrity Task - Include Indexes --> Shrink Database
Task - All Databases --> Rebuild Index Task - Object Tables and Views --> Update
Statistics Full Scan
Now once or twice in a week the Rebuild Index Task is fails as below
Failed:(-1073548784) Executing the query "ALTER INDEX [PK_TestSet_Now] ON
[dbo].[TestSet_Now] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE =
OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF,
ONLINE = OFF )
" failed with the following error: "Transaction (Process ID 66) was deadlocked
on lock resources with another process and has been chosen as the deadlock
victim. Rerun the transaction.". Possible failure reasons: Problems with the
query, "ResultSet" property not set correctly, parameters not set correctly, or
connection not established correctly.
Kindly help me on this to get it resolved.
Regards
Senthil
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Radhey,
//Take the database into the single user mode run the index rebuild and then
agin back to the multi user mode
This is the standard procedure to rebuild index in the production//
This approach will not work in OLTP systems which requires 24/7 availability. If
you put in single user mode it will be a complete down time for the application.
The better approach would be to run the reindex during which the system is used
minimally.
With :))s
Santhosh Kumar S.J - MCITP
ReadMe @ sqlspy.blogspot.com
ReadMe @ santhoshpakkangal.blogspot.com
________________________________
From: Radhye <radhye@...>
To: sqlcon@yahoogroups.com
Sent: Fri, 24 September, 2010 3:34:42 PM
Subject: Re: MUGH-SQLCON Rebuild index Task fails in Maintenance Plan
This error comes when other process run or other user trying to run or execute
command when index rebuild is going to start or on the activation time.Also when
you start the index already the process doing something in the same database /
table and hold the page ...
Take the database into the single user mode run the index rebuild and then agin
back to the multi user mode
This is the standard procedure to rebuild index in the production
Radhye..
--- On Fri, 9/24/10, muthu narayanan <avm_narayanan@...> wrote:
From: muthu narayanan <avm_narayanan@...>
Subject: Re: MUGH-SQLCON Rebuild index Task fails in Maintenance Plan
To: sqlcon@yahoogroups.com
Date: Friday, September 24, 2010, 2:21 PM
HI ,
You can enable the trace flag by running this command
dbcc traceon (1222,-1)
or add it start up parameter in SQL Server
Thanks,
Muthu
--- On Fri, 24/9/10, Senthil Kumar K <mail.ksenthil@...> wrote:
From: Senthil Kumar K <mail.ksenthil@...>
Subject: Re: MUGH-SQLCON Rebuild index Task fails in Maintenance Plan
To: sqlcon@yahoogroups.com
Date: Friday, 24 September, 2010, 11:39 AM
Hi Mohd,
Thanks for the reply and making me to understand. Could you please tell me how
enable the trace flag 1222 by DBCC TRACEON command and in detail.
Regards
Senthil
--- On Fri, 24/9/10, mohd rizwan <mo2riz@...> wrote:
From: mohd rizwan <mo2riz@...>
Subject: Re: MUGH-SQLCON Rebuild index Task fails in Maintenance Plan
To: sqlcon@yahoogroups.com
Date: Friday, 24 September, 2010, 1:46 AM
HI Sentil,
Error itself telling that your process has been killed as a Dead Lock victim. It
means at the same time you are running some other process or jobs also, that is
creating dead lock. You can check those...or if you want to catch dead lock
information....enable the trace flag 1222 by DBCC TRACEON command. This trace
will log all dead lock information in your sql server error log.
Thanks & Regards,
Mohd Rizwan
(¨`·.·´¨) Always
`·.¸(¨`·.·´¨) Keep
(¨`·.·´¨)¸.·´ Smiling!
`·.¸.·´
--- On Thu, 23/9/10, Senthil Kumar K <mail.ksenthil@...> wrote:
From: Senthil Kumar K <mail.ksenthil@...>
Subject: MUGH-SQLCON Rebuild index Task fails in Maintenance Plan
To: sqlcon@yahoogroups.com
Cc: mail.ksenthil@...
Date: Thursday, 23 September, 2010, 1:08 PM
Hi Friends,
I am new to SQL Server Administration.
I have created the Daily Maintenance plan as below and the Rebuild Index task
fails once in a week.
Backup Database Task - All Databases --> Maintenance Cleanup Task - Older than 1
weeks --> Check Database Integrity Task - Include Indexes --> Shrink Database
Task - All Databases --> Rebuild Index Task - Object Tables and Views --> Update
Statistics Full Scan
Now once or twice in a week the Rebuild Index Task is fails as below
Failed:(-1073548784) Executing the query "ALTER INDEX [PK_TestSet_Now] ON
[dbo].[TestSet_Now] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE =
OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE
= OFF )
" failed with the following error: "Transaction (Process ID 66) was deadlocked
on lock resources with another process and has been chosen as the deadlock
victim. Rerun the transaction.". Possible failure reasons: Problems with the
query, "ResultSet" property not set correctly, parameters not set correctly, or
connection not established correctly.
Kindly help me on this to get it resolved.
Regards
Senthil
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Send Email
