Perry Whittle (12/5/2012)

---

Stopping sql server is a bit like using a sledge hammer to crack a nut. You only need to take the database offline as follows

ALTER DATABASE mydb SET...

I strongly recommend you take the database OFFLINE rather than detaching. Detaching as mentioned removes the database from the system catalog, which means some database options (saved in the system...

If this is the log shipping destintion it's being recovered, and so you can't move it like this. To do the ALTER the database must be in a recovered state.

Two...

Database backups are roughly the size of you data, not the size of you database files. This is assuming no compression. If the .BAK file is still getting bigger it's...

I've done a bunch of 2012 installs now and never had any problems. SP1 is out and it's worth doing the service pack. Only bug with the SP installer is...

This only moves the logical location of the files. To actually get them to the new location you need to take the database off line in some way so you...

Try using this, it works on my demo environment.

select dns_name from sys.availability_group_listeners GL

join sys.availability_group_listener_ip_addresses LIP

on GL.listener_id = LIP.listener_id

join sys.dm_exec_connections C

on LIP.ip_address = c.local_net_address

where session_id = @@SPID

Cheers

Leo

You'll need to supply a lot more information than this.

Are there server differences, disk differences, have you compared execution plans,....

Have you rebuilt indexes, updated stats?

There are a host of things...

If a log file back up had marked all the records in the file as no longer needed then a delete will also work. I tend to do the shrink...

Provided the log file is empty you can delete it. Ensure you have regulare log backups, do a shrink file and empty it.

DBCC SHRINKFILE (N'Scratch_log' , EMPTYFILE)

Then you should be...

I've not had any issues like this, and I've used backup and restore multiple times. Recommended migration is typically backup and restore, or detach and attach, or in place upgrade....

Not directly it doesn't. The default trace will log the create or drop of the trigger and it will log an alter table if the trigger is disabled or enabled.

The...

You could consider defining the foreign key with the ON DELETE CASCADE option. Then all you need to do is delete the parent record from Sidelite and all the child...

cheshirefox (8/24/2012)

---

I set Max job history log size (in rows) to 3000 and Max job history rows per job to 1000.

I will update the values again today to 4000 and...

What are the job history retention settings? Right click SQL Server Agent/Properties - History.

The defaults are Maximum log size (in rows) 1000, Max history per job 100. If some jobs...