We also only allow DBAs with sysadmin access to create databases (in prod). My personal standard is to immediately change dbowner to 'sa' after creating the database. Bit of a...

Kishore, you cannot use restore to move all the .ndf files into one .mdf output file. The restore needs to be on a '1 file in - 1 file out'...

need to be sensible here. who knows what the DBA might need to do or look at to troubleshoot a problem, so give him/her local admin (on SQL servers only).

Could...

r u using shrinkfile or shrinkdatabase? only shrinkfile will be able to shrink it to less than its original create size.

use dbcc loginfo(dbname) to check if the last chunk is...

so when the application developed using 'agile' techniques does not perform, do they blame the database and tell the client DBA to fix it?.........:D

well ok, restore method gotta be easier though.

you want to go from 4 files to 3 files, so use restore database...with move as Phill said to place 4 files on drives you want them. Then use dbcc...

don't forget you are going to need server wide stuff already setup and ready to go. i.e logins, server roles, ssis , sqlagent jobs.

This can all be done up front...

Jane, I should point out that SQL 2000 analysis services is not cluster aware. 2005 analysis services is so perhaps you should go straight for that.

the following article expalind how...

you have deleted from the tables but until you issue a dbcc shrinkfile or shrinkdatabase you will not see a reduction in the size of the database files. Does an...

26% got this correct. How many of them got this right by luck, not having realised no such thing as middle join?

I am very upset to have missed out on...

alex mook (12/12/2007)

---

I know that the /3gb switch will leave the OS with 1GB of available memory. Do you know of any issues with this switch that would cause the...

yep you can use with standard ed.

http://technet.microsoft.com/en-us/library/bb124810.aspx

if server is purely for Sql server use of the /3GB switch will give you more headroom.

log shipping and transactional replication not the same. Log shipping better suited to a Dr solution IMHO, replication more for scale out.

By all means keep msdb backup on failover server...