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)