Viewing 15 posts - 286 through 300 (of 1,655 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...
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.
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...
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...
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?
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...
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,...
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...
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...
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...
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...
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
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...
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...
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...
June 2, 2009 at 7:32 am
Viewing 15 posts - 286 through 300 (of 1,655 total)