Viewing 15 posts - 9,286 through 9,300 (of 9,725 total)
John,
How are you trying to restore? Via the GUI or via T-SQL?
Also, did you check the sys.files table on the database in question? See what files SQL Server...
November 20, 2007 at 4:41 am
What type of DDL trigger did you create?
Remember, even if you're talking about the trigger being set up on a database scope, if the DDL trigger has anything to do...
November 20, 2007 at 4:39 am
Which direction are you going? Are you creating 2005 as a linked server on 2000? Or vice versa?
I don't think the first one will work. I...
November 20, 2007 at 4:33 am
I've had problems before in 2k5 where using the GUI to attach the DB wasn't working properly and while the database showed as attached, the sys.databases table didn't know it...
November 20, 2007 at 4:31 am
Make sure to notify your end users about the restart of services BEFORE you do it. They may lose data if you don't. (Data not commited to the...
November 20, 2007 at 4:29 am
I'm fairly new to the db design world myself, but here goes my opinions...
My first thoughts are purely datatype related.
Rating is 1-5. Why is it an int? If...
November 20, 2007 at 4:21 am
And Divide By Zero errors can kill your query if you don't use Try..Catch or some other test for income being zero, so make sure to take that into account...
November 19, 2007 at 10:34 am
Just an FYI to the original poster, init does NOT overwrite backups that have not expired or the set name in the t-sql doesn't match the name on the backup...
November 19, 2007 at 10:30 am
The business logic of only attaching copies of the .mdf and .ldf is that if these files get corrupted or set suspect when you're trying to attach them to 2k5,...
November 19, 2007 at 10:25 am
The problem with splitting TempDB is that it doesn't work very well if you're putting all the files on the same logical drive. The idea behind there being a...
November 19, 2007 at 10:19 am
Then take what I said and reverse engineer it a little. Since you're already inside, you know what the weaknesses in the system are. Start documenting them.
One of...
November 16, 2007 at 2:10 pm
Xintanaka,
It sounds to me like you're trying to justify to this small company why they should hire you, correct?
In that case, don't take impersonal data and usethat as a justification....
November 16, 2007 at 4:04 am
And thanks to everyone for the congratulatory posts. I'm just soooo thrilled about this.
November 15, 2007 at 9:58 am
Matt, How did you know the plot of my tale???? Not only an upgrade gone wrong, but the entire Board of Directors standing over a poor DBA's desk demanding...
November 15, 2007 at 9:57 am
And to enable xp_cmdshell (if you haven't already), go to SQL Server Surface Area Configuration -> Features. This is where you can enable it. It'll be listed under...
November 15, 2007 at 4:52 am
Viewing 15 posts - 9,286 through 9,300 (of 9,725 total)