What about the unused space on this database?

chrisph (3/11/2010)

---

I agree on the DBA(s) handling this CirquedeSQLeil. The reason I ask is there might be a need that this be done weekly, I will have to learn...

They might have worked but what you had more than one publisher? It will break all the publications which are using that distributor database. re-initialize of subscriber or applying snapshot...

Yes, databases with...

rockingadmin (3/11/2010)

---

i got a huge error like "The concurrent snapshot for publication 'BetaDB01' is not available because it has not been fully generated or the Log Reader Agent is not...

4data (3/11/2010)

---

Hey Dan, thanks for the input.

I've done as you siggest (Go into SQL Server Configuration Manager, open the 'SQL Server 2005 Network Configuration' node,) but under there I only...

Dan H. (3/11/2010)

---

My port suggestion only makes sense if the service is running (in the Windows Service list) but can't be connected to thru SSMS.

If the service isn't...

what stage you are receiving this error message?

CirquedeSQLeil (3/11/2010)

---

GTR (3/11/2010)

---

Now, I don't have Enterprise manager, but do have this Sql Server Management Studio express.

I've found it shows me the same sort of info, but when I...

Carl Federl (3/11/2010)

---

MS has added some "Denial of service attacks" protection (SynAttackProtect setting), which can cause this message. See "Troubleshooting: Connection Forcibly Closed" at http://msdn.microsoft.com/en-us/library/ms187005.aspx

Also see "Avoiding TCP/IP Port...

I may missed here something in previous postings, Is TCP\IP, Named Pipes Enabled in SQL server network configuration (Not on SQL server native service configuration)

Now, I don't have Enterprise manager, but do have this Sql Server Management Studio express.

I've found it shows me the same sort of info, but when I double click...

You did not answer my other questions, what stage and are you using GUI or script? Chage user role to SA and try.

Are you doing this from local machine or remote client? what is the result when you run this query?select name, status, status2 from sys.sysdatabases

Then i would just expand drive space, Ask Server Team it wont be hard to expand drive for them, Disk is the cheapest resource among all other resources.

Do you have...