what are you trying to achieve here? Why do you need databases on both servers as principal databases?

EnjoY!

keyun (2/16/2010)

---

As per your guidance. I have set the Owner of the job as SA but i am getting below error.

Message

Executed as user: NT AUTHORITY\SYSTEM. Login failed for user 'DOMAIN_NT\SERVERB$'....

GSquared (2/16/2010)

---

GT-897544 (2/15/2010)

---

GSquared (2/15/2010)

---

Bru Medishetty (2/15/2010)

---

I would run the query

select @@version

and look at the output, where the end part shoes if nothing if it's a physical server and if it's...

jsb12 (2/15/2010)

---

There are 3 days of full backups and TLog backups in backup and trn folders respectively. I need to identify previous days full backup (8pm) and successive hourly transaction...

You can see all the details like when SQL Server\Agent started and stopped in SQL Server Error logs. You should be able to see this information in windows event logs...

Was this running successful before?

EnjoY!

subbarayudu.net 37258 (2/15/2010)

---

Hi Steave,

Its not a test question....

Once i create the user and I assigned those 2 database level roles.......

now that user not access the database, becasue of db_denydatareader overwrite...

Do you want to grant permission to edit\deploy packages for developers?

EnjoY!

Make sure you defrag\Rebuild index after you perform many DML changes, because the index will be fragmented after DML changes, that is why mdf file is same size...

Some times maintenance jobs fails due to packet loss in network, if network connectivity blip this may happen once in a while. Did this fail again, when you...

timscronin (2/15/2010)

---

If a login (sql login) on sql server 1 is mapped to a user in database A. And inside of database A that user has rights to execute...

GSquared (2/15/2010)

---

Bru Medishetty (2/15/2010)

---

I would run the query

select @@version

and look at the output, where the end part shoes if nothing if it's a physical server and if it's on a...

I may take that offer, if you send all your paychecks to me:-D

EnjoY!

GilaMonster (2/15/2010)

---

GT-897544 (2/15/2010)

---

In SQL version is 2005\2008 Auto update statistics option is set 'on' by default at database level, no need to update stats frequently, and also remember updating statistics...

keyun (2/15/2010)

---

Hi GT,

I am new to SQL server.. I check my login under LoginProperties --> Server Roles --> here i have everysingle roles assigned it to me. ( i guess...