[MS SQL Server] SQL Server also Domain Controller ? |
- SQL Server also Domain Controller ?
- Hardware Configuration using SSD
- How to know who deleted / when deleted data in a table in sql server 2008 r2 please
- External Drive Died - Help
- Linked Server with restricted access
| SQL Server also Domain Controller ? Posted: 09 Jul 2013 01:42 AM PDT Our secondary domain controller died, so we have no backup if the main one also dies. We have a reporting SQL server we could temporarily utilize as a backup domain controller.What are the downsides to implementing the SQL 2008 server (Windows server 2003) as a domain controller and reporting SQL server until we get the other server fixed ? |
| Hardware Configuration using SSD Posted: 09 Jul 2013 02:38 AM PDT We are in the process of ordering a new server and the hardware guys are asking about how we need to setup the arrays / drives. We are moving to Server 2012 and installing SQL 2008 R2. If we are using Solid State Drives do you get better performance having multiple arrays each with their own logical drive or is the performance about the same using one RAID10 array and split that into logical drives for the OS, data logs, etc? Everything I have found says to split it on physical drives, but most are referring to platter drives and not solid state. So if anyone can give some insight on the best setup using SSD that would be great.Thanks,Tracie |
| How to know who deleted / when deleted data in a table in sql server 2008 r2 please Posted: 09 Jul 2013 02:47 AM PDT Hello AllI am using SQL server 2008 R2, i have a table called dbo.JJ_CARSDATA_Header, some how this table data is getting deleted,is there anyway how to know , when was last deleted/last modified/ who did it by query wiseplease give me any adviseplease...Thank youDhani |
| Posted: 09 Jul 2013 01:43 AM PDT Hi - We have our product databases on a Raid 5 disk array mirrored to another Raid 5 disk array. However, we have (had) our "testing" database on an attached USB drive. It just died yesterday. Now I have have testing databases that I can't access and can't remove. How do I remove them? Thank you.Mike Meer |
| Linked Server with restricted access Posted: 08 Jul 2013 08:01 PM PDT Hi,I created one SQL login with read-only permission to select the particular "VIEW" only. My question is how can i use this login into linked server 2008R2.ORHow can i enable linked server with restricted access. I want to select one particular 'VIEW' from source database.Its very urgent. Please help me.Pradeep. |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 Administration To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment