magasvs (9/5/2010)

---

You can have Windows logins on source database , but they have to be mapped to SQl Server logins on remote server. Windows to Windows logins mapping does not...

Again, a differential is based upon the previous full backup taken prior to the differential. Once you performed the snapshot backup (which is a full backup), then your differential...

Snapshot backups are not a part of SQL Server. They are SAN functionality. The SAN uses VDI to freeze SQL and tell SQL a backup has been performed.

That is normal behavior - a differential backup can only be restored after the full backup that was taken right before it. The differential backup is tied to that...

Ram:) (9/3/2010)

---

Our databases are in full recovery model..

When users reported me that they are getting timeout expire error and few applications are getting slow, I checked and found the log...

In your maintenance plan, how are the two tasks connected?

And, verify that you have configured the maintenance cleanup task with the correct directory and extension. As was previously mentioned...

There are three types of backups available in SQL Server - and they all work in relationship with each other.

First, you have a full backup - which is required to...

Make sure the version of the client tools is at the same or greater version as the database you are connecting to. For that matter, make sure the database...

I see no benefit to installing SQL Server binaries to another drive. When I install SQL Server, I take the default location for the program files and put the...

Well - that says a lot. The GUI is buggy - has been since Enterprise Manager and should be avoided.

I would recommend scripting your changes and running them as...

free_mascot (8/30/2010)

---

If the database is in use you will not be able to put it offline.

For that you do have two option:

1. Kill the connection to the respective database

2. In...

EasyBoy (8/31/2010)

---

Jeffrey Williams-493691 (8/30/2010)

---

Why are you shrinking databases? This should not be an automated process, or something that is done on a regular basis - even if not automated.

Databases...

How are you inserting this data? Are you using the GUI tool to insert the data, or are you using a query window and issuing insert statements?

Check the SQL...

Why are you shrinking databases? This should not be an automated process, or something that is done on a regular basis - even if not automated.

Databases will grow -...

First, why do you need to do this? It doesn't make sense to have created tables with IDENTITY and then disable it to insert data. The whole purpose...