Viewing 15 posts - 16,831 through 16,845 (of 39,970 total)
If you have new hardware, you will install the new software on it, then move logins
Login migration: http://www.sqlservercentral.com/articles/934/
Move over databases from either a backup/restore or detach/attach, then script out alerts/operators/jobs...
March 3, 2011 at 9:23 am
Yes, it's a bug in the system when two people are posting at similar times. Low priority, but it's on our list.
March 3, 2011 at 9:21 am
You haven't asked a question. You made three statements.
You can install SQL Server on one, and the client tools on the other machine and have them work. You will have...
February 27, 2011 at 10:32 am
That typically means you specified the instance name as "inactive" when you installed it. It's a name, but shouldn't affect the SQL Server.
It is off topic for here. If you...
February 27, 2011 at 10:25 am
Did you add a filegroup for your database that includes filestream data? If you look at the database creation script in the article, you will see (emphasis mine):
USE MASTER
GO
...
February 27, 2011 at 10:23 am
LOL, glad it worked. Note, that you shouldn't be shrinking the log regularly. If you need that space for index rebuilds, leave the log where it maxes and let is...
February 26, 2011 at 9:48 am
replication enabled? If not, I might suspect that you have a large VLF that's active. The log is divided up, and depending on how it was sized and grown, you...
February 26, 2011 at 8:55 am
Filestream has to be enabled in SQL SErver (sp_configure) and also in Configuration Manager, as a note to the OS that this is allowed. So two settings to change.
Then check...
February 26, 2011 at 8:53 am
Are you migrating to new hardware or upgrading in line?
No matter what, be sure you have good backups of all databases ( including master/msdb) on another machine before you start.
February 25, 2011 at 6:39 pm
Not sure what I can say about the exam, so I'll hold off. Look for a blog next week once I clear a few things up with NDA
February 25, 2011 at 6:36 pm
Took the MCM test today. It was....interesting. I'll write more about it once I know what I can and can't say.
February 25, 2011 at 5:43 pm
Stefan Krzywicki (2/25/2011)
But with TV and print media, we're so accustomed to ignore that advertising that we automatically divert our attention during commercials and readily ignore print ads. I honestly...
February 25, 2011 at 8:51 am
Stefan Krzywicki (2/24/2011)
Sure, but my point is that banner ads on a website are no worse than tv ads or magazine ads, why should they draw less revenue? And I'd...
February 24, 2011 at 4:35 pm
GSquared (2/24/2011)
Evolution generally favors either suicidal levels of cooperation (worker ants and warrior ants giving their lives for their hill), or rabid levels of competitiveness (male lions), and humans tend...
February 24, 2011 at 4:32 pm
Viewing 15 posts - 16,831 through 16,845 (of 39,970 total)