Viewing 15 posts - 661 through 675 (of 1,790 total)
Yeah, it looks like that is for standard users. He has a section in the procedure where he specifically looks at the SA / dbo relationship.
Glad you were able...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 30, 2009 at 2:10 pm
Check out this post[/url] on the msdn site. Does this answer the question?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 30, 2009 at 2:04 pm
From BOL:
Log shipping has the following requirements:
SQL Server 2005 Standard, SQL Server 2005 Workgroup, SQL Server 2005 Enterprise Edition, or a later version, must be installed on all server...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 30, 2009 at 1:53 pm
Why the second command? Curious.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 30, 2009 at 1:50 pm
Well, I would drop that subscription and try again. Might even want to script out the publication, drop it, recreate it and then re-add the subscription.
I have never seen...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 30, 2009 at 1:49 pm
Frank Carrelli (4/30/2009)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 30, 2009 at 12:49 pm
What does the history on the job look like? Ultimately that is what runs the snapshot process so, either the job is running over and over or it is somehow...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 30, 2009 at 12:23 pm
Is the snapshot agent running multiple times? If so, check the schedule on there and make sure that it is not misconfigured in some way.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 30, 2009 at 12:03 pm
Lowell (4/30/2009)
you've got to update statistics and rebuild indexes after upgrading or restoring a database that came from a previous version in order...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 30, 2009 at 10:40 am
Does the execution plan look solid and does the indexing etc look good. It may be that the optimizer can't find a good plan based on the indexes and stats...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 30, 2009 at 10:33 am
I can't think of what there would be information kept in master about this being a clustered instance as that is done through windows and the binaries. So, the restore...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 30, 2009 at 10:28 am
There are varying levels of DR that you can build and it sounds like you are going for the real basic version which is most likely fine for your company....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 30, 2009 at 8:46 am
It seems like you would need to get the proper file name and then build that into your restore script dynamically. So, you could use the following script as a...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 17, 2009 at 10:07 am
Thanks for the correction Grant, it is headeronly.
Greg - the log backup is set to NOINIT so, that is probably where the problem lies.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 8, 2009 at 9:51 am
Are you appending the backup to a previously existing file? What do you see when you run RESTORE FILELISTONLY from disk = 'YourPath\YourFile'?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 8, 2009 at 9:07 am
Viewing 15 posts - 661 through 675 (of 1,790 total)