Viewing 15 posts - 1,486 through 1,500 (of 2,904 total)
A little late now, but in the future please check the BOL for correct syntax. For SP_RENAME it says that the new name MUST be a ONE part name. In...
November 3, 2005 at 7:29 am
I don't understand your problem. You say you can't 'CATCH' these dates:
tarihb=01/11/2005 06:00:00
tarih=01/11/2005 20:00:00
But you say your script should catch date/times between:
(tarih '01/11/2005 16:00:00') BETWEEN (tarihB ...
November 2, 2005 at 11:15 am
1. There is no DECODE in SQL Server.
2. SQL Server uses single quotes. I believe Oracle uses double quotes. So for it to work in SQL Server, you need...
November 2, 2005 at 6:51 am
Quote from original poster: SQL EM db properties and sp_helpfile shows it's still 20GB
That says SQL EM (Enterprise Manager).
I still say the poster needs to run DBCC UPDATEUSAGE.
-SQLBill
November 1, 2005 at 11:26 am
My largest database is 245+ GB and I don't have scheduled reboots. I reboot on an "as needed" basis. Updates, Service Packs, anything that might require a reboot...
October 31, 2005 at 11:21 am
Are y1 and y2 variables? If so, they should be @y1 and @y2.
-SQLBill
October 31, 2005 at 11:18 am
You might want to try http://www.tek-tips.com. They have Oracle forums.
-SQLBill
October 31, 2005 at 7:25 am
Ahhhh, more information. Yes, you will have problems if Backup Exec is trying to copy the files while SQL Server is backing up to those files. Both can not use...
October 31, 2005 at 7:22 am
I use it all the time to 'fix' Enterprise Manager and have it reflect the updated information.
-SQLBill
October 31, 2005 at 7:15 am
BTW-if that is the case, check out Example 2 in the BOL under RESTORE DATABASE for an example of restoring from a specific part of the backup.
-SQLBill
October 28, 2005 at 1:18 pm
When you do your differential backup, do you use WITH INIT or WITH NOINIT (overwrite or append)?
If you are appending (WITH NOINIT), then the restore is trying to use an...
October 28, 2005 at 1:14 pm
This 'no downtime' brings up another question....what service pack level is your SQL Server at? Applying a service pack (and some hotfixes) requires a reboot (downtime).
-SQLBill
October 28, 2005 at 1:08 pm
Run DBCC UPDATEUSAGE ('dbname'). Replace dbname with the actual database name.
-SQLBill
October 28, 2005 at 1:05 pm
What do you mean the logs were backed up and truncated? Please don't tell me you truncate the logs every time you back them up.
From Microsoft and the BOL...after truncating...
October 28, 2005 at 11:17 am
Quote: Imagine your boss asks you to setup a Windows 2003 domain. know nothing about it, so you join a forum to find out how. Free and quick information. You...
October 28, 2005 at 8:09 am
Viewing 15 posts - 1,486 through 1,500 (of 2,904 total)