You can't specify a size for each backup file when backing up to multiple files but you can estimate their size based on the db size. So for a 200GB...

You need to run sp_dropserver and sp_addserver after renaming the machine. Also, if you have SQL Agent jobs that reference the server name, you will need to update those as...

You can find the plan handle and then use DBCC FREEPROCCACHE to drop an individual plan. However, be careful not to just run DBCC FREEPROCCACHE without a plan handle as...

Sounds like you are hitting this bug:

http://support.microsoft.com/kb/919224

Read this article. It generates the create login statements and includes their password as a hashed value.

http://support.microsoft.com/kb/918992

If it were me, I would not use SHRINKFILE with EMPTYFILE. EMPTYFILE marks a data file so that the data engine will no longer write to it. The only way...

Looks like MS is listening.

http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/02/13/update-on-the-service-pack-plans-for-sql-server.aspx

Yes it will work. The subscription database does not need to be the same name as the publisher.

You might be running out of restore threads on the mirror and need to enable trace flag 1485. The following is an excerpt from a SAP on SQL whitepaper (page...

You need to create a classifier function.

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

If you have 1 physical disk in a machine, that disk can logically be partitioned into separate "disks" like a C drive and a D drive. It's still only 1...

Just replace Domain\SecurityGroup in the query below with the actual domain and security group you want to know about.

EXEC xp_logininfo 'Domain\SecurityGroup','members'

I would echo what liteswitch said and suggest creating a test job with a simple step like SELECT '1' so you can run the job anytime. I would also...

You need to specify the remote server name. The code you are using is trying to connect to the named instance MYSQLSERVER2008 on the local host "sqlcmd -S .\MYSQLSERVER2008". It...

You will also need to restart the SQL Agent in order for the new mail settings to take affect.