bommaka.nagarjun (11/19/2012)

---

Hi ,

If i set my Txn log backup frequency for 15 mins, what is the worse data loss? Is it for 14 mins 59 Secs? (Assuming disaster happens immediately...

First off why do your users have access to backup the database? I would strongly recommend reviewing your permissions and working from the ground up on least amount of...

IgorMi (11/20/2012)

---

Except the collation, your code...

You dont, SQL will always assign the lowest free number from sys.databases to a newly created / attached database, so either another database was created and got DBID 6 so...

Tava (11/19/2012)

---

Bob Griffin (11/19/2012)

---

Specifically, the user that the sql database server is running as has to have permissions to read the backup file. If possible, browse to the bak...

Run the upgrade advisor, fix any issues it reports, then all I can say is test, test again, then test the test again before doing the actual upgrade.

Ensure you are...

http://www.sqlservercentral.com/scripts/String/89388/

It will take a lot of time and resources to do what you want to do, so I would strongly recommend going away and rethinking about what you need to...

Static-X

Just grant execute to the user.

Although the prefered way of doing permissions is by roles as it makes life easier to manage.

Create a role if not already then assign the execute permission in the database context then add the users needed to the role is the way I would recommend doing...

I am guessing the problem is that you haven't set IDNo as an identity to autopopulate with an ID number. The error is being thrown by the SQL server...

There is no data in the file for it to import.

The error states it reached to end of the file before importing anything and to check the field and row...

Thats a warning, it wont cause the package to fail.

The screenshots detail Errors, one of which was inserting NULL into a column which didnt accept NULLs as well as other...

You will need to shred the XML into its parts to rebuild the condition as it look in the GUI.

Run Brad's DMV Starter Pack especially the CPU related DMVs against your instance, http://www.bradmcgehee.com/2010/07/free-sql-server-dmv-starter-pack/

Also read chapter 3 of the Accidental DBA guide, link in my signature below.