Viewing 15 posts - 2,161 through 2,175 (of 9,707 total)
Send some of that snow my way, Steve?
November 17, 2015 at 11:38 am
If you only need to restore once every two weeks, then restoring off the production backups (as Gail suggested) is your best bet.
Create a T-SQL job that is scheduled...
November 17, 2015 at 10:31 am
As Anthony said, you need to talk to the person providing these backups to you.
EDIT: To be clear, unzipping a file does not "create" a backup file. What's happening is...
November 17, 2015 at 8:42 am
GilaMonster (11/17/2015)
November 17, 2015 at 6:24 am
Ed Wagner (11/17/2015)
Brandie Tarvin (11/17/2015)
Ed Wagner (11/17/2015)
Lynn Pettis (11/16/2015)
Ed Wagner (11/16/2015)
Lynn Pettis (11/16/2015)
************(11/16/2015)
November 17, 2015 at 6:23 am
Ed Wagner (11/17/2015)
Lynn Pettis (11/16/2015)
Ed Wagner (11/16/2015)
Lynn Pettis (11/16/2015)
************(11/16/2015)
November 17, 2015 at 5:37 am
How are your backups being done? Is it a SQL Server maintenance job? Is it a third party tool? Is it a T-SQL job you created?
November 17, 2015 at 5:27 am
Functionally, so long as the linked server exists, you shouldn't have too much of a problem. But remember that it takes a little bit extra CPU to process those linked...
November 17, 2015 at 5:24 am
You can also use "SELECT @sql" which will do the same thing as PRINT but just stick it in the RESULTS tab instead of the MESSAGES tab.
November 17, 2015 at 5:19 am
What kind of concurrency are you looking at? Can it be a day behind? Does it need to be instantly (or near instantly) current?
What kind of backups are you...
November 17, 2015 at 5:18 am
GilaMonster (11/16/2015)
Steve Jones - SSC Editor (11/16/2015)
If you can't do anything else, then you can use the WITH TRUNCATE option to clear the log
Not on SQL 2008. WITH TRUNCATE_ONLY throws...
November 17, 2015 at 5:00 am
GilaMonster (11/17/2015)
November 17, 2015 at 4:54 am
ChrisM@Work (11/17/2015)
Brandie Tarvin (11/16/2015)
Lynn Pettis (11/16/2015)
Sorry, got snippy with an OP.50 lashes with a noodle please.
My Patented Wet Noodle <tm> no less. Shame.
EDIT: BTW, I'm teasing you, Lynn.
Oh gosh, how...
November 17, 2015 at 4:52 am
WayneS (11/16/2015)
Lynn Pettis (11/13/2015)
(think government contracted software development).
My scary story when working with the gov't.
Software contract awarded, specified that all data access has to go through stored procedures.
They sent to...
November 17, 2015 at 4:51 am
balasach82 (11/16/2015)
Is it because of Excel 2003. If I point it to Excel 2010/2013, would it be resolved?
I don't know. You'd have to do a google search for the max...
November 16, 2015 at 12:10 pm
Viewing 15 posts - 2,161 through 2,175 (of 9,707 total)