How could the CLeanup Task result in the model database going into (recovering) mode ?

Thank You 🙂

Lowell (7/22/2011)

---

SQL is very restrictive rights wise...users only get what you give them access to. You want to avoid things like just granting a user db_owner status or any other...

Yup,

Firewall Issues. Contacted the Local IT and he confirmed it.

Hi,

Was just going through this thread. Really interesting.

I have a question though, does this mean that a differential backup contains the changes made in a database from the time that...

Thank you !

paul.knibbs (7/11/2012)

---

Is there a reason you set a retention period of only 180 minutes? It doesn't give you a lot of leeway if the connection between the primary and secondary...

Checked the logs. It appears that the tran backups arent being restored.

Here is the error in the log :

The log shipping secondary database INFVA02839\INSTANCE1.AdventureWorks has restore threshold of 120 minutes...

please ignore . sorry.

Ran the above query . It shows the retention period as 180 .. which i guess refers to the 180 minutes set by me.

Yet the secondary transactional backup files arent...

Thanks !

Just to clear things , this is what my understanding is of index fragmentation :

1)internal frag - physical , happens at the leaf level , ie. index grows .

2) external...

Right , i guess that is what the problem is , cause creating a similar table in another database similarly restored isnt giving me the error.

Smart DBA huh? who...

There is a really strange issue going on here Mike.

I tried to create the table first as u said through GUI , but yet again it gives me the profile...

You are right , int would certainly look better, but float should work too , right ?

and yes , the names right , its saved as .xls and its not...