calvo (7/19/2013)

---

So confusing.

You've restored from a backup successfully.

You've attached the .mdf file successfully (what about the .ldf?)

Seems like it should all work but your application cannot connect.

Have you remapped the...

Can you connect to the database using other SSMS?

If you are talking about the index definitions, then yes they are still there. Index data is gone - their pages are deallocated as well.

Minnu (3/20/2013)

---

Am having two instances A and B, in that having a table called students in two databasess, but the records are not in match,

i want to retrieve records which...

balaji.it02 (3/7/2013)

---

Hi

You have 2 options to perform..

1) Go for Database Snapshot & update snapshot frequently...

2) Go for Merge (Peer to Peer) replication for enabling mulitple users to update the data...

Well, I figured it out - the path for the backup files, C:\SQLLogs_LS\, was actually ' C:\SQLLogs_LS\' with a leading space. I altered the job, and all is well....

Take a snapshot of the mirror, and have the users connect to the snapshot:

http://technet.microsoft.com/en-us/library/ms175511.aspx

Try them both, and test.

What version of SQL? Are you connecting remotely? If so, what version is the database itself, and what version of the client tools are you using?

Excellent series Erin - thanks for contributing.

Just curious as to what the use caseeed is for this.

I recently purchased this one:

http://www.amazon.com/Professional-Microsoft-Server-2012-Administration/dp/1118106881/ref=pd_bxgy_b_img_z

Still digging through it, but the first quick pass it seems pretty thorough, with chapters on the basics, as well as chapters on SSIS, SSRS, ALwaysON,...

Yup - we run them every 10 minutes, for log shipping.

by "Active Directory Users and Computers" do you mean that the machine is a domain controller?

Kimberly Tripp's blog at sqlskills.com

http://www.sqlskills.com/blogs/kimberly/post/Transaction-Log-VLFs-too-many-or-too-few.aspx