Take a snapshot of the Table and subscrib to another.

Try using Export/Import or DTS/SSIS package.

Could you please the Disk space, It seems that opartion need more space you do not have enough space. What is the DB Size? How much space occupied by Particular...

Check the Windows error log and try to ping the server to check for any network issues. Try to check your TCP/IP and namedpipe is enable or not too?

Select @@version will give you the server version. Server propery is the next thing.

Good collection Brian and Simon, Thanks for giving those info.

You can use the following script but before I want you to make sure,"Do you have the SA permission on the server or not?" If not than you should not...

Try to use from GUI (SSMS or EM). and check for the error log if happeen.

Perfact Wilfred van Dijk and Kendal. Try to make a note of it why you need DB in FULL Recovery mode? Itf it;s in FULL how frequently you need Tlog...

S A (5/30/2008)

---

We recently upgraded a SQL Server 2000 SP4 to SQL Server 2005 SP2 Post GDR.

Prior to the upgrade, there were no issues with creating SQL or Windows...

Auditing is the organization policy. Every organization has policy to audit the servers in a year or so. It's a DBA responsibility that he/she has to make sure to make...

Vivien Xing (5/29/2008)

---

Ed (5/29/2008)

---

I use Litespeed to backup one of our 200gb databases. I also use Idera SQLSafe to backup several other multi-gb databases we have. Both do...

Perfact Terry, We did not think about this minor things. Check would you have SA permission on it or not? Check the mdf and Ldf file for the deleted DB(which...

Why you want to go with Clone, Better to take a backup and restore it on your Laptop.

I would say before taking any action take full backup then Tlog and then use DBCC shrinkfile command. After use DBCC again take Full backup immediately.

If possible try to check...