Viewing 15 posts - 8,866 through 8,880 (of 9,208 total)
Sandra Skaar (9/9/2008)
i.e. physical file name is ORN1_data and ORN1_log)
they certainly look like logical file names too.
you can and i would change the logical file names using the
alter database...
September 9, 2008 at 12:00 pm
Jeff Moden (9/9/2008)
Or, you could do it the way I showed you and not worry about correlation. 😉
even better 😉
September 9, 2008 at 5:50 am
do you mean specifically tape devices or just logical backup devices?
September 9, 2008 at 5:47 am
Brian.Dunat (9/3/2008)
2. Modify Group Policy to ensure service accounts have the proper rights (ie: logon as service, etc)3. Add the service accounts to the necessary local groups on the server
SQL...
September 8, 2008 at 4:14 pm
what version sql server are you using?
September 8, 2008 at 4:09 pm
siweb (9/4/2008)
select value from table
where name = 'DateTime'
and IsDate (value) = 0
And no rows return. This should indicate that all the string values is recognized as a...
September 8, 2008 at 4:07 pm
SQL server 2005 std requires installing to a server OS not a client OS, for clients use developer or Express
September 8, 2008 at 3:59 pm
blom0344 (8/20/2008)
September 8, 2008 at 3:55 pm
where exists
would be more efficient than
where in
September 8, 2008 at 3:46 pm
you;ll need to move the data files over first and attach them to the server. Then you create the extra filegroups. Then create\move objects into those filegroups
September 8, 2008 at 3:28 pm
WMI, much easier 😎
strComputer = "."
Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\CIMV2")
Set colItems = objWMIService.ExecQuery( _
"SELECT * FROM Win32_LogicalDisk where drivetype=3",,48)
For Each...
September 8, 2008 at 3:25 pm
in this scenario the best way to analyse the log status is using
dbcc loginfo
look at the status column and they should ideally be 0. The further down you scroll...
September 8, 2008 at 3:21 pm
GilaMonster (9/8/2008)
Make sure that the account has full control over the directories that have your data and log files in, and also the directories that the backups go.
this shouldnt...
September 8, 2008 at 3:17 pm
dmc (9/8/2008)
Now on to figuring out the %cpu usage!
give it a go yourself and if you're still stuck post back.
Try searching for "Scripting guy", it'll be a lot of help...
September 8, 2008 at 3:11 pm
this should get info on all logical drives
strComputer = "."
Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\CIMV2")
Set colItems = objWMIService.ExecQuery( _
"SELECT * FROM Win32_LogicalDisk...
September 8, 2008 at 3:01 pm
Viewing 15 posts - 8,866 through 8,880 (of 9,208 total)