Viewing 15 posts - 2,341 through 2,355 (of 2,904 total)
Or if you have installed Microsoft SQL Server, you should be able to find it at:
START>Programs>Microsoft SQL Server>Books OnLine
-SQLBill
December 10, 2003 at 1:33 pm
It might have been an issue with a driver or MDAC version. Reloading SP3a probably fixed the driver/MDAC problem.
But that's just a guess....
-SQLBill
December 10, 2003 at 11:33 am
If I were to do this, I would restore the 'archived' data to a new database name. That way I would have two databases, DB1 with the current data and...
December 9, 2003 at 11:13 am
It depends on how you do your backups. The 'native' SQL Server backups (using the BACKUP tsql command) work while the database is being used.
Using third-party backup tools, can require...
December 5, 2003 at 9:44 am
I'm against cross-posting. Why? I may see the post and submit my response only to find that in another forum someone posted a similar solution and you provided more information...
December 5, 2003 at 9:40 am
I was proposing the spelled-out version of the month since we have people from many different countries posting here. If the spelled-out version of the month is used there isn't...
December 4, 2003 at 12:06 pm
Yes. I originally created my backup jobs to go to the M drive. I just 'pulled up' my backup script, dropped the dump devices and readded them with the new...
December 4, 2003 at 7:58 am
How about STORING the data as CHAR or VARCHAR and when you need to do calculations, CAST the data to DECIMAL.
Not a 'pretty' solution, but you only need to store...
December 4, 2003 at 7:45 am
I just have mine go to a folder on the hard drive, then I use Veritas Backup Exec to copy those files to tape.
-SQLBill
November 21, 2003 at 1:00 pm
My understanding of the SIMPLE recovery model is that data can be recovered only to the last basckup.
That's partially correct...you are missing one word:
My understanding of the SIMPLE recovery model...
November 19, 2003 at 1:30 pm
No. It's all or nothing. Delete the whole file or none of it.
One solution is to rename the backup file daily/weekly/whatever. Then when you need to delete some of the...
November 19, 2003 at 1:26 pm
What does your SR DBA think an 'ADMIN DBA' job is?
From the title, it almost sounds like this is an 'administrative' job. Documentation type things.
-SQLBill
November 19, 2003 at 1:23 pm
Does it work if you use the IP address instead of the name?
If so, you probably have a DNS server problem.
-SQLBill
November 19, 2003 at 8:03 am
I assume by 'rolling back' you mean restoring.
But anyways...to do a 'point-in-time' restore, you need a FULL Backup and at least one transaction log backup (if you have more, they...
November 18, 2003 at 11:05 am
Viewing 15 posts - 2,341 through 2,355 (of 2,904 total)