Hi

We rebuilt fulltext index on another database and we saw database starting to recover and after 15 minutes it finished, the last error before the recovery started was transaction spid...

So Database has not come back online. In recovery still... Any suggestions please? Thanks.

Hi

Database has been in recovery for more than 24 hours and we are 99.99% sure it will never come out of recovery. It keeps throwing 1450 errors every two...

Hi

error 1450:

Insufficient system resources exist to complete the requested service.

Hi, Thanks for your reply, but the database has been in recovery for too long, usually takes less than a minut, we think it is very unlikely for it to...

Hi everyone, Thank you for your replies. I stopped the shrink file and started a new shrink but only reduced the size by 2 GB chunks and it finished in...

Found the Answer to my last question...

Here is the link

http://blogs.msdn.com/b/varund/archive/2009/06/04/backup-sql-server-database-to-a-share-drive-on-another-server.aspx

I just mapped to the drive, and now SQL Server can see it, and can backup to it!!

😉

So I made sure the permissions are correct, This is a new share that SQL agent account has read and write access to. Both the servers are in one work...

Hi

I was able to copy the backup file to a disk on a different domain, now due to disk space issue, I need to backup straight to the disk...

Hiiiii

thank you very much. I tested this and worked. :w00t::-D:-):hehe: As you can see, I am an excited newbie!

Regards

Thank you. Will try and let you know if I was succesful .:-)

Hi

The purpose of this job would be only to save a copy of the backup on the second server. There is no need to attach files or anything, its just...

Hi and thanks for your reply

We have two servers on a work group. The second server does not have SQL server on it, it is just a disk. It is...