Viewing 15 posts - 16 through 30 (of 90 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...
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...
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...
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...
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,...
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...
May 14, 2009 at 6:55 pm
jparra (5/14/2009)
Andrew Hatfield (5/13/2009)
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?...
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)
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...
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...
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...
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...
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...
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...
May 13, 2009 at 5:12 am
Viewing 15 posts - 16 through 30 (of 90 total)