Viewing 15 posts - 346 through 360 (of 420 total)
How are you connecting to sql from SSMS on that server...
are you using ".", "localhost", "machinename", or "server.domain.com"...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
February 1, 2008 at 11:48 am
I like the object-level restore in litespeed and the like. It's really saved our asses a few times. Those vault products can't even touch that.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
February 1, 2008 at 11:46 am
No, LiteSpeed backups are individual files just like many other backups, including native. There's a clear advantage here in the ability to ship them to other servers and mirror...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
February 1, 2008 at 10:16 am
Y, you can change the SKU when upgrading SQL from the cmdline. There's a switch for it. I think it's /ChangeSKU, but don't quote me.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
February 1, 2008 at 10:00 am
Y, sorry dude... you said it best in your post that you can't post the code. That means you realize that there's really no way for us to help...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
February 1, 2008 at 9:55 am
Y, seriously dude... we can't do your homework for you.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
February 1, 2008 at 9:42 am
Both SANS and direct storage can outperform each other given the right conditions. I've been on both and have had good luck with them. SANs can be good...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
February 1, 2008 at 9:40 am
Y, if space isn't an issue it's always best to let the log keep some free space. If performance isn't an issue you can shrink it, but it really...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
February 1, 2008 at 9:29 am
I suppose anything's possible, but I doubt it. Try changing the DB back to the original on your copied package to find out for sure. If it works,...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
February 1, 2008 at 9:25 am
I don't understand how you can say LiteSpeed is too decentralized. They push everything up to a central repository and you can do all of your reporting from there....
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
February 1, 2008 at 9:21 am
If all you're looking for are compressed backups with a little extra restore functionality take a look at HyperBac. They're a young startup, but they're not new to the...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
February 1, 2008 at 8:35 am
Actually, I can remember being where you are right now. Cursing the changes that seem useless. Most of the stuff is backward compatible so you shouldn't be dead...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
January 31, 2008 at 8:25 am
Y, ERStudio is the bomb. I used to convert ERWin diagrams with it all the time. I don't imagine that they would have lost that functionality. Almost...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
January 31, 2008 at 8:20 am
What happens if you don't stripe the backups? And it's only 10GB, why do you need to stripe it to begin with?
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
January 31, 2008 at 8:16 am
Of the many vendors out there, to my knowledge LiteSpeed is the only one cluster aware. A couple of the others try to be, but they're really not. ...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
January 30, 2008 at 7:58 am
Viewing 15 posts - 346 through 360 (of 420 total)