Viewing 15 posts - 16 through 30 (of 110 total)
I think so. I always configure Max Memory for SQL Server.
February 4, 2011 at 9:30 am
mw112009 (2/3/2011)
Is there one single command that will start to rebuild all the indexes ?
(We have about 2000 tables. Some of the tables have upto 20 indexes....
February 3, 2011 at 12:53 pm
TheSQLGuru (2/2/2011)
one last thing - did you check the Recycle bin on the backup server just in case?
Sorry to reply it late.
I did check Recycle bin both on Primary and...
February 3, 2011 at 11:53 am
TheSQLGuru (2/2/2011)
Oh, and may I suggest you set up some task to check this system more frequently than every 3 days??
I am sorry to reply late.
I am afraid even though...
February 3, 2011 at 11:49 am
Perry Whittle (1/31/2011)
has someone taken a full backup of this database by any chance?
No, I have checked backup logs, no full backup happened.
February 1, 2011 at 9:14 am
AlexSQLForums (1/31/2011)
This is usually caused by server times being slightly off or a huge transaction log taking time backing up.
This log backup is 260k and took less than 10 seconds....
February 1, 2011 at 9:12 am
I may need to clarify my question.
I open SSMS in SQL Server 2008, try to create a new policy. From "Evaluation Mode" interface, It is only listing two mode "On...
September 21, 2010 at 9:18 am
sqlbuddy123 (9/16/2010)
Instead you can check who all has the execute permissions on the stored proc in the SSMS.
Thank you for quick response.
In fact, I did the same thing. As long...
September 16, 2010 at 12:18 pm
Just update this.
These two errors are not SQL Server Permission issue.
First error is about OS level permission.
Second Error is about ASP recordset.
September 16, 2010 at 11:33 am
Delete table, even though drop table, part of records are still in that page(extent).
From testing, does that mean "encrypt bak" is the only way to hide that part of records?
September 15, 2010 at 1:17 pm
I just tested that insert into 1000000 records to test table (test1) and insert 100 records into another table (Test2).
Then truncate both. backup database.
From Backup file,Test1 was less than 1000000...
September 15, 2010 at 1:07 pm
Craig Farrell (9/15/2010)
You might try a shrink prior to the backup, that should actually clear the deallocated pages.
I am going to try to test shrink the file. let you know...
September 15, 2010 at 12:52 pm
David Webb-200187 (9/15/2010)
September 15, 2010 at 12:49 pm
I checked the permision again and again and again. The permission had no problem.
September 15, 2010 at 11:00 am
Viewing 15 posts - 16 through 30 (of 110 total)