Hi all,

Anyone ;(

Regards,

Noob

Hi GilaMonster,

Thanks for your reply and the wonderful link!

Same way we roll back any transaction. [Smile]

Log records needed for open transactions cannot be truncated. In your example, T1 (the oldest...

Lowell (3/8/2016)

---

szejiekoh (3/7/2016)

---

Lowell (3/7/2016)

---

The SQL Browser service has to be running on the server in order to do that;

that service keeps track of what port SQL is running on, and...

Lowell (3/7/2016)

---

The SQL Browser service has to be running on the server in order to do that;

that service keeps track of what port SQL is running on, and forwards requests...

hi all,

Thanks for the valuable inputs and advises. You folks here are simply amazing and contributing to the community by sharing information and knowledge here. 100 thanks for that.

I...

GilaMonster (3/2/2016)

---

szejiekoh (3/2/2016)

---

You mentioned the system databases store database info (what database are there).. so if i restore a T2 system database and restore a T4 user database, T2 system...

GilaMonster (3/2/2016)

---

szejiekoh (3/2/2016)

---

GilaMonster (3/2/2016)

---

No, they will not be in the system databases.

The system DBs store...

GilaMonster (3/2/2016)

---

No, they will not be in the system databases.

The system DBs store database info...

Hi Edvassie and all,

Thanks for the detailed and thoughtful explanations!.

Being new to the forum, is there a way to mark all or most of the answers correct or as helpful...

Hi Hugo,

Thanks for the wonderful reply !

You mean the installer will grant the necessary permissions to the "log on as" service account ?

How does the installer have the rights/permissions to...

Beatrix Kiddo (2/29/2016)

---

If you mean who will set up the service account and give it the right permissions, that would be your Active Directory/Windows Server/Infra/sysadmins depending on what you call...

GilaMonster (2/29/2016)

---

szejiekoh (2/29/2016)

---

UserB can login at any computer in the domain as "domain\accountB" and is still considered as OS authenticated and is able to access to the SQL server...

Hi GilaMonster,

Thanks for the reply.

You mean the installer will grant the necessary permissions to the "log on...

Hi Hugo,

Thank you for your valuable input.

I would like to apologize if my questions sound rather irrelevant at times as I really have minimal expierience in windows environment.

1) I tried...