sql_lock (7/24/2009)

---

gregory.hill (7/24/2009)

---

I work for a company called SQLAlert that produces a lightweight monitoring product of the same name. The product runs stand-alone on one-or-more servers with load balancing...

your description is a little vague...but this post maybe of use:

http://www.sqlservercentral.com/Forums/Topic575769-148-1.aspx

a colleague of mine has reviewed a few monitoring tools back last year and wrote an article on it...

His article can be found here:

http://www.gre-sqlserver-solutions.com/MonitoringTools.html

Hope it helps

parthi (7/20/2009)

---

HI

What is the Use of On-Line,Off-Line in ms sql.

Whether it can be used to reduce the TempDb Size by bringing TempDb to Offline and then Online(Is...

If you have created a database user in the primary database, it will be included in the log shipped version when that log is restored. basically the creation of a...

you try a reverse of the process:

1 create the login on the secondary box...

2. Get the sid of this login.

3. Recreate the login on the priamry with the exact same...

Not sure if there is another method but i think the only way around this would be to create the login and database user on the primary...The DB user will...

Is the secondary database a logged shipped database?

edited: punctuation added

Mathew, not entirely sure if this will help but make the package part of a project solution when editing...If its not you might not be able to change things like...

i beleieve Tempdb this article may be of use to you:

http://www.sqlservercentral.com/articles/Temporary+Tables/66720/

Yes it is, using a manual log shipping process to keep a large db up to date prior to the migration...

Noel McKinney (6/18/2009)

---

Good article Jonathan, I've used these steps to move databases to new hardware and datacenter with just a few minutes of downtime. The key is making sure that...

RTFM!

Sorry i couldn't see that for looking, must be Mondayitus.

Thanks

As Allen mentioned, check the logs and event viewer. What account is the SQL Service set to run under, domain or local? It Maybe worth checking that nothing silly, like...

Not sure that it is offered out the box so to speak...

http://www.mssqltips.com/tip.asp?tip=1174

but this other link from the same site explains how you can work around the problem