Viewing 15 posts - 16 through 30 (of 456 total)
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...
August 21, 2012 at 5:05 am
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...
August 20, 2012 at 9:10 am
Do you have a filestream file group configured in your database?
December 5, 2011 at 4:01 pm
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
December 5, 2011 at 6:43 am
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....
June 23, 2011 at 6:36 am
You can setup Alerts in the SQL Agent to alert you via email when the database grows.
March 25, 2011 at 4:19 am
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.
March 21, 2011 at 2:36 am
ravisamigo (3/21/2011)
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...
March 21, 2011 at 2:32 am
You said that the account has permissions on X:\SQL folder, does it definately have permissions on the systemmdb sub folder too?
March 19, 2011 at 7:08 am
How did you change the sql server service account? Did you use configuration manager or did you use the services.msc pluggin?
March 19, 2011 at 6:53 am
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...
February 17, 2011 at 1:54 pm
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...
February 16, 2011 at 11:11 am
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...
February 15, 2011 at 4:40 am
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...
February 15, 2011 at 4:39 am
Viewing 15 posts - 16 through 30 (of 456 total)