Viewing 15 posts - 1,171 through 1,185 (of 4,745 total)
arrnvid (1/31/2012)
Tried bring the database on the secondary to online status [Restore <dbname> with recovery] (no joy - was getting error db is in use)
Hmmm, I wonder if that was...
January 31, 2012 at 6:11 am
no probs.
I think I should clarify what I mean by quiesced - make sure nothing or no-one else is trying to connect to the instance whilst you are patching...
January 31, 2012 at 6:03 am
You should be able to install to all 5 instances at once.
when I have had patching errors where the resource database has 'gone missing' it has been file in...
January 31, 2012 at 5:53 am
sounds to me like your restore job is running but actually has no logs to restore. Check the history for the restore job and confirm by checking the errorlog for...
January 31, 2012 at 5:39 am
shah.simmy (1/30/2012)
i tried to connect localhost\sqlserver,it gives me same error
not sqlserver, sqlexpress
and use local or the actual server name
January 30, 2012 at 8:36 am
Gazareth (1/30/2012)
Just checking :-D, but has SQL Server Express been installed at all? You only mention installing Management Studio Express.
good point, what has been installed?
January 30, 2012 at 8:35 am
the express version installs a named instance by default, so you should connect to servername\sqlexpress
If you are ever not sure of the names of the instances installed on a box...
January 30, 2012 at 7:58 am
is this an all time 30 days record?
Show more
Top Members (last 30 days)
# Name Score 30 days All-time
1. Diane Fortin 2006 2006 SSCrazy
2. the_macabros...
January 27, 2012 at 10:43 am
SQLKnowItAll (1/27/2012)
Ian Scarlett (1/27/2012)
From your requirements, there is one thing that would still bother me about using transactional replication...
Argument 8: There's no easy...
January 27, 2012 at 8:15 am
Jared,
Reading Pauls article what immediately jumps out to me is arguments 5 and 6 and perhaps 8 are pretty good reasons for not going with replication as a first choice...
January 27, 2012 at 7:53 am
I'd ensure you get a version designed for SQL2005 and up.
you don't say whether you want to reverse engineer the code or just get a list of permissions but to...
January 25, 2012 at 4:11 pm
agree with Gail, no way rebuilding indexes quarterly is frequent enough, especially as you are seeing a slow down over time.
Whilst you investigate your slowest queries and dig deeper into...
January 25, 2012 at 4:01 pm
is your database growing over time? Are the indexes and statistics being maintained? This would be the first thing to check.
January 25, 2012 at 2:11 pm
there are a number in the scripts section of this site - do a search under 'permissions'
January 25, 2012 at 1:51 pm
Richard,
in the modify and delete Proxies sections, it refers to TSQL code whih is not there (in my browser anyway)
January 25, 2012 at 7:54 am
Viewing 15 posts - 1,171 through 1,185 (of 4,745 total)