Viewing 15 posts - 286 through 300 (of 1,654 total)
With DB mirrroring, when the primary database becomes unavailable the mirror takes over the primary role. Once the first server comes online again it will automatically take over the mirror...
[font="Verdana"]Markus Bohse[/font]
June 4, 2009 at 5:38 am
Remove the Built-In\Administrators from the sysadmin group, but make sure that you have at least one other login with sysadmin permissions before doing this.
See also http://www.mssqltips.com/tip.asp?tip=1017
[font="Verdana"]Markus Bohse[/font]
June 3, 2009 at 7:23 am
srajakrishna (6/3/2009)
I used to run my code for restoring using
Single Cpu System
1.5 GB RAM
Pentium4 2.4 gig
i want to know does parallel restore in possible and that to faster...
[font="Verdana"]Markus Bohse[/font]
June 3, 2009 at 7:15 am
I would think that these results depend a lot on what kind of a machine your testing (single cpu vs. lots of CPU's) and the IO subsystem. WHen you restore...
[font="Verdana"]Markus Bohse[/font]
June 3, 2009 at 6:40 am
sqluser (6/3/2009)
MarkusB,Is it possible to achieve this through sql statement? Like sys.databases some thing like ....
---
Is what possible?
[font="Verdana"]Markus Bohse[/font]
June 3, 2009 at 6:32 am
kruti (6/3/2009)
Question2: I am not able to attach linked server from ss2k5 to ss2k I am getting error:
I doubt if this is possible. I was having the same problem when...
[font="Verdana"]Markus Bohse[/font]
June 3, 2009 at 4:46 am
Each instance must have it's own port number. You cannot use port 1433 for both.
By default the default instance uses port 1433 and named instances use a dynamic portnumber,...
[font="Verdana"]Markus Bohse[/font]
June 3, 2009 at 3:58 am
srikanth.katta1 (6/3/2009)
Thanks markus, will sql server 2008 supourt Vista home basic sp2 ?
For 2008 the same applies as for 2005, you cannot install EE on a client OS. For more...
[font="Verdana"]Markus Bohse[/font]
June 3, 2009 at 3:49 am
You cannot install the Enterprise Edition on client OS like Vista.
Only on a server OS like Windows 2003 or 2008.
If it's just for a test or development work...
[font="Verdana"]Markus Bohse[/font]
June 3, 2009 at 2:56 am
sqlserverdba06 (6/3/2009)
Hi Team,I installed sqlserver2008 in my pc but i did n't found Resource db
if there any reason.
The resource database is a hidden database. You cannot see or access it...
[font="Verdana"]Markus Bohse[/font]
June 3, 2009 at 2:23 am
andy.woodward (6/2/2009)
I have a table called LCC_TPROBLEM which has a column called Psolvdat containing a datestamp in EPOCH format.
I'm trying to write a query to select the total number...
[font="Verdana"]Markus Bohse[/font]
June 3, 2009 at 1:40 am
Peso (6/3/2009)
No, we haven't looked at database mirroring. Thank you for the tip!There are 5-6 databases of 15-20 gb each.
The size is no problem.
Check out for more information http://sqlcat.com/tags/Mirroring/default.aspx
[font="Verdana"]Markus Bohse[/font]
June 3, 2009 at 1:28 am
Did you look at database mirroring ? Seems to be the answer to your problem, unless you have loads of datatabases. Mirroring won't allow you to mirror more than about...
[font="Verdana"]Markus Bohse[/font]
June 3, 2009 at 1:17 am
sqluser (6/3/2009)
Is it possible to get who is created a database through T-SQL?
For Ex, if i see the Properties of a database there is a column called owner (who...
[font="Verdana"]Markus Bohse[/font]
June 3, 2009 at 1:15 am
Sorry, but I have really a problem understanding what you try to say.
But did you read the full article I send you?
Because among other things, it also says "Tables...
[font="Verdana"]Markus Bohse[/font]
June 2, 2009 at 7:32 am
Viewing 15 posts - 286 through 300 (of 1,654 total)