Viewing 15 posts - 8,356 through 8,370 (of 9,241 total)
as already mentioned, you really do need to take a good look at the disk subsystem
minimum you could get away with would be
RAID1 for OS (2 disks)
RAID1 for logs...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 5, 2009 at 3:59 pm
dastagirid
i am assuming from your post that you want a script to generate an insert statement for each row in a table, is that correct? If so, take the following...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 5, 2009 at 3:13 pm
Gail
i was under the impression that a database backup in simple recovery mode also initiates a checkpoint which will truncate the log file
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 5, 2009 at 2:37 pm
exactly how many disks do you have available?
what version\edition of windows do you plan to use?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 5, 2009 at 2:08 pm
also dont forget to back up the database after the index rebuild as this could fill up the log file depending on database size and no of indexes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2009 at 4:28 pm
what is the result of the following query
select * from sys.backup_devices
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2009 at 10:14 am
exclude the scanner from scanning sql data and program files
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 3, 2009 at 2:33 pm
you could use VBS something along the lines of
strComputer = "."
Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\CIMV2")
Set colItems = objWMIService.ExecQuery( _
"SELECT * FROM...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 3, 2009 at 2:30 pm
Ellis (3/3/2009)
I'm really sorry for the vagueness of this question, I need to expand my knowledge on running SQL Server in a virtual environment, for example using...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 3, 2009 at 2:20 pm
Mani (2/27/2009)
I created a login abc with default database master and I need to give access to this abc login to a stored procedure SP_ABC in database Mydb.
have you mapped...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 1, 2009 at 10:06 am
oohhh, this is pork chop territory. Me gonna duck and keep my faceguard on ROTFL
hey Jeff fancy seeing you in this thread 😉 LOL
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 1, 2009 at 10:02 am
Krishna (3/1/2009)
Index Rebuilding etc..
you probably don't want to be\shouldn't nedd to be doing this daily
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 1, 2009 at 3:41 am
or just use the stored procedure
sp_chane_users_login
to resync the server login and database user
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 28, 2009 at 3:32 pm
i assume you mean what are the ideal sizes for the log files?
the answer is how much activity is created against the database?
start off with 10% of database filesize...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 28, 2009 at 3:30 pm
check BOL for full info on how to set this up
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 28, 2009 at 2:21 am
Viewing 15 posts - 8,356 through 8,370 (of 9,241 total)