Viewing 15 posts - 61 through 75 (of 391 total)
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...
January 15, 2013 at 10:56 am
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...
January 15, 2013 at 10:24 am
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...
January 15, 2013 at 9:56 am
. If you have a firewall blocking 1433 requests from untrusted networks then the SQL Server will never even see the request.
This is good as long as nobody can...
January 15, 2013 at 5:56 am
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...
January 14, 2013 at 8:53 am
input this URL:
you can find many cheap and high stuff
Believe you will love it.
What does this have to do with SQL Server Replication? Are we allowed...
December 27, 2012 at 5:37 am
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...
December 26, 2012 at 1:29 pm
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.
December 7, 2012 at 7:37 am
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?
December 5, 2012 at 9:24 am
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...
November 27, 2012 at 6:49 am
--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+'')
November 13, 2012 at 7:01 am
A file copy from another server should be slower than a local copy.
:hehe:
November 7, 2012 at 10:12 am
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...
November 7, 2012 at 8:33 am
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...
September 6, 2012 at 8:29 am
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...
September 6, 2012 at 8:07 am
Viewing 15 posts - 61 through 75 (of 391 total)