SQL Server Administration
Can any one guide me on SQL Administration on topics i need to concentrate, ie, specific topics eg.Backup and restore.
2001-12-18
2 reads
Disaster Recovery (DR)
Dumping records from Msdb
Setting: Win 2K, SQL 2k We've dumped trans logs hourly from the beginning of the year. That causes our MSDB to grow rapidly and we don't need such extensive backup/restore info. How can I delete it from msdb? Bill
2001-12-13
4 reads
Backup to network drive failing.
I am backing up databases to a network directory, but recently my backups have sporadically started failing. The error that I am getting says"Can't open dump device '\\T01a2f1\csdba\mssql\T01CISRH1\msdbLogBackup.DAT', device error or device off line. Please consult the SQL Server error log for more details. (Message 3201). If I run the same backup sometimes later manually […]
2001-12-06
1 reads
Using EnumProcesses method
I am trying to use the EnumProcesses method of the SQLServer object in C++. I have found the documentation fairly useless - both the SQLServer online books and MSDN. I can make a connection OK to the server and then I have: hr = pSQLServer->EnumProcesses(ppResults, szWho, lWho); With the arguments defined as: LPSQLDMOQUERYRESULTS* ppResults = […]
2001-11-06
5 reads
SELECT TOP doesn't work
The databases that were upgraded from 6.5 to 7.0 don't seem to support this select statement. All others are fine! John Zacharkan
2001-11-05
4 reads
Importing/comparing data from Access to SQLServer7
Hey there, We have converted a couple of access databases which our client was using to track customer data (100 fields) into SQL Server 7 datasource and provided them a web interface to the data. The current datasource is well-formed and normalized and the access DBs were not. Now several months later, someone forgot to […]
2001-10-31
Multiserver administration
Hello all! I have master server (Msrv) and target server (T1). The problem is that I need to start job_t on target server and if it completes successfully -- then start job_M on master server. No idea how to do this, so I've to ask your advice. All servers run MS SQL Srv 7.0, SP […]
2001-10-31
2 reads
Restore
I did a restore of databases to a disaster recovery box. Everything came over fine except the security because it was stored in the master of the production box. The disaster recover box has a master that I cant mess with so basically my question is how do I script out the logins from the […]
2001-10-25
1 reads
Problem restoring a SQL 7 DB onto SQL 2000
I have an automated process which generates Dynamic SQL to restore a database onto a second server (this is done due to having different locations for the logical devices on the second server and a variable filename for the dump). The Database being restored is a SQL 7 Database, loading into SQL 2000 SP1. The […]
2001-10-25
4 reads
Current option value
Could you please suggest how could I check current XACT_ABORT option vavue? Thanks, Serhiy
2001-10-24
2 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers