Viewing 15 posts - 11,116 through 11,130 (of 22,214 total)
To back that stuff up, you backup MSDB. That's it. That's where that information is stored.
Why would this be hard with different servers? You have backup routines scheduled on all...
April 8, 2012 at 6:17 am
From everything I've read, you'll have to do an uninstall and a reinstall with the different edition.
April 8, 2012 at 6:13 am
Sounds like you're on the right track, especially with adding them to source control. I'd suggest breaking up the storage in source control so that all the objects that belong...
April 8, 2012 at 6:12 am
That's going to bring all of the remote server's data back and then perform filtering on it. Horribly inefficient. Instead, look to OPENQUERY where you can pass some parameters that...
April 8, 2012 at 6:10 am
You're running those in the wrong order. However, the fact that it grew your database means that's how much space your database needs in order to run the rebuild operations....
April 7, 2012 at 5:26 am
Go to the source, Microsoft: Each release of SQL Server has a "What's New" page in the books online. Go to this location in the Books Online and you can...
April 7, 2012 at 5:24 am
winston Smith (4/7/2012)
Perry Whittle (4/7/2012)
Server side traces have much less impact apart the potential for required disk space depending on what you are monitoring
I know, I use server side traces...
April 7, 2012 at 5:05 am
Jack Corbett (4/6/2012)
What do you all run to backup your home systems?
I may need to buy a new laptop soon. I use...
April 6, 2012 at 9:14 am
If other backups are working on the same devices there may not be anything to check.
At this point, I'd call Microsoft support. I mean, I'm not there and I...
April 6, 2012 at 6:33 am
RESTORE VERIFYONLY will fail with a Litespeed backup. That's expected.
Hmmm... When you run the native backup using checksum, you're not getting an error? But if you run restore it fails....
April 6, 2012 at 5:38 am
How are you determining that the backup is corrupt? What's the precise error?
Are you using checksum when you run the backup? If not, try running the backup using that. You'll...
April 6, 2012 at 4:17 am
I've got a 600 page answer for you. It's the book down in my signature on Query Performance Tuning. Performance monitoring and tuning is a HUGE topic.
Another book you should...
April 6, 2012 at 4:15 am
You shouldn't run Profiler on a production system anyway. But by that do you mean you can't run a trace script?
Since you're posting in a 2008 forum what about...
April 6, 2012 at 4:10 am
I've done a number of those as in-place upgrades with no issues. I'd still recommend running the 2008R2 version of the upgrade advisor first, but other than that... I think...
April 6, 2012 at 4:06 am
Seriously, that sounds like interview questions. Sorry, I'm with the others. I'm not helping there.
April 6, 2012 at 3:58 am
Viewing 15 posts - 11,116 through 11,130 (of 22,214 total)