Viewing 15 posts - 4,846 through 4,860 (of 18,926 total)
So 160 GB on prod?
Backup is 100GB
Restore that as copy is 160 GB (260 GB on SAN)
Shrink down to 100GB (200 GB on SAN)
Backup that is another 100 GB (300GB...
July 18, 2011 at 11:36 am
Ha, I understood that you wanted the list of reports that had an hidden list on it :w00t:.
HTH!
July 18, 2011 at 11:33 am
Steve Jones - SSC Editor (7/18/2011)
SAN space in the US is...
July 18, 2011 at 11:27 am
GSquared (7/18/2011)
J Thaddeus Klopcic (7/15/2011)
July 18, 2011 at 10:43 am
Well if this is really a dev machine and NOT used for very specific tuning issues, a normal attached disk can do the job.
As for 5 years ahead it might...
July 18, 2011 at 10:27 am
Holly Koch (7/18/2011)
July 18, 2011 at 10:15 am
Steve Jones - SSC Editor (7/18/2011)
How much of the data changes?Is it better, perhaps, to build an ETL process to move the data instead of the full backup/restore?
I'd agree with...
July 18, 2011 at 9:29 am
Works as long as you don't do that to prod.
What I've seen work well to is to dump the log (on a copy of the prod db obviously).
restore prod backup...
July 18, 2011 at 9:22 am
This can get you started. I don't know xquery enough to do it for you.
This query finds the dataset sources. Use a similar logic to find datalists objects...
July 18, 2011 at 8:59 am
Global table variable don't exist.
The clostest thing is table valued function which can be used as parameter in a sp strating in 2008 iirc.
July 18, 2011 at 8:46 am
subbkarth (7/18/2011)
no log backups: only full backups
We know. We get that answer question 100 times a month. Which is why Gail wrote an amazing article on the topic...
July 18, 2011 at 7:26 am
July 18, 2011 at 6:48 am
rmechaber (7/16/2011)
July 16, 2011 at 1:03 pm
Tom.Thomson (7/15/2011)
Ninja's_RGR'us (7/14/2011)
SQLkiwi (7/14/2011)
Richard Warr (7/14/2011)
Good question but haven't we seen it before?
I thought so too, though I can't find the previous question. So, an easy 'green tick' for...
July 15, 2011 at 12:14 pm
Viewing 15 posts - 4,846 through 4,860 (of 18,926 total)