You're welcome.

Jeff Moden (2/26/2010)

---

To add to what Gail has already identified, are you worried that a table will have over 2 billion rows in it? If so, you could always...

1. The use of Int is a common practice.

2. You will receive errors. If using an Int, you may want to change that to BigInt.

Otherwise, the comments...

Or different instances with same file location but same database file names.;-)

A common practice is to backup the transaction log every 15 minutes. ...

If I am to understand you correctly, it appears that you only backup your transaction log once a day as part of your backup maintenance plan which also performs the...

I would have to agree here. The lack of a column in the...

Database names within an instance must be unique.

You might want to look into a ddl trigger at the database level or the use of event notifications. Either of these options could alert you to somebody trying...

A login gives you access to the server.

User gives you permissions into a database.

Which database is it (system or user)?

We had an issue with our tempdb doing the same thing. We fixed it by changing the model db settings.

Here's a link on how to restore backups.

http://msdn.microsoft.com/en-us/library/ms177429.aspx

What is the frequency of your Tlog backup?

Are you in full recovery mode?

If so, then you need to be backing up the log file on a regular basis in addition to your full backups.

This is a good suggestion. There are...