I have a database on SQL2000 which ran out of diskspace and went suspect. I've added more temporary disks to the server and managed to get a recovery using sp_add_data_files_recover_supsect_db. It...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22516211.html
I have table called databases im going from here to
sys files
select * from DATABASES
inner join MASTER.DBO.SYSDATABASES.name = DATABASES.Databasename
then i want to go this table and get...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21835147.html
I must be missing something. I found a bunch of questions on this site regarding reducing the size of a Log file. Mine currently is at about 2 gig. I do a backup once a week and it stays basically ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20654362.html
I Am trying to do something like the following
drop function t
go
create function t(@id int) returns @retTable table (id int)
as
begin
insert @retTable select fileid from sysfiles where ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21017127.html
Hi,
I query the sysfiles to look in more details about the Tlog file as below.
USE [TRXX]
GO
SELECT *
FROM sysfiles
WHERE name LIKE '%LOG%'
GO
and below are part of the column result...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22505972.html
Our ERP system (JDE) has three enviroments each in it's own SQL Database. The easiest way to refresh the production data to the prototype enviroment is to backup the production database (PS_Prod) a...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23006871.html
I've inherited a database that had relatively large log files. Datafiles: 23GB, 11GB, 9GB. Log files: 25GB, 13GB, 10GB. I wanted to get this fixed. I backed up the databases and then tried to run D...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23500866.html
