Viewing 15 posts - 6,091 through 6,105 (of 19,560 total)
Good question Steve.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 28, 2012 at 9:46 am
The way I understand it, you are trying to move data from production to dev to test etc?
Is that accurate?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2012 at 4:35 pm
Evil Kraig F (6/27/2012)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2012 at 4:15 pm
I may depending on the need and with a lot of caution. If I did run it, I would monitor performance and be on top of any issues that...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2012 at 3:04 pm
Try this query for the backup history and post the results
DECLARE @DBName varchar(128)
SET @DBName = 'YourDBNameHere'
Select a.database_name,a.backup_start_date
,BackupPath = b.physical_device_name
,BackupSizeMB = a.backup_size/1024/1024
,CompressedBackMB = a.compressed_backup_size/1024/1024
From msdb.dbo.backupset a
INNER JOIN msdb.dbo.backupmediafamily b
ON a.media_set_id...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2012 at 2:41 pm
Are you sure it was servers and not just databases?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2012 at 2:01 pm
Steve Jones - SSC Editor (6/27/2012)
Holy crap you guys and gals post a lot. Had 20+ pages in this thread from a week off.
And it has been a light week.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2012 at 2:00 pm
d'oh
I missed a piece in the documentation. addlogin is for SQL logins only. Grantlogin is for adding windows accounts. That is the reason you were getting the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2012 at 1:28 pm
have you tried issuing a manual checkpoint to that database?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2012 at 1:24 pm
Will you post the results of this query
Declare @DBName varchar(128)
Set @DBName = 'YourDBHere'
Select db_name(database_id) as DBName,name as LogicalName,physical_name,type_desc as FileType
,Size*8/1024 as FileSizeMB
From sys.master_files
Where db_name(database_id) = @DBName
Just replace YourDBHere with the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2012 at 1:04 pm
And when you use the brackets?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2012 at 12:50 pm
Thanks Gail. I was sure it would work as you said.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2012 at 12:49 pm
The method chosen (adding to what Ron said) will partly depend on the information you can provide back.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2012 at 12:19 pm
I think we need a lot more info than what has been provided to assist in db design questions such as this.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2012 at 12:17 pm
What is the exact error you received?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 27, 2012 at 11:54 am
Viewing 15 posts - 6,091 through 6,105 (of 19,560 total)