Can you do something like this? I'm assuming you would know if "It was determined that a transaction log backup had run at the same time that the shrink was...

I'd do exactly as Cath has suggested but just from your description of the problem (grows to 20GB over the weekend), I can tell you are not backing up the...

Yes, if you save it, it becomes a DTS package. You can then open the package to add additional events (emails for instance). Simply save from the import/export wizard and...

Based on the OP's comments, he/she did not want to "read" anymore about how to accomplish the task at hand, therefore didn't want anybody posting links to valuable information. I...

Thanks MohammedU 😀 Some posters want everything given to them without any effort on their...

Sorry, didn't catch that it was for SQL2K. Anyway, this site has a couple of articles (parts 1 and 2!) that should help:

http://www.sitepoint.com/blogs/2006/11/12/sql-server-full-text-search-protips-part-1-setup/

When creating a database, there is no way that I'm aware of that you can specify a database "type". An interview question? Did you get the job, or more importantly,...

Check out:

http://www.eggheadcafe.com/articles/20010422.asp

http://msdn.microsoft.com/en-us/library/ms345119.aspx

A wealth of information on Google!

This may be totally off-base but, can you backup with init as opposed to append?

In the link it said to "delete" the full text catalog. If that doesn't work, I don't know what else to try besides a call to PSS. Not much else...

Brandie Tarvin (5/30/2008)

---

Do you actually have permissions to see ALL the databases on the servers? It could be, if you're not using a SysAdmin account, that you just can't...

Depends on how you want to do it. You can export/import the entire data set or build a SQL script to insert only those rows that don't exist in the...

As long as you get backups, whatever works for you is fine. Be sure to test the validity of your backup files from time to time.

Whatever account starts your SQL Services seems to have had some type of permissions change. If you're not the network admin, get hold of him or her and have them...

The user must be a valid domain user on the domain attaching to AND have, at minimum, rights to read to perform net use to \\Servername\SQLDataShare\Backups\Full\ . It'll also need...