Hi Our client Top MNC wants Senior SQL DBA for Hyderabad The requirement as follows: Senior SQL DBA: Education: MCA/M.Tech/ B.Tech / BE Experience : At least...
Hi All, I have completed MCDBA for SQL Server 2000. I am planing to do certification for SQL Server 2008 can you tell me what are all the papers I need to...
Srinivas, Your MCDBA won't be able to deduct any exam for you and you have to give all the three exams. Only MCITP - 2005Â can upgrade with just two exams. ...
Meet sexy biker girls for partner, don't miss it! They are looking to chat and trade emails for pleasure and fun!!!! Our site is totally free! Finish your...
Hi Team, have you ever send a file as a attachment by running it from cmd prompt. how to do the same? If do you know how to do the same?Please let me know. ...
Hi Team, We have a request from client to hide all system views/tables from users in SQL server 2005. As user assigned to a specific database role, client do...
Hi Manish, I think you need to verify your existing indexes for tables in sql server 2005. re-build the indexes if possible. Also, you need to run below on...
Hi Manish, You will require to update the statistics so It is always advisable to run index rebuild / update statistics on the the databases when you move to a...
Dear Koushik, I think we can't hide these from a user. experts please correct me if am wrong. Best Regards Sunil John ________________________________ From:...
Hi All, We have an urgent requirement for MOSS (Microsoft Office SharePoint Server). Please little 'r' to me if you are interested in the following profile: 1)...
Hi Guys, I am looking for a SQL Server developer in my team with an experience of atleast 3 years. The opening is based in Hyderabad and this team serves the ...
Hi Guys, I need to restore the master database of a clustered server in a non clustered server. Does any one have any recommendations or Do's Don't regarding...
Hi Guys, In our company we have an opening for SQL Server DBA with 6+ yrs of relevant exp. It will be more like a architect kind of position. Apart from...
Hi, There will be no difference whether of a cluster or non cluster server for the master database restore. Let me know if u require any further details..... ...
Hi, your question is not clear how can you restore master database of one server to another server its not posiable.if you have any answer please explain with...
Chaitanya, My Question is Can we restore the master database of a clustered server to a non clustered server if yes what is the Do's and Dont's //how can you...
Hi Santhosh, you can restore the master database if you have master databse backup file. It doesn't have any relation with cluster ,it purely with sql...
Hi Santhosh, Thanqu for Replay.It possible to restore master database to restore in another server, But logingns,database entries,backup device informations...
Try increasing to "Minimum memory for query" 10 mb (10240 KB) from 1 mb On Fri, Mar 13, 2009 at 7:29 AM, Hemantgiri S. Goswami < ... -- Thanks Vijayasekar ...
Hi Chaitanya, Its up to you when to use this option, but we can restore the master db back in other server. Ex. If you want to create a replica like...
Hi Chaitanya, This kind of scenarios will be helpful in the cases like physical server to virtual server migrations. Migrations where the server properties...
Hi , If we want add extra GB in database mirroring first where we have to add like principal server or mirroring server then 1) If we add extra GB in principal...
I am trying to monitor following items: 1. Logins 2. Logouts 3. Loginfailed 4. Exixtence of users or ID in the server 5. Also, For example, we have two groups...
Hi Sarada, You don't need to worry about anything just take follow the steps: 1. Take Complete Backup (Just as a Precautionary Measure) 2. Increase the file...
Hi, Suppose, user complains that it is timed out each time he/she tries to access the database from application. How can we find out what is the problem in...
Sarada, You can set it up using sp_configure or SQL Server properties. And you can capture the login failed, login success or both. =>In SQL Server Management...