Viewing 15 posts - 331 through 345 (of 859 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.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
June 29, 2011 at 5:23 am
Restoring a database from higher version to lower version of SQL server[/url]
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
June 29, 2011 at 5:14 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...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
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...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
June 28, 2011 at 6:00 am
No problem Moinudheen
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
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...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
June 28, 2011 at 5:46 am
mohammed moinudheen (6/28/2011)
looping myself
??
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
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...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
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...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
June 28, 2011 at 2:25 am
sqluser_8119 (6/27/2011)
6/22/11 Full...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
June 27, 2011 at 11:50 pm
@OLDCHAPPY
Read this link & white paper too. This will give an basic idea.
Choose the good SQL server Disaster Recovery plan[/url]
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
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...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
June 27, 2011 at 6:34 am
Lowell there you are man!
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
June 27, 2011 at 6:22 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
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
June 27, 2011 at 6:16 am
Viewing 15 posts - 331 through 345 (of 859 total)