Viewing 15 posts - 331 through 345 (of 860 total)
forsqlserver (6/29/2011)
Dear Abhijit Thanks,I want the backed up database name with timestamp when backup command has run.
Just try yourself with the help of sys.dataabses
I hope you'll try.
June 29, 2011 at 5:23 am
odanwada (6/29/2011)
Thanks for u r reply... i changed my recovery model to simple and shrink the file that resolves my problem.
Have you done the database backup after you back to...
June 29, 2011 at 5:10 am
Rhox (6/28/2011)
In SQL2000 you could select the database objects in the import/export wizard, but seems it's gone...
June 28, 2011 at 6:00 am
No problem Moinudheen
June 28, 2011 at 5:51 am
What I noticed, and believe to be the issue, is that when I executed the sql statement:
ALTER DATABASE MyDB
SET SINGLE_USER
the database would hang. I was able to set it to...
June 28, 2011 at 5:46 am
mohammed moinudheen (6/28/2011)
looping myself
??
June 28, 2011 at 3:45 am
June 28, 2011 at 3:42 am
mnagasrikanth219 (6/24/2011)
I had a Sql job which is hung and later running for more than the time expected and their is custom error ( Error: 50000 Severity: 16 State: 1).So...
June 28, 2011 at 2:50 am
jshurak (6/27/2011)
I had restore a production database to a test server, so I used the Copy_Only option for both the...
June 28, 2011 at 2:25 am
sqluser_8119 (6/27/2011)
6/22/11 Full...
June 27, 2011 at 11:50 pm
@OLDCHAPPY
Read this link & white paper too. This will give an basic idea.
June 27, 2011 at 7:33 am
Ninja's_RGR'us (6/27/2011)
Jayanth_Kurup (6/27/2011)
is it possible to try backup log with truncate with no log followed by the database backup, important to backup the data soon after to prevent data loss.
If...
June 27, 2011 at 6:34 am
Check the log_reuse_wait_desc in sys.databases
what it returns
I suggest you to check Robert L. Davis's blog it'll give you good picture
http://www.sqlsoldier.com/wp/sqlserver/databasemirroringperformancecounters
June 27, 2011 at 6:16 am
Viewing 15 posts - 331 through 345 (of 860 total)