One of my customers had an 823 error last week. In that case the reason was that the server lost temporarily the connection with the iSCSI disks.

Check your system...

I don't think you can do that with replication.

But could you explain why you want such a setup? If you need just a second stand-by server you can configure...

The easiest way would be to create a SQL Server Job.

When defining the jobstep select "Sql Server Integration Services Package" under type. The enter the location of your package...

netmikem (7/23/2008)

---

What I am not clear about is if this is normal behavior even if the account is NOT setup to use the 'Enforce password policy' property (which I am...

Yes, you need either Visual Studio or Business Inteligence Developmnet Studio.

If you never build a report before, I would advise starting with the tutorials in BOL.

About the backup code, in most cases you usually want to take a new backup first before deleteing the old files. I'm not sure if there's also an option to...

The red-gate extended stored procedure has a paramter to remove old files.

Something like this:

EXEC master..sqlbackup -SQL "BACKUP DATABASES [model]

TO DISK = 'E:\\MSSQL\BACKUP\\model\ '

WITH NAME = ' ',...

I assume you're talking about the SSMS report "Performance Top Queries by Average IO".

The results of this report are based several DMV's.

The only way to reset the values is...

Kevin,

are you sure that it only allows a max memory of 2 Gb? The default number shown in SQL2K5 (2147483647 MB) is actually about 2 TB and it will...

I don't have much experience with Oracle, but I think CURRENT_TIMESTAMP would be the T-SQL equivalent of LOCALTIMESTAMP(). Different from the Oracle function the T-SQL version of CURRENT_TIMESTAMP does not...

Hey,

thats funny. Over a year after the original post the replies are coming. Most of it I had figured out myself and actually I'm now three projects/customers further and...

When you use merge replication on tables with an identity column you have to set ranges for each replication partner to avoid Identity insert conflicts. So if you have to...

Looks like you installed a named instance when reinstalling SQL Server. You can now either use the named instance name Deep\Deep or you can create an alias in your client...

If you're using Enterprise edition of SQL2005 you could take a database snapshot.

Colin Smith (7/9/2008)

---

I've always been under the impression that when a full backup is carried out, it is a snapshot of the database at the point in time that the...