Do you know Google? just type SQL server logshipping and you will find everything you want to know.

Here's a starter http://www.informit.com/articles/article.aspx?p=331402

Books online has a pretty detailed step-by-step instruction about how to install SQL Server on a cluster.

Start here http://msdn.microsoft.com/en-us/library/ms179410(SQL.90).aspx

Because public still has certain permissions and someone might add more permission to that role.

T.Papachristopoulos (1/7/2009)

---

What...

It depends.

If the Primary keys are created with a clustered index, then don't place them on the index filegroup because the clustered index contains all the data.

If you create...

Oops, maybe I should have tested it before posting. But if you look in BOL you will find the reason why it's not working:

You cannot use ALTER_LOGIN with the DISABLE...

In SQL 2005 you actually can disable logins.

ALTER LOGIN [BUILTIN\Administrators] DISABLE

GO

This should solve your problem.

You call yourself SQL DBA and ask such a basic question ?

As...

Moreno (12/30/2008)

---

On our test server we have build 10.0.1600.22. I was thinking that eventually the date format could give some problems. When I run the query I don't get errors,...

I just tested it on my system and the parameter work fine for me.

Do you receive any error ?

Which version of SQL 2008 are you using?

nivedita.kathal (12/29/2008)

---

Hi,

I am working on a SQL job which generally fails once in two weeks (approx.). the job is running in SQL server 2000.while opening the sql profiler i can...

The native SQL backup and the maintenance plans only support backups to local tape drives.

If your server doesn't have a local tape drive, this option will be disabled. If...

HKwai (12/17/2008)

---

1. There seems to be something conflicting about this: The database ddl trigger produces a log file which you can name it as you like for that database....

If you simply want to enable it use the Surface Area Configuration tool. If you...

No, you need to uninstall the developer edition and then install Standard.

As an alternative you could install a new instance using the standard edition.

Either create scripts for all the jobs or use the Transfer Jobs task in SSIS.