Viewing 15 posts - 9,016 through 9,030 (of 9,244 total)
use the SP_Addumpdevice stored proc, syntax is as follows
'type', 'device name', 'drive:\path\file'
type is either disk or tape
device name is the logical name you want to use
drive:\path\file should be self explanatory
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2008 at 4:48 am
which apps in particular?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2008 at 4:35 am
use this handy script to change object owner to another user for objects ion the database
select 'exec sp_changeobjectowner '''+user_name(Uid)+'.'+name+''','' ''' /*owner to assign to, dbo for example*/
from sysobjects
where user_name(uid) <>...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2008 at 4:34 am
search this site for some of Brad McGhee's tutorials, they're very helpful
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2008 at 1:40 am
as a side note BOL also recommends to update usages too using
dbcc updateusage
I've already seen a similar problem on a couple of databases i upgraded recently.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2008 at 1:36 am
glad you're all sorted 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2008 at 10:27 am
can only be done for adding columns as far as i know
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2008 at 8:26 am
Rod at work (7/17/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2008 at 7:59 am
you should always rename the server before SQL is installed.
Un install SQL server, rename the server then re install
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2008 at 2:11 am
virtual server enterprise will quite happily allow virtual sql servers to run, in fact it is possible to set up a 2 node sql cluster 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 12, 2008 at 4:36 pm
under 10 user connections!
i would home on an existing instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 12, 2008 at 10:05 am
have the backup verify the files at backup time. if storing on a backup on a network,
backup to local drive first then copy to network
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 12, 2008 at 10:02 am
when you attach\restore a db to SQL2005, i'm pretty sure it runs DBCC CHECKDB as part of the upgrade!
You would certainly be advised to update the stats to sql2005 stats
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 12, 2008 at 6:16 am
you can also use the alter database modify file command to move the files, make sure they're in the same location as MASTER as already stated
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 12, 2008 at 4:24 am
Junior_DBA (7/21/2008)
1) offline DB2) detach DB
for future reference;
once the database is marked offline you do not need to detach the database you can just go ahead and copy the files...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 11, 2008 at 4:36 am
Viewing 15 posts - 9,016 through 9,030 (of 9,244 total)