How long usually is the retention period for regular databases backups for other dbas in your org/company?

Thanks, when you say zip utility, what you recommend to use for zip databases?

Thanks

Thanks, we do have sql agent alerts setup, I wonder if it is the Severity 17- insufficient resources that does the work?

I never got the alert because we have a...

So, it doesnot send any kind of alerts to DBA proactively?

Thanks, currently we do have own DiskspaceCheck sql job to monitor the disk space.

So we set it to unrestricted.

But I see some people are using restricted method.

I am curious if...

Thanks all.

Then for my case, my buildingcode is always a number, I will use:

NOT LIKE '%[^0-9]%';

Thanks,

how about the difference

between

like '%[0-9]%'

and like '[0-9]%'.

Thanks, that makes sense.

But I wonder why some people use : not like %[^0-9]%

For my case, can I just change it to

Like '[0-9]%'.

What is the difference between...

Thanks, and thanks for site link, it...

Does this mean

1. for SSIS I can use 2008 R2 version BIDs for developing both 2008 and 2008 R2 SSIS package and deploy them to 2008 and 2008 R2...

I just found out on a testing server we tried to install the application and sql server, the dependency are there too. So it was done through the application installation.

Thanks,

No, I don't know. The server was setup years ago by people who has left.

Thanks,

Thanks, that is what I think too.

Thanks, I will not, I just want to know how those dependency are added in case if we migrate the databases from one server to a new server, do we...

Thanks, will give it a try