g_demetriou (6/7/2013)

---

You're right it's a bit confusing,...

Dird (6/7/2013)

---

I would assume that the purpose of an exam is that you answer...

g_demetriou (6/7/2013)

---

jnuqui (6/7/2013)

---

You need to ensure the successful recovery of any single database from a catastrophic failure without requiring backup data center in a different location.

which three tasks should you...

its not cheating. The answers are also given by other DBA's and not verified by MS. And how would you know really that this is the answer to the questions...

No backup = No way of retrieving those deleted data back.

hi!

Please check the LOGIN you are using if it has access to the databases. 😛

Could be the account your using has limited rights to the databases.

Regards,

JM

dwain.c (6/5/2013)

---

Further poking around leads me to believe that the only accounts listed by the Config Mgr are Windows authenticated accounts, whereas 'myaccount' is a SQL authenticated account.

I'm wondering if...

Yes this is called multi-instance cluster. Combine 2000, 2005, 2008 and 2012 in a same server is possible. All Sql Server versions can have their own upgrades, etc except for...

hi Jigs,

SQL Server agent is located on SQL SERVER Configuration manager. Click SQL Server Services then click on SQL Server Agent, Right click and click properties. The account specified to...

Replication would be good option.

thanks for the response! 🙂

Thanks for your response!

but im referring to the backup Options FULL, SIMPLE and Bulk log. Sorry for the confusion.

2005 and 2008 are pretty much the same.. 🙂

I got curious on what the hell is this SQL Auditing Foundations thingy which only the scope of SQL Server 2008 Standard Edition.

Upon Googling here's what I found. :)...

Hi!

it seems your having trouble with account issue. GO to SQLExpress propoerties. Change built in account from network to local system.

SQL Server Config Manager --> select sqlserver2005 --> right...