Viewing 15 posts - 9,151 through 9,165 (of 9,244 total)
you would need to move the databases first otherwise when the script runs to apply the logins it will most likely fail as it wont be able to set the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 19, 2008 at 1:48 pm
how big is the log file?
the file will not shrink if there are transactions occupying the file. You would need to truncate the log first to clear transactions then shrink....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 19, 2008 at 1:43 pm
barb.wendling (7/18/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 19, 2008 at 1:39 pm
have you checked the sql logs for any errors?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 19, 2008 at 1:24 pm
what backup product are you using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 19, 2008 at 1:23 pm
LISETH_T (7/15/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 4:13 pm
go into add\remove programs and find SQL server 2005 then click remove.
the wizard will start and ask which instance you want to remove. select the radio button for the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 4:09 pm
even if you dropped the PK and loaded the data as soon as you try and re create the PK it would fail anyway
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 3:04 pm
why not alter the column and add the NOT NULL clause.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 2:52 pm
ALZDBA (7/17/2008)
but that will generate log-file overhead.
set the database to bulk logged recovery mode before executing the delete statements
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 2:45 pm
for a filegroup to be of any use it would need to be spread across a separate array to the primary filegroup. Cant see any advantage to creating filegroups and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 11:06 am
jsgault (7/14/2008)
Thanks for your help everyone. It is working now, hooray!!
well done!!
jsgault (7/14/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 10:54 am
srbrewster (7/17/2008)
I need the query to determine the mdf file location of a database.
just change fileid to 1 instead of 2 as below
select a.name, b.name as 'Logical filename', b.filename from...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 10:49 am
if you have the original SP2 file sitting around on the network remove it and replace it with the latest so it doesnt get re deployed in future 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 10:47 am
what disk set up (RAID arrays, etc) are you using on your SQL server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 10:44 am
Viewing 15 posts - 9,151 through 9,165 (of 9,244 total)