Viewing 15 posts - 16 through 30 (of 91 total)
K. Brian Kelley (5/14/2009)
The correct permissions and what options you may have there are documented in Books Online:
This isn't strictly complete. The BOL article is...
--
Andrew Hatfield
May 15, 2009 at 10:05 pm
Reply from http://www.sqlservercentral.com/Forums/Topic717598-357-1.aspx
MDF are the primary data file in a File Group. These files contain "data" - so your tables, indexes, keys, constraints, UDF, UDT, stored procs, functions, etc...
LDF files...
--
Andrew Hatfield
May 15, 2009 at 12:02 am
MDF are the primary data file in a File Group. These files contain "data" - so your tables, indexes, keys, constraints, UDF, UDT, stored procs, functions, etc...
LDF files are...
--
Andrew Hatfield
May 15, 2009 at 12:00 am
You should always use static ports instead of dynamically assigning them. Where possible, disable the Browser service.
If you were to run the 3 instances on the same port and...
--
Andrew Hatfield
May 14, 2009 at 11:58 pm
Firstly, what do you mean by corrupt?
Do you have a backup you can restore? Would that be a full database restore or just transaction logs?
If it's a damaged page,...
--
Andrew Hatfield
May 14, 2009 at 11:49 pm
If you are not currently experiencing performance pressure you will probably not see much if any benefit. In saying that, while your existing setup may be meeting your performance...
--
Andrew Hatfield
May 14, 2009 at 6:55 pm
jparra (5/14/2009)
Andrew Hatfield (5/13/2009)
--
Andrew Hatfield
May 14, 2009 at 3:44 pm
jparra (5/14/2009)
Barkingdog (5/13/2009)
Good point:Of course while it may not match production data RedGat'es data generator (and others) is a good start in my opinion.
Barkingdog
But that's the whole point, isn't it?...
--
Andrew Hatfield
May 14, 2009 at 3:09 pm
Steve Jones - Editor (5/13/2009)
Andrew is pretty on here with what I think.
You're a top bloke
Steve Jones - Editor (5/13/2009)
--
Andrew Hatfield
May 13, 2009 at 11:49 pm
You don't want to go mixing editions on the same windows installation; indeed I would expect the SQL setup to fail if you tried to do this.
Simply run your SQL...
--
Andrew Hatfield
May 13, 2009 at 7:41 pm
It is concerning that your developers believe they not only require production data, but that they are unable to do their job without it. I'd be looking for new...
--
Andrew Hatfield
May 13, 2009 at 5:58 pm
What is in the setup bootstrap logs? (usually something like C:\Program Files\Microsoft SQL Server\Setup\Bootstrap\ and then a supportXX.cab...
--
Andrew Hatfield
May 13, 2009 at 4:10 pm
Steve Jones - Editor (5/13/2009)
:), whoops.not implying developers are not people, but you need a person that is not a developer.
Actually, I think most people would be fine with that...
--
Andrew Hatfield
May 13, 2009 at 2:41 pm
While a business manager should have a say in what are acceptable outage windows and when they occur, they certainly should never dictate what happens and in which order.
That is...
--
Andrew Hatfield
May 13, 2009 at 2:09 pm
I haven't used BackupExec in a while, but effectively you need to restore those files and any registry settings.
When you restored your server, did you do a full bare metal...
--
Andrew Hatfield
May 13, 2009 at 5:12 am
Viewing 15 posts - 16 through 30 (of 91 total)