How do you get a database into recovery mode.
Wed, 3 Mar 2010 19:53:01 -0800
Here is the scenario.
I have a database on an equallogic box. The equallogic box does a snapshot
at 10:00pm, on sql server i am doing transaction log backups every 10
minutes. The database breaks at 10:30, so I restore to the 10pm
snapshot(this is not a sql snapshot). How do I get the database into
recov ...
|
DBA Job Change
Wed, 03 Mar 2010 13:51:36 GMT
After working for years as a DBA for my company I would like to transition to
another position within the corporation. The company has a large IT
department, however I'm not sure what I can transition to being a DBA. I'd
like to hear from other DBA's out there that have transitioned to other jobs
within or outsi ...
|
DBA Job Transition / Change
Wed, 03 Mar 2010 13:51:14 GMT
After working for years as a DBA for my company I would like to transition to
another position within the corporation. The company has a large IT
department, however I'm not sure what I can transition to being a DBA. I'd
like to hear from other DBA's out there that have transitioned to other jobs
within or outsi ...
|
CHECKDB loop SQL 2008
Wed, 03 Mar 2010 15:27:49 +0200
On my SQL 2008 SP1 server it seems there is a loop of events for 3 of
the databases existing on this server.
On the Windows Application event log there are intermitently logged events
17137 Starting up database 'db'
and then
17573 CHECKDB for database 'db' finished without errors on yyyy-mm-dd
07:13:53 ...
|
SQL - Relational DBs Overview Resources
Wed, 3 Mar 2010 01:31:02 -0800
Hello there,
Are there good resource documents on the web somewhere providing a
very good rundown of what relational DB's are, how they are used,
tables/constraints/relations/etc, all the usual conceptual suspects, in
roughly 100 pages or less?
A friend sort of inherited a small s ...
|
Dump Database instantly
Tue, 2 Mar 2010 21:38:01 -0800
Hello,
I would like to capture the contents of a database (complete) at a
particular instant. This could be triggered for different reasons. At any one
of these trigger events (trigger: not to be interpreted as SQL trigger) the
entire database should be dumped in whatever state it was. This will be used
f ...
|
copy entire database over to linked server
Tue, 2 Mar 2010 16:47:08 -0800
I just setup a linked server that is provided through our ISP. Our database
is setup as merge replication that is pushed to four remote locations all
running sql server.
I want to setup the linked server with the same database. What is the best
way to do this? Can I configure merge replication with the link ...
|
|
|
orphaned transactions
Tue, 2 Mar 2010 16:22:08 -0800
Hi
I have located some orphaned transaction in "sys.syslockinfo WHERE req_spid=
-2", but I cant see them using sp_who or sp_who2. I can still kill these
using UOW.
Any idea why these are not listed in sp_who with spid=-2?
thanks in advance
--
Regards
priw ...
|
DBCC SHOWCONTIG
Tue, 2 Mar 2010 13:10:01 -0800
What does it mean when this report shows blank under index name?
Thanks in advance ...
|
SQL Server 2005: Management Studio missing after setup
Tue, 2 Mar 2010 12:35:02 -0800
hi everyone
i already posted this in the setup group but couldn't get a reply up until
now.
yesterday i was experiencing some issues trying to install SQL Server
2005 on my Windows Server 2008 R2 box (64-bit).
after i completed the installation i can't seem to find the SQL
Management Studio. i have s ...
|
