Viewing 15 posts - 23,281 through 23,295 (of 39,819 total)
Any version/edition of SQL Server 2008 can restore a compressed backup, however only enterprise can make one.
It does have to be 2008.
June 29, 2009 at 7:39 pm
You could automate this by looping through the tables and doing a BCP out for a schema, however that doesn't get views/procs/functions.
Jack's suggestion might be the best one.
June 29, 2009 at 7:38 pm
Be sure that you are now running transaction log backups, and that you took a full backup after the shrink and change from simple.
June 29, 2009 at 7:27 pm
I'm surprised it took so long for someone to want a bartender. Getting up on stage almost necessitates that for some people!
June 27, 2009 at 7:26 am
Yes, you have a hot spot on the table. Note that depending on the CLI, you could have a hot spot there as well. The key is that you also...
June 26, 2009 at 10:14 am
For a heap, when you insert data, it adds to to the next page in the last extent (or makes a new page). For deletes, space is marked as deleted,...
June 26, 2009 at 9:53 am
Dave,
We'd be happy to work with you to get an article done.
The first step is usually stop and think essay, think about high school/college, and structure things like that. Write...
June 26, 2009 at 9:50 am
Grant Fritchey (6/26/2009)
June 26, 2009 at 9:26 am
One more thing, if you are using this to build your own brand, put it on your resume, you might want your full name.
June 26, 2009 at 9:06 am
Ah, not yet. :hehe:
Going to DC, dropping my son off at the National Youth Leadership Conference for a week, spending some time with my brother, speaking in Richmond on Thur...
June 26, 2009 at 9:05 am
jwalker25, don't get upset, :-D, we've all been there.
Certainly understand politics, just wanted to be sure this wasn't ignorance or a lack of understanding.
If you were to replace a current...
June 26, 2009 at 8:45 am
Sorry, what I meant (and didn't say) was does SQL Server need this stuff on %SystemRoot% for some reason? Or could it be in the /bin for where SQL Server...
June 26, 2009 at 8:41 am
You could link the servers together and have one Agent call sp_start_job on the other server.
June 26, 2009 at 8:37 am
Alright, I'm leaving for a week. Behave yourselves on the thread.
June 26, 2009 at 8:34 am
Good to see some people know what they want. I especially like the pizza one. If I were close, I'd ask for Chichos pizza in Va Beach, but only if...
June 26, 2009 at 8:31 am
Viewing 15 posts - 23,281 through 23,295 (of 39,819 total)