If you create a share on your computer that the SQL server service account has read/write/modify permissions on you can reference a UNC in your backup statement to backup across...

That's avery open ended question.

I guess you are considering applying the latest service pack to your SQL Server.

All I can really is test thoroughly - make sure it behaves...

Do you have a filestream file group configured in your database?

Good, pleased its working for you.

It needs to be turned on at the instance level to

It can be done through the GUI or you can use sp_configure

EXEC sys.sp_configure N'filestream access level', N'2'

GO

RECONFIGURE WITH OVERRIDE

GO

Paul, that was the thinking, a shop asked me about using ORACLE Grid for monitoring, they are mainly an Oracle shop and need people to cross skill into SQL Server....

You can setup Alerts in the SQL Agent to alert you via email when the database grows.

It does sound like the compatibility mode has not been changed following the upgrade, follow the steps described above to change it to 90 and try again.

ravisamigo (3/21/2011)

---

Dear All,

1) If I have performed index rebuilding on one table in logshipped database/Primary database, will it effect the same to secondary database or do we need to again...

You said that the account has permissions on X:\SQL folder, does it definately have permissions on the systemmdb sub folder too?

How did you change the sql server service account? Did you use configuration manager or did you use the services.msc pluggin?

It's best to size your databases accordingly allowing for future growth.

Shrink databases will causes massive fragmentation in your indexes, which in turn can cause bad performance.

TheSQLGuru's technique of dropping all...

What recovery model is the database in and how frequently do you take transaction log backups?

Is possible the reindex casued the log to grow and your are not taking log...

Sorry mis-read the question. To backup an entire database you could use SSIS to export the data in a table to a file or another table, but there is no...

No it's not possible. I'm not aware of any Third Party Products that do this.

You could try restoring the whole database under a different name and then copying the rows...