How to ask a question efficiently in TechNet forum
Thank you for posting in TechNet forum. The online problem solving can be relatively time consuming because it may demand several messages back and force to fully understand the symptom and background, especially at the very beginning. Here are a few suggestions that help you get the best answer to your question as quickly as possible.
When You Ask
1. Selecting a good title which summarizes the specific problem you have. It will be the one of the main driving forces for others to want to actually read your item. Choosing a badly-formatted title will drive people away, thinking that since the title is so badly written, so must be the information and the question within the thread.
2. Provide all the necessary information in your initial post. The following information would be very helpful:
- Symptom description: Detailed description of the problem. If you receive any error messages, please let us know the exact error WORD BY WORD.
- Environment: The system environment, such as your OS/application version, your network topology, and your domain environment, etc.
- Any recent relevant configuration change(s): If the issue started to occur after installing any application/updates or changing the configuration, please let us know.
- Any additional information. Tell what you have done prior to asking your question. This will help us understand that you've done so far.
3. Write in a clear language. Avoiding spelling mistakes or grammatical errors. Don't type IN ALL CAPS, which in most cases is read as shouting and considered rude.
4. Keep with the same thread. Do not refer to a post you made last year, and above all, Please come back. There are hundreds and thousands of posts where we have seen people given great and wonderfully long answers yet no reply from the original poster.
5. Be courteous to reply, even if it's to say. "I've given up" or thanks that worked. (This helps the whole community when you do this, and makes the people who donate time, warm and fuzzies.)
When answered
Give Positive Feedback. Once you've received a correct answer to your question, either from a Microsoft employee, an MVP, or the community in general, pleases replies that the issue or question has been answered. And if possible mark the solution as answered: This step is important, since it lets other people benefit from your posts.
Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
Reply:
hello and happy resolving to the entire forum. Another point to add, especially through my involvement in the Technical Problem-Solving Field since 1998, EXACT error messages or "Screenshots" copied and pasted by choosing ALT+PrtScn and CTRL+V in the question window would be most helpful and could encourage a more expedient answer, if any, to the issue experiencing to provoke the need for the forum. (In my own personal involvement with TechNet since 1998, the research through the Support Website may provide the answer as well; therefore eliminating the time lapse for a forum response on the TechNet DB.) Happy Hunting and may all your issues be resolved First-call for a most successful implementation and rollout.
Good Days are vast approaching!
Jennifer :)
Ultimate Goal for Achievement (deviated from personally-written statement and concept presented in 1992 and carried forward to Armed Forces Branches of the Military in 1996, and through personal involvement and training acquired by way of Technology in several fields to be involved in the compilation and interface process to encourage fulfillment through concept, design, testing, rollout, deployment, and interface in the field of medicine - more specifically Real-Time access, compilation, and readout of field-specific Geographical locations to assist Emergency First-Responders accuracy and a more timely process and procedure attempt to save lives through the interface which ultimately proves to be a less traumatic event on the victim and would increase response and incident time at each scene.) HIS INTERFACE IS TO INCREASE THE VALUE OF LIFE IN A ONCE PERCEIVED LIFE DEHABILITATING TRAUMATIC EXPERIENCE BY IMPROVING BY TIME AND COMMUNICATION OVER REAL-TIME NETWORK UPDATING THROUGH A gps INTERFACE AND LESS RECESSITATION AND STABILIZATION TIME WHILE IN AN EVER-CHANGING FAST-PACED ADVANCING WORLD. this system will compile Scientific Geographical Region Data, compute schematically any changes to the field which could interfere physioanatomically with how the treatment is asserted and carried forth while also improving the communication process to the next phase of monitoring and or hospitalization. The fewer attempts by way of reviving = less affliction on the Human Body and a Godsped recovery. I, personally would like to see the deathrate be an increased number and less time utilized to develop a better approach which could have eleviated the toll initially. Although the information is available through Public Access and millions if not billions of research already gathered, not everyone has that knowledge and accessibility to each one of those resources and allow for an increase to the accuracy rate of documentation. This was designed with the realization throughout life with a sister who suffered numerous surgeries because of a birth-defect (and her friends who had similiar defects), through personal experience in a vehicle accident in which a mild concussion which caused confusion and the lack of knowledge on my part to be able to answer all the questions asked of me while in transport, and as time progressed while presenting this idea to my parental figures and asked "do you really see the need for this type of system" and 100% assuredly answering "YES!" - I have found it to be an absolute necessity.|END|
- Edited by SuZQ20009 - Jennifer D Novak Tuesday, April 17, 2012 9:52 PM
------------------------------------
Exchange 2007 - Conflict folders during mailbox restore
During a recent recovery we started seeing conflict folders appear while using Restore-Mailbox PS command. For every folder that was restored, 4 identical folders appears with the same name and then "Conflict (########)" post fixed on the end. The #### is a variable hex number This effectively restored 5X the space.
I am not sure at what point the conflict folders were created. They were not in the users mailbox to begin with and I restored the folders to a recovery folder in their mailbox rather than merging with original folders. We use Legato to backup our databases. Is this the Restore-Mailbox creating the duplicate folders or is it likely they already exist in the recovery database from Legato?
Thank you!
Karl
Reply:
I haven't seen this happen with natibe WIndows backup/restore, it could well be the existing DB, but from what I remember it tells you that a DB already exists.
What I suggest you do, is create a new RSG and do the whole restore again and test.
Sukh
------------------------------------
restoring db's which were detached .
hi ,
we have 89 dbs which were detached yesterday due to some storage maintenance& we dont have mdfldf files(disk corrupted) to attach but we have saved our .bak files in another location.
can some one guide me to how to restore all my db's with .bakfiles in best possible way?
-
Reply:
-
------------------------------------
Reply:
------------------------------------
Bug report, Windows TCP stack incorrectly assigning dynamic port the same as destination port
For more details including sample code to duplicate the problem, see embarcadero forums
Problem is that (for example) connection attempt to 127.0.0.1:50000 when the connection is assigned 50000 for the dynamic source port Windows will connect the client socket to itself and happily echo data back to it. Simplest duplication was:
#include <vcl.h> #include <windows.h> #pragma hdrstop #include <tchar.h> #include <winsock2.h> WINAPI _tWinMain(HINSTANCE hInstance, HINSTANCE hPrevInstance, LPTSTR lpCmdLine, int nCmdShow) { WSAData wsa = {0}; WSAStartup(MAKELONG(2, 0), &wsa); SOCKET s = ::socket(AF_INET, SOCK_STREAM, IPPROTO_TCP); if (s != INVALID_SOCKET) { sockaddr_in addr = {0}; addr.sin_family = AF_INET; addr.sin_addr.s_addr = inet_addr("127.0.0.1"); addr.sin_port = htons(51492); if (bind(s, (sockaddr*)&addr, sizeof(addr)) == 0) { if (connect(s, (sockaddr*)&addr, sizeof(addr)) == 0) { char buffer[6] = {0}; if (send(s, "Hello", 5, 0) > 0) { int i = recv(s, buffer, 5, 0); buffer[i] = 0; } shutdown(s, SD_BOTH); } } closesocket(s); } WSACleanup(); return 0; } - Changed type braindead0 Tuesday, April 17, 2012 5:39 PM it's a confirmed bug, not questions
Sharing a fixed size VHD between multiple VMs
yaro
Reply:
If you use only one of the two VMs at a time, then yes, you may use the same VHD file for both VMs.
Actually, if you try to power ON the second VM (when the first VM has the VHD file mapped), the second VM will not power ON and will throw an error.
------------------------------------
Reply:
This used to be salled the 'shared scsi bus' in virtual server.
It is no longer possible, mainly becuase most operating systems have moved away from support due to the advancement of SAN - you rarely see it as a hardware option any longer.
One way to handle this is using iSCSI to present the contenct of the volume to the VMs. (this is what you would need to do to cluster).
Another way of handling this is to use a differencing disk between the VHD and the VMs. This allows READ of the root VHD but not write. That is the hitch.
If you have Windows in the VM, the only way this is even possible is with Clustering enabled - and then only supported if using CSV. With 2008 R2 that only applies to the Hyper-V Role in the VM. In Win8 it extends to the File Server Role.
Brian Ehlert
http://ITProctology.blogspot.com
Learn. Apply. Repeat.
Disclaimer: Attempting change is of your own free will.
------------------------------------
Reply:
yaro
------------------------------------
General Complaints
I have always been a defender of Microsoft; producer of great products at great prices. Today, I'm on the attack. User friendliness has been lost. Things were in obvious spots in 3.1/95/98/ME/XP. Vista is the most unorganized OS I've used (at least to the average user). I've had an easier time with various unix flavors.
Even this forum is shotty.
Hypothetically, imagine I'm a disgruntled Microsoft user that wants to post a complaint. I go the forums home page for the first time ever and I'm looking for the post new button... No post new button... I check help... It says click the new thread button... No new thread button... Finally, I have to read more in depth to figure out that I need to click on a forum first. Five-Ten minutes lost!
Solution? A post new thread that allows you to either choose your thread or add new.
Now back to my original complaint. I'm trying to share a Vista folder/printer with XP. It's not working. The obvious route failed me. The help failed me. The initial search on the internet failed me. I will figure this stuff out before 99%+ of your customers. I double majored in Computer Science and Mathematics at a Big 10 School. I don't normally divulge such information because it is tacky. I want you all at Microsoft to understand how badly you failed with this Vista. I'm not looking for help on this issue because I will have it figured out by then.
I would have left this issue alone if it were the only one. But I have had numerous compatibility issues.
Apple/*unix are starting to look more attractive. Your many other products are the only things that are currently saving you. Now do better! And tell Mr. Ballmer he made the right decision on walking away from Yahoo!
Sincerely,
Mike
Reply:
Mike
I don't think these forums work any different from most other online forums?
Did you take the time to look at the answered messages database. Look at the lower/left of any forums main page. In the Forum Options box. In the View by Attribute drop down menu, select Answered Questions and press Apply. I think you will find a lot of happy users there.
As far as your complaints are concerned, Microsoft does make feedback resources available. Generally, it's tacky to post complaints to forums that are focused on supporting users with problems. Off topic posts simply clog the forums and make it more difficult for people to find help.
Try here:
Send Feedback about Windows Vista:
https://feedback.windowsvista.microsoft.com/default.aspx?productkey=winvista
Windows Quality Online Services: Windows Logo'd Products List:
http://winqual.microsoft.com/hcl/
Microsoft North American Retail Product Refund Guidelines:
http://www.microsoft.com/mscorp/productrefund/refund.mspx
Thanks for understanding.
If this post helps to resolve your issue, click the Mark as Answer button at the top right of this message.
This will help others who are having this issue find the answer quicker.
Ronnie Vernon
Microsoft MVP
Windows Desktop Experience
------------------------------------
Reply:
I agree with you in that these forums are a wealth of info and extremely helpful resources and if you turn that into a customer service outlet then, needless to say there will be a lot of animosity and technical support is sure to suffer.
------------------------------------
Reply:
Ah Yes Vista,
Right now I am stuck on my Wife's (Vista) laptop. She is on a website that only works with my laptop which has XP..sigh. Also another wonderful distraction is when we are on chat sessions and her microphone is always messed up because the settings keep changing. The audio section of Vista is a nightmare, the high pitched squeals I have endured are nothing less that painful. Hopfully one of these years Microsoft will either fix these problems or dump Vista as a lost cause. Its a constant source of annoyance and to have your wife constantly annoyed is not the best position to be in ones short life...
------------------------------------
Reply:
I would like to complain about how tech support screwed up my computer so bad and when they could not fix the issues they just cut me off. I am sitting here looking at my computer, mad as hades. Thanks so much for really messing it all up. I have windows 7 and now have a computer that is useless. Thanks for the 10 hours of phone calls, at my expense ( I am calling from the uk. Hubby is military and we have moved), only to stop all communications. Thanks for lying about how I would receive a phone call back. That is really classy. Thanks for leaving me with a computer I can't backup, do a restore or even reload my windows 7 to look for the corrupted files that you said I have. I don't know how to fix these problems. My case # 1131869467 does me no good. I have no one to call to help. I can't find any phone numbers for the corporation. I hope an act of God really gives you the staff. Thanks Mr Gates. Your own people are as stupid as I am when it comes to fixing windows 7 software issues. I am so angry, frustrated and overwhelmed that my blood pressure is high enough to have a freaking stroke. I have not been dumped like this since 8th grade when the guy I was dating did not like the fact I would not sleep with him. Thanks a lot. Oh, and your customer service SUCKS!!
Oh, please, please, look up the case, check the notes and see what your people do for a hobby!
Waiting for the act of God...
KLReents
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
Hi Ronnie (in hope you are still at MS or someone else will look at this),
I am now contacting you as almost my last resort because I feel completely out of options to get this issue resolved... It all relates to an issue in the forums that was closed without any user confirming it was resolved and no matter how much we all seem to ask no-one from Microsoft seems willing to re-open it: http://social.technet.microsoft.com/Forums/en/outlook/thread/05d014d2-50bc-447b-9fdd-2f197f0f649b
So here's my horror story of trying to use Microsoft Support when the forums didn't seem to have any answers...
So back on 16 Dec last year I send Microsoft online support a message saying that Outlook 2010 had an error where it saved exchange account drafts to the exchange account drafts folder rather than the local PST folder (which is set as my default folder for that account, and all my email accounts for that matter).
So some online support person contacts me back and I send them all the information they request (O/S, versions, config, relevant screen captures of the Outlook settings etc).
But they never respond to me so I follow-up
Then another support person contacts me and asks for all the same information which I again send to them.
We go back and forth often covering the same questions and me providing the same information over and over again. They are adamant that it is a problem on my end.
I reiterate continually that my settings are correct, and that it is far more likely an error with Outlook 2010 that needs resolving.
So about several emails back and forth later and now almost a month later they finally admit that their "fixes" aren't working and I need to use phone support (specialist engineers I think they called them) using a reference number they provided (I assumed to save me having to explain my problem again).
So I then call phone support and give them all my details again including the reference number but they ask all the same questions again.
They decide to then transfer me to a professional engineer.
Who then asks for all my details all over again and for to explain the problem yet again.
Eventually they say because I am using a standalone computer they can't suport me.
So they transfer me to the home support.
So I bet you have guessed by now that they then ask for all my details again and to explain the problem (to now the fifth Microsoft employee).
So after hearing everything they eventually say I need to speak to professional support (the same guys who transferred me to them).
At which point I said let me speak to a manager because I am sick of going around in circles.
They won't transfer me but they put me on hold so they can speak to their manager about it.
They then come back on to the call and tell me their manager says I need to speak to their professional support department.
Click... I have had enough. How can I get this issue resolved without going around and around in circles?
------------------------------------
Reply:
Hi fishersm
I don't work for Microsoft, I volunteer to help on these forums.
The only problem that I can see with what you are doing is that you are posting to very old threads. The Microsoft support people who participated in those threads may have moved on and no longer post on those forums.
The support people are not being alerted to your current posts because they have probably removed any alerts for those old threads that have already been marked as being answered.
Go back to this page:
http://social.technet.microsoft.com/Forums/en/outlook/thread/05d014d2-50bc-447b-9fdd-2f197f0f649b
At the top of that page, click the Ask A Question link. Give the new thread a short, intuitive title. Post the complete details in the body of the new question. This will get you the best response.
After you click the Submit button to post the question, bookmark that page so that you can find it again. Any Alerts for replies to that new thread should be sent directly to the email address for the Live ID that you used to create your forum profile.
All of the Microsoft employees that post on these forums work from the professional support department at Microsoft.
Make sure you monitor the new thread closely and respond to any replies in a timely manner.
Regards,
Ronnie Vernon MVP – Windows Desktop Experience
------------------------------------
Reply:
kevin
------------------------------------
PDC Emulator role download
Hi
This is regarding the doubt in fsmo roles issue.4 roles are availab in server one and pdc role is moved server two
temporarily my pdc server has been down for 6 hrs i have 5 sites all are 2003 domain controllers.
will users are able to change password.please let me know
Reply:
Hello,
as long as one DC is available users are able to change the password. This will be replicated later on to the other DCs if they are back.
Best regards
Meinolf Weber
MVP, MCP, MCTS
Microsoft MVP - Directory Services
My Blog: http://msmvps.com/blogs/mweber/
Disclaimer: This posting is provided AS IS with no warranties or guarantees and confers no rights.
------------------------------------
Reply:
PDC Emulator is one of the imporatant ROle in AD.
If it is down , then Time synchorization between workstations and DC will not happen. Also GPO will not be processed properly.
If user want to change the password , Information will not be propagated to other DC's.
Refer below link which will expalins this more clearly.
Regards,
_Prashant_
MCSA|MCITP SA|Microsoft Exchange 2003 Blog - http://prashant1987.wordpress.com Disclaimer: This posting is provided AS-IS with no warranties/guarantees and confers no rights. Email-giteepag@yahoo.co.in
------------------------------------
Reply:
Yes, users will be able to change the password but old password might also work. The job of the DC holding PDCEmulator is authorization like password reset/change/account lockout etc and if PDC is down there will be no DC to authorize the change and hence old password will also work and it will take time to replicate to other DC's.
Question
Is the PDC Emulator required for user authentication? How long can a domain operate without a server that is running the PDC Emulator role?
http://blogs.technet.com/b/askds/archive/2011/02/25/friday-mail-sack-xxxxxxxxxxxx.aspx#pdceauth
Awinish Vishwakarma - MVP - Directory Services
My Blog: awinish.wordpress.com Disclaimer This posting is provided AS-IS with no warranties/guarantees and confers no rights.------------------------------------
view Excel in Sharepoint
Hi,
I've XLS file in my document library and i want to show it in web part. Also i want to be able to change that xls file.
thank you..
Reply:
You can view the excel file in a ExcelWebApp Web Part, given that you have uploaded the excel file in a trusted location. (Trusted location for Excel Services)
to make changes to the excel file you can define parameters in the excel file which you can modify in the ExcelWebApp but you cannot modify the excel file as you do in Microsoft Office Excel client application.
Regards, Huzefa Mala, MCTS
Please mark the post that answered your question as the answer, and mark other helpful posts as helpful, so they will appear differently to other users who are visiting your thread for the same problem.
------------------------------------
Lync interactive response group
Hi guys,
Is it possible to do the following with an interactive Lync Response Group:
After a call has been answered by the Response Group and no agents answer the call, can we configure the response group that after 30secs there should play another message like "All the current agents are busy, please hold"
If not is a contact center for lync the best option here?
Regards
Reply:
how about have your music be 30 secs and at the end say "all agents busy, please hold..."
+Say thanks and observe basic forum courtesy:
+If this post answered your question, Mark As Answer
+If this post was helpful, Vote as Helpful
windowspbx blog: my thots/howtos
see/submit Lync suggestions here: simple and public
------------------------------------
Reply:
Hi Matt,
Ill give that a try.
Thanks
------------------------------------
How to remove deployed software updates for my users
Hi,
I have deployed an update for Windows 7 users. But unfortunately it will causes some of our in house applications to hang. How can I
1. Remove the updates that appear in the users System Tray
2. To stop the updates that is reaching out to the users' pc.
In SCCM 2007, there is this Deployment Management and I have tried to remove the updates but still not working.
Thanks
Reply:
Hi,
the following actions are suggested,
modify/delete your deployment (deployment management)
delete the update from deployment packages (will cause content location to fail)
wait for (or force) machine policy cycle on clients
wait for (or force) update scan on clients
create a software distribution package/program to uninstall the update on affected clients
Don
------------------------------------
roaming profile issue in the domain
Hi Friends,
We have an issue in our domain. The issue is symantec is in disabled mode in some of the users profile eventhough it is in up to date.
If another user (Those who can work without issue) log in that machine it is working.
Due to that SAV issue user profile is not communicating to server (AD), it is loading like temp profile.
It could be really appreciate if any one share their Idea or conclusion.
Thanks in advance
Reply:
Hi,
What happens if you reset the users profile, does this resolve the issue?
Do you want Symantec to be in Disabled Mode in these users profiles?
------------------------------------
Reply:
Hi Mathew,
If i reset the user profile it is working fine but it happens frequently. Is there any other solution to solve this issue without reset the profile? Why it happens for particular users in domain?
No it goes disable mode in users profile without any changes (By default).
------------------------------------
Strange Permissions Issue with My Documents Redirect
SBS2003 Server
Windows 7 32bit and Windows XP clients
OK, I can't figure this one out. I have 1 user who when they log into the computer their MyDocuments are not redirected to the server as per the AD policy. Upon further looking I tried to manually navigate to that users folder but when they hit the "Users shared folders" share they get an access denied so there is no way they will make it to their personal folder below. When I take this same user and log in as him on another client (I tried Windows 7 and XP clients) it all works fine for this user.
That tells me it's not a permissions issue on the server or his account. It's something to do with THIS particular Windows 7 client for THIS user. The question is how to rectify
- Changed type Sean Zhu - Wednesday, April 25, 2012 1:41 AM no response
Reply:
------------------------------------
Reply:
I believe Users shared folders are by default denied access to everyone, only users specific folders are you able to access.
1) Just to make sure that I'm not making things up here... go on the computer that works fine and try to access the Users shared folders share. I'm betting you'll get an access denied.
2) Get the full path of the users redirected my documents folder and type that in the address bar of the machine that doesnt work. Again I'm betting that it will work.
3) Run a gpupdate /force from the command line of the machine that doesnt work (making sure to run it elevated) and see if it throws back an error.
4) post back all results here.
Hopefully we'll be able to help you out.
-GT
------------------------------------
Reply:
------------------------------------
Reply:
1. I can get straight to the users main share from the good computer but access denied from the bad computer. From there on the good computer I can get to the user's specific folder. On the bad computer I don't even get that chance since I can't even get to the main users share without access denied
2. Tried that well. Still access denied.
3. Tried that as well as tried unjoining/rejoining this workstation. Still no go. I know the GP is working because when I look in the logs on this bad computer I see the error trying to do the redirect because of the access denied. This is a permissions issue which for some reason is wacked out on this computer. The only other thing I can think of, since this is a Windows 7 machine, is delete the local profile (In Win XP it was as simple as deleting the c:\documents and settings\{username} folder) but I need to check the exact steps for a Windows 7 client. It's been tricky in the past.
------------------------------------
Reply:
------------------------------------
Unable to remote query Exchange server 2010 using power shell
I wish to query exchange server 2010 using power shell. My exchange server 2010 is mount at Windows server 2008 R2. I have got the result with the following query get-mailbox XXX. But as I want to query it from a remote PC, I have tried it as follows ...
$server='WIN-XXX';$pwd= convertto-securestring 'abc123' -asplaintext -force;$cred=new-object -typename System.Management.Automation.
But it gives an error
Can anybody help me to solve this?
Regards
Sebstian
Reply:
Dale A. Howard [MVP]
VP of Educational Services
msProjectExperts
http://www.msprojectexperts.com
http://www.projectserverexperts.com
"We write the books on Project Server"
------------------------------------
tmg certificate for Lync
Reply:
regards Holger Technical Specialist UC
------------------------------------
Reply:
------------------------------------
Reply:
If you are allowed to check the 'export private key with certificate' checkbox in the export wizard then the certificate was originally issued with the ability to alow export.
When you look at the certificate in the Certificates snap-in on the TMG server does the little padlock and 'a private key is associated with this certificate' message appear at the bottom of the main properites window on the certificate?
Jeff Schertz | Microsoft Solutions Architect - Polycom | Lync MVP
------------------------------------
Reply:
while exporting the certificate i am not able to see anything which allow me to export it with private key,
actually i have prepared the certificate request from lync certificate request tool and in their i have checked marked that allow export private key, i think my internal CA is not making a certificate with a private key.
------------------------------------
Reply:
Jeff Schertz | Microsoft Solutions Architect - Polycom | Lync MVP
------------------------------------
Stability problem for Excel commander report using RDBMS and OLAP
Hi All. I have not much experience in Business intelligence area. I am facing a problem in regarding stability of a report. We are providing the Business users an Excel report in Retail Sales Reporting with Dynamic filtering options, with multiple sheets/tabs in for different geographical, product and time hierarchies. The report is using two Stored Procedures which are going to the Relational database and OLAP database to collect the data. The report is being started by Sql Agent scheduled job, which starts an Excel commander and then Excel commander starts the stored procedures to collect data and then populate the data in a predefined Excel file layout with multiple sheets/tabs. Of course the Excel file is using the macros (vba). The problem of this solution is the stability or the reliability of the report execution. Many times the report crashes without giving any error message or sometimes it takes too much time to execute so we have to restart it. Any idea about how we can get a better degree of reliability / stability. We are even thinking to replace this report generating method for the sack of stability but Excel is must part for its ability of offering of dynamic filtering and multiple tabs/sheets. I would be very thankful for your Ideas for the improvement of the situation, especially my humble request to Experienced and Seniors.
srpatel0
Reply:
srpatel0,
I'd suggest you consider using SSIS to retrieve the data and populate the Excel sheet for the users. SSIS is designed for this kind of reliable, server-based operation and will be quite stable, and even if there are issues has very good logging to help you diagnose any problems you encounter.
I don't know what the vba is...but if you do need to transform data somehow as it's loaded into the workbook, SISS includes components that handle most needs.
You can use a the Excel destination that's built into SSIS to fill the data you extract into the excel workbook.
HTH,
Rob
Rob Kerr SQL Server MVP CTO, BlueGranite
------------------------------------
Reply:
Hi Rob Kerr,
Many thanks for your information. I got the idea to do this job with ssis.
choosing Excel as destination but i have a bit rich in format report layout. What VBA is doing: is damping the data first to excel sheets in a simple way and then runs the Macros to dup this data to the desired sheets on desired cells/ data ranges and then delete the excess sheets/Raw data sheets after the job complition.
You mention that ssis includes components that can do something with excel layout/ moving data in between sheets and cells.
colud you please give me some more details?
srpatel0
------------------------------------
Unable to extract ISO?
Hi i am getting error extracting the ISO image file?
any ideas?
Thanks!
Reply:
Vincent Hu
TechNet Community Support
------------------------------------
Reply:
The ISO is the downloaded one of Windows Server 8 Beta
8250-1.0.WINMAIN_WIN8BETA.120217-1520_X64FRE_SERVER_EN-US-HB1_SSS_X64FRE_EN-US_DV5.ISO
I am trying to extract with WinRar, When i try extract it, i get errors:
! C:\Users\Dean\Desktop\8250-1.0.WINMAIN_WIN8BETA.120217-1520_X64FRE_SERVER_EN-US-HB1_SSS_X64FRE_EN-US_DV5.ISO: Cannot create sources\sxs\amd64_netfx-system.runtim..ion.formatters.soap_b03f5f7f11d50a3a_6.2.8250.0_none_3d559d26f119e5a2\system.runtime.serialization.formatters.soap.dll
! C:\Users\Dean\Desktop\8250-1.0.WINMAIN_WIN8BETA.120217-1520_X64FRE_SERVER_EN-US-HB1_SSS_X64FRE_EN-US_DV5.ISO: Cannot create sources\sxs\amd64_netfx35linq-system...s.accountmanagement_31bf3856ad364e35_6.2.8250.0_none_632596f8edf230bc\system.directoryservices.accountmanagement.dll
! C:\Users\Dean\Desktop\8250-1.0.WINMAIN_WIN8BETA.120217-1520_X64FRE_SERVER_EN-US-HB1_SSS_X64FRE_EN-US_DV5.ISO: Cannot create sources\sxs\amd64_netfx4-_dataoraclec.._shared12_neutral_h_b03f5f7f11d50a3a_4.0.8250.0_none_9535f1038b8365ff\_dataoracleclientperfcounters_shared12_neutral.h
! C:\Users\Dean\Desktop\8250-1.0.WINMAIN_WIN8BETA.120217-1520_X64FRE_SERVER_EN-US-HB1_SSS_X64FRE_EN-US_DV5.ISO: Cannot create sources\sxs\amd64_netfx4-_dataoraclec..hared12_neutral_ini_b03f5f7f11d50a3a_4.0.8250.0_none_94746290e9d3bf35\_dataoracleclientperfcounters_shared12_neutral.ini
! C:\Users\Dean\Desktop\8250-1.0.WINMAIN_WIN8BETA.120217-1520_X64FRE_SERVER_EN-US-HB1_SSS_X64FRE_EN-US_DV5.ISO: Cannot create sources\sxs\amd64_netfx4-_dataoraclec..hared12_neutral_ini_b03f5f7f11d50a3a_4.0.8250.0_none_94746290e9d3bf35\_dataoracleclientperfcounters_shared12_neutral_d.ini
! C:\Users\Dean\Desktop\8250-1.0.WINMAIN_WIN8BETA.120217-1520_X64FRE_SERVER_EN-US-HB1_SSS_X64FRE_EN-US_DV5.ISO: Cannot create sources\sxs\msil_system.runtime.seri..ion.formatters.soap_b03f5f7f11d50a3a_6.2.8250.0_none_b01e1d03bc0f0e97\system.runtime.serialization.formatters.soap.dll
Thanks!
- Edited by deanfourie Tuesday, April 17, 2012 5:06 AM
------------------------------------
Reply:
Vincent Hu
TechNet Community Support
------------------------------------
Reply:
Thanks, i unzipped with 7 Zip and it worked,
however, now im getting errors burning it to CD.
Im using ImgBurn to burn it and using the boot image from a Server 2008 DVD.
Any Ideas. Im getting errors in the Vericatioon process of the burn, also when trying it it just hangs on "Loading Setup"
Thanks!
Also, im using a DVD-RW
- Edited by deanfourie Tuesday, April 17, 2012 8:17 AM
------------------------------------
Reply:
>> What did you want to do? If you want to burn a Windows Server "8" DVD disk, you can just burn the ISO file you download with ImgBurn or some other tool, you don't need to extract the ISO file.
http://neosmart.net/wiki/display/G/Burning+ISO+Images+with+ImgBurn
Vincent Hu
TechNet Community Support
------------------------------------
Reply:
This is exactly what i did, and still the errors during verification
I also tried adding the FOLDER and then adding the boot image off another CD, same problem.
I will try another DVD
Thanks!
------------------------------------
Reply:
http://blogs.technet.com/aviraj/archive/2009/02/01/installing-windows-7-using-usb-thumb-drive.aspx
Vincent Hu
TechNet Community Support
------------------------------------
Reply:
Thats exactly what im trying now
Ill keep you posted
Thanks!
------------------------------------
Reply:
I Just installed it :)
Is it command line only? Cause i only have CMD on startup and NO GUI!
Thanks!
Installed Full Server Core Installation!
- Edited by deanfourie Tuesday, April 17, 2012 9:50 AM
------------------------------------
Reply:
On Tue, 17 Apr 2012 08:14:27 +0000, deanfourie wrote:
Thanks, i unzipped with 7 Zip and it worked,
however, now im getting errors burning it to CD.
Im using ImgBurn to burn it and using the boot image from a Server 2008 DVD.
Any Ideas. Im getting errors in the Vericatioon process of the burn, also when trying it it just hangs on "Loading Setup"
Thanks!
Also, im using a DVD-RW
Why are you extracting files from the ISO, if you want to burn a DVD and
install from the ISO? Simply use IMGburn to burn the ISO itself to a DVD
and you will wind up with a bootable DVD from which you can boot and
perform the install.
Paul Adare
MVP - Forefront Identity Manager
http://www.identit.ca
Variables won't; constants aren't. -- Osborn
------------------------------------
Reply:
On Tue, 17 Apr 2012 09:50:05 +0000, deanfourie wrote:
I Just installed it :)
Is it command line only? Cause i only have CMD on startup and NO GUI!
Thanks!
Installed Full Server Core Installation!
Server Core is, by definition, a no GUI install. While there are Powershell
cmdlets you can use to add the GUI back, given the rest of the this thread,
for you, I'd suggest that you reinstall from scratch and this time choose
the install option that says Server with a GUI.
Paul Adare
MVP - Forefront Identity Manager
http://www.identit.ca
Remember the good old days, when CPU was singular?
------------------------------------
Windows 8 won't let me install the File/Open plug-in.
- Changed type Bruce-Liu Wednesday, April 25, 2012 2:39 AM
Reply:
On Tue, 17 Apr 2012 06:40:10 +0000, Mickymack wrote:
Can anyone tell me how I can install the File/Open plug-in so I can print out sewing patterns I have purchased over the net.? It's a plug-in for Adobe PDF and i've used it on Windows 7 without any problems.
This forum is for Windows Server 8 issues, not Windows 8 client issues.
Since you seem to be having an application compatibility issue, you should
repost your question here:
http://social.technet.microsoft.com/Forums/en-US/w8itproappcompat/threads
Paul Adare
MVP - Forefront Identity Manager
http://www.identit.ca
Netnews is like yelling, "Anyone want to buy a used car?" in a crowded
theater.
------------------------------------
General Query about Large Databases
Good morning,
I'm just looking to have a bit of a chat about backups on VLDB systems. For instance, at present, the largest database I work with is about 150GB. It has 1 filegroup, "PRIMARY" and one MDF file.
We back this up twice a day and reorganise indexes each night. Each backup takes around 90 minutes to backup, with the index and statistic reorganising taking an additional 45 minutes.
So, my question is this. In a much larger environment, lets say databases of about a Terrabyte in size, what would be the best ways to configure your database, and then to backup/restore? Let's assume that it's a 24/7 organisation just to keep it interesting.
I'm afraid I've got no real idea about where to even start here. Would this be looking at doing filegroup backups, or splitting out more MDF files etc? Or would you just start the backup at 5pm on a Sunday night, let it complete, and then run differential/transaction log backups throughout the week? Or even a full backup once a month, and then differentials/transaction logs? (I'm going to assume that storage isnt a problem at the moment)
I'd love to hear what everyone thinks on this, and also experience they have with this in the real world.
Cheers
Andy
Reply:
Andy,
It really depends on what your RPO/RTO is for that specific database. For example you may have a very large ~2TB database that isn't high on the priority list at your company. It also depends on your long term storage or backup solution. Do you have dedicated tape, direct to disk, disk pool to tape, etc.
There are general best practices such as you have pointed on (primary filegroup only system objects, etc), but it really depends on the structure of the database. Personally I work with mostly 3rd party solutions and have no control over the structure of their database or programming. There are a few things I can do, such as contain certain functional parts together, migrate files and filegroups, etc, but there are times when certain best practice solutions just won't work.
When it comes to WHAT should be done, it's best to look at what your objective is and then use a combination of solutions. If the objective is 100% of all data inside of 60 minutes and your backup took 90 minutes, that's not going to meet your SLA. Also take into account the longer time for the restore operation as it goes through crash recovery. In this case, what could be done to speed up the restore? Striped backups could potentially up throughput if disk isn't the bottleneck, if saving to a network share (yikes) maybe look into dedicating a nic to just backup traffic, etc. It's just like tuning a query or a database, do a top down look and see what the bottlenecks are, find solutions, test test test test, change control, check improvement (or lack there of sometimes!).
-Sean
------------------------------------
Quick Look for windows 8.
- Moved by Bob Wu-MT Wednesday, April 18, 2012 6:01 AM (From:Windows Forms General)
Reply:
Thank you for your suggestion. However, this forum is Windows Forms General forum which discuss client application development using Windows Forms controls and features.
If you have any question or suggestion about Windows 8, please create a new thread in the Microsoft answers forum.
Have a nice day,
Bob Wu [MSFT]
MSDN Community Support | Feedback to us
------------------------------------
Unable to open Authoring Console
I have configured few Reference Paths to automatically pick dependency MPs. After this configuration, when I closed the Authoring console and opened, It was unable to open it. It was throwing the following error "This is not the correct MP Either the id, Iy toIn, or version are incorrect." Order inwhich Reference Paths I have added could have caused this issue.
I have made the following change and then it started working normally:
Open Regedit in run
Go to Key: "HKEY_CURRENT_USER\Software\Microsoft\Microsoft Operations Manager\3.0\Authoring\Settings"
and select the Value: "References" and Remove the data.
Hope it helps someone!
- Changed type Asif Iqbal K Tuesday, April 17, 2012 8:59 AM It has the problem as well as the solution
- Edited by Asif Iqbal K Tuesday, April 17, 2012 9:04 AM
- Changed type Alexey Zhuravlev - G14 Tuesday, April 17, 2012 9:13 AM
No comments:
Post a Comment