Lynn

To restore to 1/13 4:00 AM you will need the previous days (1/12) full backup file plus all the t-log backups since that backup up to the t-log backup that...

Your backup started before the time you want and ended after. The data should be there when you restore. The T-Log dumps from 1/12 are now worthless. You cannot restore...

backup is the snapshot as of the moment the backup statement commenced. anything after that will not be there in full backup. in my case backup is as of 1...

This is good as long as nobody can...

I try to always use no-default ports after getting struck by a worm a few years ago that went after 1433. I have not had any problems with web servers...

What does this have to do with SQL Server Replication? Are we allowed to advertise...

Sebastian, I think that your article is very good for a step 1. Looking forward to seeing the rest. I do have a problem though, with the publication steps. You...

Got it wrong :w00t:. Should have gone with my first instinct, but then started to read into it. Should have assumed that the permissions were dbo.

I'm curious, when did you go to the virtual server? Also, has the database been growing all of this time? Finally, what else is running on the physical server?

Have you considered a full text index? I have had very good luck in some cases with issues such as yours. Check it out here and see if it would...

--Execute a SP on a remote machine w/o using linked server

insert into #temptable

exec('exec OPENDATASOURCE(''sqloledb'',''Data Source=servername; User ID=loginid;Password=password'').databasename.schema.storedprocedurename''' +@parameter1+''','+@parameter2+'')

:hehe:

if we had problems with the SAN or connectivity many other larger systems not on SQL Server would be complaining up and down and there has been none of...

which is why I didn't say checkpoint;-)

Checkpoints are database specific and not server wide. I think that this case is going to turn out to be not enough memory and/or...

Freeing the buffers and cache will make EVERYTHING in SQL Server run slower.

What exactly is running slow? Is it sql commands or OS or both?

How much memory is...