Viewing 15 posts - 13,066 through 13,080 (of 19,560 total)
Do you need the entire database?
Is this to go from production down to a QA environment?
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
July 28, 2010 at 11:37 pm
Log shipping between the two is not possible.
http://blogs.msdn.com/b/sanchan/archive/2006/02/12/530651.aspx
If you want to setup something to do a daily update between the two servers, I recommend an alternative process. You can...
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
July 28, 2010 at 11:25 pm
Are you trying to setup log shipping from the 2000 database to the 2005 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
July 28, 2010 at 11:14 pm
SSIS does not require that you enable ad hoc queries like that. OpenDataSource is not required in SSIS either.
You would create a data connection manager specifying a flat file...
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
July 28, 2010 at 11:05 pm
What if you have a transaction that is using the tempdb heavily and the disk fails? That is too much of a risk for me.
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
July 28, 2010 at 10:59 pm
Any other instances of SQL Server installed?
Any other error messages?
What SP Level is SQL Server?
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
July 28, 2010 at 10:54 pm
There is no need to do an offline backup.
Are you doing transaction log backups?
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
July 28, 2010 at 10:48 pm
That makes sense. Thanks for the correction.
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
July 28, 2010 at 10:31 pm
No. A full backup is taken while the database is online. What is the recovery model of your 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
July 28, 2010 at 10:27 pm
Interesting question. My first inclination was to answer no. Then I read this documentation that said that backups and restores are supported with snapshots in 2008 R2.
http://msdn.microsoft.com/en-us/library/ms189548.aspx
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
July 28, 2010 at 10:12 pm
You would only want / need to restore the latest full backup. Thus when you are ready to restore the database to the new server, perform a full backup...
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
July 28, 2010 at 10:05 pm
Nice hot button Steve. There needs to be some level of technical triage to scope out any actionable bugs. You wouldn't want your development and project management staff...
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
July 28, 2010 at 9:49 pm
Each database is different. There is no real set number of pages. Some indexes benefit substantially by defragging even if they have 100 pages.
The best advice is to...
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
July 28, 2010 at 9:42 pm
Do you have any services besides the database engine installed on this cluster such as SSIS or SSRS?
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
July 28, 2010 at 9:35 pm
Are you using the SQL Client with veritas or just the OS client?
If it is the SQL Client and if you have Veritas installed on the new server, then you...
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
July 28, 2010 at 9:27 pm
Viewing 15 posts - 13,066 through 13,080 (of 19,560 total)