This is an area in SQL 2005 that just does not hang together as well as it did in SQL 2000, that is copying msdb to another server of a...

there is a setting that controls this under sp_configure 'user connections'

However it would be highly unusual to set this to a fixed value. By default it is a dynamic value...

Erin (6/8/2009)

---

Yes....3 production databases on the same server. The users can only connect to one and then the backup of that one is restored to the others. For...

Sumanta Roy (6/8/2009)

---

thanks for the reply.

So I can take the transaction log backup with the option truncate and shrink the log file after that. Can I shrink the file to...

thanks for the feedback, so to clarify, you restarted the SQL instance only and did not reboot the server itself?

a) 1 will never = 2 so the delete will never run

b) column c does not exist in the table referred to so SQL will not know what you are...

As long as you replicate the directory structure exactly and have the correct version of SQL installed (check with select @@version) you should be fine.

Yes, you must restore the master...

Also, for above , you would then need to alter the application to point to the new server

By the way, should you upgrade to SQL2005 or 2008, the process above...

The process you describe would recover your system. As you are restoring the system databases you would automatically get all logins and jobs back and would not have to run...

webrunner (6/5/2009)

---

george sibbald (6/4/2009)

---

If you can afford the risk of it not working might be worth trying just restarting SQL, would be interesting to know if thats enough to clear...

treating the subject with the seriousness it deserves..........

tools for developers are seen as a way of improving quality, accuracy and productivity.

tools for admins managers are interested if it is seen...

David Fulton (6/5/2009)

---

This is compounded...

GSquared (6/5/2009)

---

The tendency I see, regardless of the size of the company, is that devs are more visible and their tools do have a more immediate and visible return-on-investment, while...

As what the characters might be was not specified, add a vote for nchar(1)

but so long as question generates debate...................

Nalini Devarakonda (6/5/2009)

---

This can be done ina easier way.

1. Restore the MSDB Database as msdb_test database on the server (this is just like any other user db restore).

2. Take backup...